According to a recent study, the reliability of computer-based mathematical calculations and projections is more critical than ever. With widespread use in financial markets, military and government security, and everyday life, an incorrect projection could severely affect society.
The researchers identified inconsistencies and errors in spreadsheets, some of which have yet to be corrected by developers. In particular, they found that incorrect use of parentheses can lead to erroneous or false results. Despite attempts to notify developers of these issues, many errors persist in software updates and new versions.
These findings are concerning, as structural flaws in computer systems’ mathematical and logical foundations are hidden from the average user and can only be identified by individuals with specialized knowledge. This is not the first study to reveal errors in spreadsheets – previous research has shown that different expressions can be treated as the same in these systems, leading to incorrect calculations.
As our reliance on technology grows, it is essential to recognize the potential for error in complex systems. The researchers suggest that ongoing identification and labeling of inconsistencies is necessary to prevent future problems.
Summary of: Electronic Spreadsheets: Inconsistencies, Errors and Discrepancies, by Jonas de Medeiros et al.
Link to the article: https://journals.modernsciences.org/index.php/msj/article/view/24
References
- de Medeiros, J., & Gonçalves, R. A. (2023). Electronic Spreadsheets: Inconsistencies, Errors and Discrepancies. Modern Sciences Journal, 12(1). https://doi.org/10.57184/msj.v12i1.24
