| Excel软件在《试验设计与分析》课程教学中的应用 |
| |
| 引用本文： | 刘旭华,杜晓林,张录达.Excel软件在《试验设计与分析》课程教学中的应用[J].天津农学院学报,2010,17(2):36-39. |
| |
| 作者姓名： | 刘旭华 杜晓林 张录达 |
| |
| 作者单位： | 1. 中国农业大学,理学院,北京100193
2. 北京农学院,基础科学系,北京,102206 |
| |
| 基金项目： | 中国农业大学2008年研究生重点课程建设项目"'多元统计分析及其应用'重点课程建设" |
| |
| 摘 要： | 根据试验设计与分析课程中设计表格多、数据分析规律性强的特点,利用Excel软件的表格化和强大的统计计算功能,在Excel中制作试验设计与数据分析模板,实现设计与数据分析过程动态可视化,能够极大地提高教学效率,并方便实际应用。本文以一个二水平正交设计为例制作正交表L8(27)的应用模板,说明了模板的制作与应用过程。
|
| 关 键 词： | 试验设计与分析 Excel 教学 模板 |
Application of Excel Software in Teaching Experimental Design and Analysis |
| |
| LIU Xu-hua,DU Xiao-lin,ZHANG Lu-da.Application of Excel Software in Teaching Experimental Design and Analysis[J].Journal of Tianjin Agricultural College,2010,17(2):36-39. |
| |
| Authors: | LIU Xu-hua DU Xiao-lin ZHANG Lu-da |
| |
| Institution: | 1.College of Science,China Agriculture University,Beijing 100083,China;2.Department of Basic Science,Beijing Agricultural College,Beijing 102206,China) |
| |
| Abstract: | 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. |
| |
| Keywords: | Excel |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
