Utilising Microsoft Excel and VBA to Develop Learning Tool for Statistics Education

Abstract

Statistics courses are vital across scientific and non-scientific disciplines, yet many students struggle with fundamental concepts, leading to high failure rates and difficulties in applying statistical techniques. Addressing these challenges, this paper introduces HypothEase, an innovative learning tool developed using Microsoft Excel and Visual Basic for Applications (VBA), designed to enhance students' understanding of hypothesis testing. HypothEase offers a user-friendly interface and interactive features to facilitate self-guided learning of key statistical concepts, including hypothesis formulation, critical value determination, and test statistic calculation. The tool provides automated feedback and practical exercises, aiming to improve comprehension and reduce statistics anxiety among students. The development process involved iterative testing and refinement based on educator and student feedback. Initial results suggest that HypothEase significantly aids in mastering hypothesis testing by providing a comprehensive and accessible learning experience. This approach highlights the potential of integrating technology into statistical education, offering a cost-effective and engaging alternative to traditional methods.