首页 | 本学科首页   官方微博 | 高级检索  
     检索      

Excel中方差分析的应用
引用本文:石小云,秦彦.Excel中方差分析的应用[J].中南林学院学报,2006,26(1):117-119.
作者姓名:石小云  秦彦
作者单位:中南林业科技大学现代实验与技术中心,湖南长沙410004
摘    要:方差分析是数理统计中常采用的一种方法.通过实例介绍了如何使用Excel中数据分析工具进行方差分析的方法;实现了数据分析和处理的快捷、准确和直观;与以往的手工处理和查表计算等方法相比较,具有重大革新和改进,既有利于提高数据处理效率,又降低了试验成本.

关 键 词:Excel  方差分析  数据分析工具  应用
收稿时间:06 8 2005 12:00AM

Application of AN OVA in Excel
SHI Xiao-yun,QIN Yan.Application of AN OVA in Excel[J].Journal of Central South Forestry University,2006,26(1):117-119.
Authors:SHI Xiao-yun  QIN Yan
Abstract:ANOVA is an effective method used in mathematics statistics. This paper introduces a method to make ANOVA by means of the data analysis tool in Excel ,which can make data processing much faster, more accurate and visual. It is really an innovation and progress compared to the old methods such as calculating by hand or tables. It is also advantageous to improving the efficiency of data treatment as well as reducing the experimental cost.
Keywords:Excel  analysis of variance  data analysis tool  application
本文献已被 维普 等数据库收录!
设为首页 | 免责声明 | 关于勤云 | 加入收藏

Copyright©北京勤云科技发展有限公司  京ICP备09084417号