2024年5月7日发(作者:)
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
52.9
52.9
52.9
52.9
52.9
52.9
52.9
52.9
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.1
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.1
53.1
53.1
53.1
53.1
53.1
53.1
53.1
53.1
53.1
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.3
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.5
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.7
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
53.9
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.1
54.3
54.3
54.3
54.3
54.3
54.3
54.3
54.3
54.3
54.3
54.3
54.3
54.3
54.3
54.3
54.3
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.5
54.7
54.7
54.7
54.7
54.7
54.7
54.7
54.7
54.7
54.7
54.7
54.7
54.7
54.7
54.7
54.7
54.9
54.9
54.9
54.9
54.9
54.9
54.9
54.9
54.9
54.9
54.9
54.9
55.1
55.1
55.1
55.1
55.1
55.1
55.1
55.1
55.1
55.3
55.3
55.3
55.3
55.3
55.3
55.3
55.3
55.3
55.5
55.5
55.5
55.5
55.5
55.5
55.5
55.7
55.7
55.7
55.7
55.7
55.7
55.7
55.7
55.7
55.7
55.7
55.7
55.7
55.7
55.7
55.9
55.9
55.9
56.1
56.1
56.1
56.1
56.1
56.1
56.1
56.5
56.5
56.5
56.7
56.7
56.7
56.9
56.9
56.9
57.7
57.7
57.9
最大值57.9
最小值50.6
平均值54.09633
极差7.3
标准差(样本)1.152235
组数18
组距0.406
分组: “分组”就是确定直方图的横轴坐标起止范围和每个小组的起止位置。选一个比最小值小的一个恰当的值作为第一个组的起始坐标,然后依次加上
“分组组距”,直到最后一个数据值比“最大值”大为止。这时的实际分组数量可能与计算的“分组数”有一点正常的差别。类似如下图。
分析步骤 一、
分析步骤 二、
1. 分组
2.计算每组的频率
3.计算每组的正态分布数值
注:函数应用
1 Frequency 数组输入
统计 条件 > x and <= x1 的个
数
2
计算一个数的正态分布数值
1
序号
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
分组
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
2
频率
0
1
0
1
6
8
23
59
38
38
36
28
18
22
10
3
6
0
2
1
3
正态分布数值
0.002654428
0.007484677
0.01864544
0.041036437
0.079792872
0.137074285
0.208039269
0.278953677
0.330458026
0.345858104
0.319798963
0.261248368
0.188550445
0.12022616
0.067727935
0.033708089
0.014821695
0.005757833
0.00197614
0.000599203
发布评论