在Excel表中进行多元方差分析  

Multiple Covariance Analysis in Microsoft Excel 2000

作　　者：胡想顺[1] 刘小凤[1] 赵惠燕[1] 李东鸿[1] 胡祖庆[1] 

机构地区：[1]西北农林科技大学植物保护学院,陕西杨凌712100

出　　处：《西北农业学报》2006年第2期174-179,共6页Acta Agriculturae Boreali-occidentalis Sinica

基　　金：中德两国农业部合作项目(02/03);西北农林科技大学青年专项基金(080807)

摘　　要：应用函数编辑器和简单的复制、粘贴功能即可在Excel表中实现较为复杂的多元方差分析,可用到的命令有求和命令“SUM”,计数器命令“COUNT”,求平均值命令“AVERAGE”,对应数据相乘的积的求和命令“SUMPRODUCT”,矩阵相乘命令“MMULT”以及求解矩阵的行列式的值的命令“MDETERM”。并给出了一个在Excel表中进行双因素不等重复处理的多元方差分析和多重比较的例子。Used functions editor and simple copy, stick function could do multiple coveriance analysis in Microsoft Excel table. The order include total sum order ＂SUM＂, count order ＂COUNT＂, mean order ＂AVERAGE＂, and the order ＂SUMPRODUCT＂that about count the total sum of some data＇s product which some groups number corresponding multiply; the order ＂MMULT＂ that used to count product of two matrixes; the order ＂MDETERM＂ that used to count the determinant value of one matrix. An example about two factors multiple covariance analysis and multiple comparisons which have different repetition in Microsoft Excel 2000 had been given.

关 键 词：MICROSOFT EXCEL 2000 函数编辑器 多元方差分析 生物统计 

分 类 号：TP317.3[自动化与计算机技术—计算机软件与理论]