Excelia como Herramienta para la Investigación Científica en Escala Likert

Excelia as a Tool for Scientific Research on a Likert Scale

Abstract

Statistical software aims to automate the numerical operations required for the processing and statistical analysis of data from scientific research, using a Likert-based instrument, usually with five response options. The objective of this paper is to describe the different applications for the design, programming, and construction of a digital techno-educational resource with added values ​​to Excel, such as Excelia, to carry out descriptive and inferential statistical processing based on primary data generated from research for the automation of numerical operations. The methodology used was documentary, descriptive, and applied. Excelia was built using some of Excel's own functions, supported by logical functions and mathematical devices. The result is applications that can be combined and customized according to the interests of researchers, teachers, and students, grouped into three categories: statistical calculator, data processor, and instructional resource. Excelia stands out as a tool of interest due to its multiple benefits: Among these are its ability to optimize time and ease of use, as its intuitive design allows the user to easily enter data. Afterward, all that remains is to interpret the results within the theoretical context, which streamlines analysis and decision-making. Thanks to its efficiency and accessibility, it becomes an ideal option for those seeking a practical and effective solution.