| 利用EXCEL做复杂的方差分析 |
| |
| 引用本文： | 郑乃千.利用EXCEL做复杂的方差分析[J].晋中学院学报,2009,26(3):90-92. |
| |
| 作者姓名： | 郑乃千 |
| |
| 作者单位： | 晋中学院,后勤集团公司,山西,晋中,030600 |
| |
| 摘 要： | 方差分析是一种重要的统计分析方法,在实际工作中应用广泛,但其计算过程比较复杂,手工计算难以完成.利用EXCEL中的函数和分析工具,灵活构造算法,可以实现方差分析,不仅操作简便,还可大大提高分析的精度和效率.
|
| 关 键 词： | 数据分析 方差 标准差 Excel函数 |
Making Complex Variance Analysis through Excel Function |
| |
| ZHENG Nai-qian.Making Complex Variance Analysis through Excel Function[J].Journal of Jinzhong University,2009,26(3):90-92. |
| |
| Authors: | ZHENG Nai-qian |
| |
| Institution: | Administrative Department of University's Property;Jinzhong University;Jinzhong 030600;China |
| |
| Abstract: | Variance analysis is an important device for statistic analysis,which has been widely adopted in practical work.However,the calculation is so complex that it is difficult to finish by hand.The variance analysis can be made by using the functions and analysis tools in Excel combined with flexible calculating methods.It is not only simple,but also makes the analysis accurate and effective to a great extent. |
| |
| Keywords: | data analysis variance standard deviation Excel function |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
