Excel应用于显著性检验的实训过程探究  

Discussion on the Training Process of the Excel Application in the Significance Test

作　　者：万海清[1] 赵东海[1] 

机构地区：[1]湖南文理学院生命科学学院,常德415000

出　　处：《农业网络信息》2011年第6期13-16,共4页Agriculture Network Information

基　　金：湖南文理学院芙蓉学院教改项目"使用Excel提升生物统计课程实践教学体系的有效性研究"(编号201015);湖南文理学院校级教改项目"三非专业概率统计课程构建实践教学新体系研究"(编号201138)

摘　　要：在Excel环境中采取编算式并调用粘贴函数,逐步实现了单个或两个样本的显著性检验过程。其中的数据分析软件运行T检验、F检验过程的结果进行比较,发现其中的不同之处有时会造成误判。明确这些差别有助于澄清显著性检验的每一个步骤和细节,正确运用Excel界面编程或通过运行数据分析软件提高效率。Excel界面用作生物统计课程实训操作平台,具有毋庸置疑的价值和优势,对于初学者,使用Excel电子表格逐步实现各种统计检验过程取得的教学效果,其他任何专业统计软件都无法替代。Under the Excel,by compiled equation and calling paste function,significance test procedures of one or two sample were realized.By comparison of T-Test and F test results by the use of data analysis software,it was found that the differences can sometimes result in wrong judgment.Understanding these differences will help to clarify the each step and detail of significance test,and by the correct use of Excel programming interface,or by running the data analysis software,the efficiency was improved.Excel interface as biological statistics course training platform showed the value and advantages.For beginners,by using the Excel spreadsheet,a variety of statistical tests effects of the teaching process was gradually achieved,which any other professional statistical software can not be replaced.

关 键 词：单元格块 观测值 变量 粘贴函数 T-TEST 

分 类 号：TP39[自动化与计算机技术—计算机应用技术]