Excel应用于方差分析的实训教学探究

针对国内应用型本科湖南文理学院院校概率统计课程的实训教学越来越多地注重Excel作为初学者操作平台的现状,就非平衡数据和嵌套结构的数据在Excel中实现方差分析的过程进行探究。突出以组内矫正数为主线整理数据后简化平方和分解公式的理念,使得Excel中进行方差分析时,数据整理流程完全格式化,平方和的分解步骤更为简洁,自由度分解、F检验等步骤不再繁琐,为非统计专业本科阶段借助Excel电子表格率先实现概率统计课程实训教学的宽口径模式提供借鉴。

Teaching Inquiry on the Application of Excel in Variance Analysis

With more practical teaching of domestic undergraduates’probability and statistics course focusing on the Excel, an operating platform for beginners, the variance analysis process of unbalanced data and nested structure data in the Excel was explored. The idea on correction number within the group after sorting data and simplified square sum decomposition formula was highlighted to make the data flow full formatting, the decomposition process more concise and the freedom decomposition and F test step less cumbersome in the variance analysis process of Excel, which provided a wide aperture mode that using Excel electronic form to realize practical teaching for non-statistics professional undergraduates’probability and statistics course.