Excel方差分析在轧辊测量数据处理中的应用

Application of variance analysis of Excel in measured date process of roller

结合轧辊测量数据特点,以方差分析为例,研究怎样用excel完成简单统计分析的方法,及完成单因素和双因素方差分析,通过一些实例介绍了利用excel对轧辊测量数据的处理方法。

On the basis of measured date of roller, take the analysis of variance as example, this article introduces how to complete statistic analysis by Excel 2003. Both One- way analysis of variance and Two- way analysis of variance can be completed. Excel 2003 can be used for simply statistic analysis conveniently.