MATHEMATICAL ERROR IN THE MICROSOFT EXCEL PROGRAM “MODE” FUNCTION, ITS IMPLICATIONS AND POSSIBLE CORRECTIONS

Abstract

INTRODUCTION: Mathematics is a science that permeates several areas of knowledge and is fundamental to understanding the world around us. Among its branches, we have statistics, whose function consists of organizing a list (set of raw data) and extracting significant data from them, such as the arithmetic mean, mode, median, sample standard deviation, and population standard deviation, among other calculations. This article discusses the importance of statistics in the contemporary world, with an emphasis on the concept of the mode means, also focusing on its practical applications for educators, students, and various professionals; it also addresses the impacts of calculation errors arising from Microsoft's Excel spreadsheet. Finally, practical solutions will be presented to correct these inconsistencies, using VBA (Visual Basic for Applications).