| 基于Microsoft Excel表的有重复正交试验结果的方差分析 |
| |
| 引用本文： | 陈宗礼,陈昱宇.基于Microsoft Excel表的有重复正交试验结果的方差分析[J].延安大学学报(自然科学版),2013(4):92-96,101. |
| |
| 作者姓名： | 陈宗礼 陈昱宇 |
| |
| 作者单位： | [1]陕西省红枣重点实验室 [2]延安大学生命科学学院 [3]延安市宝塔区公安局,陕西延安716000 |
| |
| 基金项目： | 陕西省高水平大学建设专项资金（2012SXTS06）;延安大学重点学科建设项目（YDF8200223）;延安大学遗传与细胞生物学教学团队建设项目（YDF100002） |
| |
| 摘 要： | 基于Microsoft Excel提供的常用函数、数学与三角函数以及统计函数的计算描述统计量，以本实验室大枣粗多糖热水浸提的L9（3^4）正交试验的测试结果为例，叙述了利用Microsoft Excel表开展有重复正交试验结果的方差分析的方法与步骤。本文建立的用EXCEL表进行方差分析的程序与方法可扩展应用到正交设计、随机区组设计、裂区设计等试验结果的统计分析中，在实际的研究与教学工作中具有快捷和方便运用的普遍意义。
|
| 关 键 词： | Excel 有重复正交试验 方差分析 |
Variance Analysis with Microsoft Excel Table for Repeated-Orthogonal Experiment Results |
| |
| CHEN Zong-li,CHEN Yu-yu.Variance Analysis with Microsoft Excel Table for Repeated-Orthogonal Experiment Results[J].Journal of Yan'an University(Natural Science Edition),2013(4):92-96,101. |
| |
| Authors: | CHEN Zong-li CHEN Yu-yu |
| |
| Institution: | 1. Shaanxi Key Laboratory of Chinese Jujube ;2. College of Life Science ,Yanan University, Yanan 716000, China; 3. The Public Bureau In Bao - Ta - Qu Yanan, Yanan 716000, China) |
| |
| Abstract: | Based on Microsoft Excel provide calculation describe statistics of commonly used functions, mathematics and trigonometric functions had described the method and steps of variance analysis that use of Microsoft Excel table carry on has repeated the orthogonal experiment results, by in ourself laboratory L9 （34） orthogonal experiment re- sults of hot water method extracted jujube crude polysaccharide for example.. This paper established programs and method with EXCEL table carry on variance analysis can be extended to the statistical analysis of the orthogonal design, randomized blocks design, split plot design etc test results, in the actual research and teaching have universal significance, of quicker and convenient use. |
| |
| Keywords: | Excel has repeated the orthogonal experiment variance analysis |
| 本文献已被 维普 等数据库收录！ |
