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.
Shi hai-bo
Beijng inst.of architectural engineering ,Beijing 100044
国际会议
International Conference on Management and Service Science(2011年第五届管理与服务科学国际会议 MASS 2011)
武汉
英文
1-3
2011-08-12（万方平台首次上网日期，不代表论文的发表时间）