Applying Excel VBA to Implement Comparison among Physical Experiment Data

摘要

In many physical education teaching experiments, we often need to compare the difference among all the data. When doing these comparisons, variance components method has been our indispensable tool. However, even though the Excel in Microsoft Office has already covered one-factor analysis of variance, it is still lack of multiple-comparison function. Our research works out a Excel tool which has both function. We insert data analysis tool into the Excel, and then take the advantage of VBA language to accomplish the judgment function of data-analysis. In this way, we can make one-factor analysis of variance and multiple-comparison at the same time, in other words, it enables us to compare the different groups of data. This research reset and improve the data-analysis tool though VBA program and Excel. We simplify the Operating System and optimize calculation procedure. Our invention can accomplish the comparison among different samples, which, creates a more accurate and more convenient tool to make physical education data-analysis.