基于Excel的样本均值统计特征模拟
作者：周俊祥
来源：《电脑知识与技术》2010年第18期
        摘要excel的随机数函数:样本均值统计规律是统计推断的核心概念,但是因为它比较抽象,所以传统教学上强调应用有余,而理解深度不足。该文介绍了统计推断的基础知识,结合Galton钉板实验,运用计算机辅助手段,详细探讨并给出了样本均值统计特征直观形象的诠释。
        关键词:样本均值;中心极限定理;随机数;excel;正态分布
        中图分类号:O212文献标识码:A 文章编号:1009-3044(2010)18-5055-02
       
        Statistical Characteristics of the Sample Mean Based on Excel
        ZHOU Jun-xiang
        (Computer Science Department, ShangQiu Normal University, Shangqiu 47600, China)
        Abstract: The statistical law of the sample mean is a core concept of the statistical inference, However, because it is abstract, therefore, in traditional teaching, emphasizing its application more, but not enough to understand the depth of the law.This article describes the basics of the statistical inference, combined with Galton nail plate experiments, use of computer-aided tools, discussed in detail and gives the statistical characteristics of the sample mean visual image interpretation.