摘要
Excel在统计分析中是一个非常有用的应用软件,在试验统计分析实验教学中利用Excel能够快速得出分析结果,减少手工计算的误差,从而提高实验教学质量。本文介绍了在试验统计分析实验教学中,使用Excel进行假设检验、方差分析、回归与相关分析的具体操作方法,并举例进行了实例运算。
Excel statistic analysis is a very useful application software. It is easy to get analysis results,reduce calculative error and improve the teaching quality by using Excel in teaching statistic analysis of experiments. The methods of using Excel in test of hypothesis ,analysis of variance ,regression and correlation in teaching statistic analysis of experiments were introduced, and the examples of operation by using Excel were given in this paper.
出处
《河南科技学院学报》
2009年第3期139-141,共3页
Journal of Henan Institute of Science and Technology(Natural Science Edition)
基金
河南省高校创新人才培养工程(豫教高[2005]126号)
关键词
EXCEL
统计分析
实验教学
Excel
statistic analysis
experiments teaching