Excel软件在《试验设计与分析》课程教学中的应用

Application of Excel Software in Teaching Experimental Design and Analysis

根据试验设计与分析课程中设计表格多、数据分析规律性强的特点,利用Excel软件的表格化和强大的统计计算功能,在Excel中制作试验设计与数据分析模板,实现设计与数据分析过程动态可视化,能够极大地提高教学效率,并方便实际应用。本文以一个二水平正交设计为例制作正交表L8(27)的应用模板,说明了模板的制作与应用过程。

In the course of Experimental Design and Analysis,there are many forms for experiments＇ design,but data analysis of the designs has much regularity.Based on these characters of the course,using Excel＇s powerful form and statistical calculation functions,the experimental design and data analysis template in Excel is produced,the dynamic visualization of the design and data analysis realized,then the teaching efficiency is greatly improved,and the practical application is facilitated.In this article,it is adopted a two-level orthogonal design as an example,and the template of the orthogonal design table L8（27）is produced,the process of template＇s production and application is demonstrated.