3
正态分布数值
0 0.002654428 1 0.007484677 0 0.01864544 1 0.041036437 6 0.079792872 8 0.137074285
7 52.933 8 53.339 9 53.744 10 54.150 11 54.556 12 54.961 13 55.367 14 55.772 15 56.178 16 56.583 17 56.989 18 57.394 19 57.800 20 58.206
54.5
54.7
55.3
55.9
54.5
54.7
55.3
56.1
54.5
54.7
55.3
56.1
54.5
54.7
55.3
56.1
54.5
54.7
55.3
56.1
54.5
54.7
55.3
56.1
54.5
54.9
55.5
56.1
54.5
54.9
55.5
56.1
54.5
54.9
55.5
56.5
54.5
54.9
54.5
55.1
55.7
57.9
分析步骤 一、
最大值
57.9
最小值
50.6
平均值
54.09633
极差
7.3
标准差（样本) 1.152235
组数
18
组距
0.406
分组： “分组”就是确定直方图的横轴坐标起止范围和每个小组的起止位置。选一个比最小值小的一个恰当的值作为第一个组的起始坐标，然后依次加上
“分组组距”，直到最后一个数据值比“最大值”大为止。这时的实际分组数量可能与计算的“分组数”有一点正常的差别。类似如下图。
EXCEL 制作正态 分布曲线图
原始数据
50.6 51.7 51.9 51.9 52.1 52.1 52.1 52.1 52.3 52.3 52.5 52.5 52.5 52.5 52.5 52.5 52.7 52.7 52.7 52.7 52.7 52.7 52.7 52.7 52.7 52.7 52.7 52.7 52.7 52.9
分析步骤 二、
1. 分组 2.计算每组的频率 3.计算每组的正态分布数值
注：函数应用
1\ Frequency 数组输入 统计 条件 > x and <= x1 的个
数
2\ Norm.dist 计算一个数的正态分布数值
序号
12
分组
频率
1 50.500 2 50.906 3 51.311 4 51.717 5 52.122 6 52.528
55.1
55.7
54.3
54.7
55.1
55.7
54.3
54.7
55.1
55.7
54.3
54.7
55.1
55.7
54.3
54.7
55.1
55.7
54.3
54.7
55.1
55.7
54.3
54.7
55.1
55.7
54.3
54.7
55.3
55.7
54.3
54.7
55.3
55.9
54.3
54.7
55.3
55.9
4.画图（直方图与散布图）
50.000 70
51.000
52.000
53.000
54.000Байду номын сангаас
55.000
56.000
57.000
58.000
59.000 0.4
0.35 60
0.3 50
0.25 40
0.2 30
0.15
20 0.1
10 0.05
0
0
50.500 50.906 51.311 51.717 52.122 52.528 52.933 53.339 53.744 54.150 54.556 54.961 55.367 55.772 56.178 56.583 56.989 57.394 57.800 58.206
23 0.208039269 59 0.278953677 38 0.330458026 38 0.345858104 36 0.319798963 28 0.261248368 18 0.188550445 22 0.12022616 10 0.067727935
3 0.033708089 6 0.014821695 0 0.005757833 2 0.00197614 1 0.000599203
53.5
53.9
54.1
53.5
53.9
54.1
53.5
53.9
54.1
53.5
53.9
54.1
53.5
53.9
54.1
53.5
53.9
54.1
53.5
53.9
54.3
53.5
53.9
54.3
53.5
53.9
54.3
53.7
53.9
54.3
53.7
53.9
54.3
53.7
53.9
54.3
54.3
54.7
53.1
53.3
53.1
53.3
53.1
53.3
53.1
53.3
53.1
53.3
53.1
53.3
53.1
53.3
53.1
53.3
53.1
53.3
53.1
53.3
53.1
53.3
53.3
53.7
53.9
53.3
53.7
53.9
53.3
53.7
53.9
53.3
53.7
53.9
53.3
53.7
53.9
53.3
55.5
56.5
54.5
54.9
55.5
56.5
54.5
54.9
55.5
56.7
54.5
54.9
55.5
56.7
54.5
54.9
55.7
56.7
54.5
54.9
55.7
56.9
54.5
54.9
55.7
56.9
54.5
54.9
55.7
56.9
54.5
54.9
55.7
57.7
54.5
55.1
55.7
57.7
53.7
53.9
53.3
53.7
54.1
53.3
53.7
54.1
53.5
53.7
54.1
53.5
53.7
54.1
53.5
53.7
54.1
53.5
53.7
54.1
53.5
53.7
54.1
53.5
53.7
54.1
53.5
53.7
54.1
53.5
53.7
54.1
53.5
53.9
54.1
53.5
53.9
54.1
52.9
53.1
52.9
53.1
52.9
53.1
52.9
53.1
52.9
53.1
52.9
53.1
52.9
53.1
52.9
53.1
52.9
53.1
53.1
53.1
53.1
53.1
53.1
53.1
53.1
53.1
53.1
53.1
53.1
53.3
53.1
53.3
53.1
53.3
53.1
53.3
53.1
53.3