应用Excel进行畜禽性状相关和回归分析  

The Application of Excel in the Correlation and Regression Analysis For Teaching of Biometry

作　　者：林树茂[1] 吕敏芝[1] 田允波[1] 郭金彪[1] 何勇军[1] 曾书琴[1] 何兰花[1] 

机构地区：[1]佛山科学技术学院动物科学系,广东南海528200

出　　处：《家畜生态学报》2005年第4期89-90,共2页Journal of Domestic Animal Ecology

摘　　要：在科研及教学实践中,成熟的统计分析软件正在被广泛使用。M icrosoft Excel是功能强大的专业电子表格系统。本文介绍了如何使用Excel 2000的“数据分析”工具进行相关和回归分析。在教学中利用Excel可以较方便地完成复杂的统计计算。The mature statistical analysis software is widely used in the scientific research and teaching nowadays. Microsoft Excel is apowerful professional electronic table software. This paper introduces how to use “the analysis of data”tool which provided by Excel 2000 to complete correlation and regression analo ysis. Microsoft Excel can be used to deal with large complicated statistic computations conveniently in the teaching.

关 键 词：生物统计 相关和回归分析 EXCEL 

分 类 号：S811.5[农业科学—畜牧学]