用EXCEL做正态分布曲线
问题描述:
用EXCEL做正态分布曲线
X 轴Y轴
0.9151
0.922
0.9213
0.9235
0.9242
0.9257
0.9267
0.92722
0.92835
0.92949
0.9353
0.93157
0.93283
0.933115
0.934165
0.935182
0.936233
0.937254
0.938319
0.939442
0.94431
0.941463
0.942511
0.943544
0.944559
0.945587
0.946617
0.947668
0.948580
0.949575
0.95501
0.951483
0.952449
0.953393
0.954321
0.955264
0.956211
0.957167
0.958122
0.959100
0.9654
0.96138
0.96237
0.96324
0.9649
0.96510
0.9662
0.9674
0.9683
0.9691
0.9711
0.9721
0.9741
0.9791
以上数据我已经做成柱状图了,需要在柱状图上添加相应的正态分布曲线怎么做
答
Excel函数 Normdist()