F分布的Excel构建与模拟

The Construction and Simulation of F-distribution by Using Microsoft Excel

F分布是一种常见的概率分布,在方差分析的统计推断中占有重要位置.对其分布曲线的特征如果只是简单的采用讲授法,通常难以激发学生的学习兴趣.利用Excel软件中的函数与VBA编程功能对该分布曲线进行构建和模拟,可以动态地展示F分布曲线随自由度变化而变化的基本规律,进而激发学生的学习兴趣,有效提高课堂教学效果.

F-distribution is a common probability distribution,which plays an important role in the statistical inference of ANOVA.It is usually difficult to arouse students’interest in learning if the characteristics of these distribution curves are simply taught by lecture method.Using the functions and VBA programming of Excel software to construct and simulate the distribution curves,we can dynamically display the basic law of the F-distribution curves changing with the degree of freedom,and then stimulate students’interest in learning,so as to improve the teaching effect efficiently.