用EXCEL做正态分布曲线X 轴 Y轴0.91510.9220.92130.92350.92420.92570.92670.927220.928350.929490.93530.931570.932830.9331150.9341650.9351820.9362330.9372540.9383190.9394420.944310.9414630.9425110.9435440.9445590.945

来源:学生作业帮助网 编辑:作业帮 时间:2024/04/26 14:16:44
用EXCEL做正态分布曲线X 轴    Y轴0.91510.9220.92130.92350.92420.92570.92670.927220.928350.929490.93530.931570.932830.9331150.9341650.9351820.9362330.9372540.9383190.9394420.944310.9414630.9425110.9435440.9445590.945

用EXCEL做正态分布曲线X 轴 Y轴0.91510.9220.92130.92350.92420.92570.92670.927220.928350.929490.93530.931570.932830.9331150.9341650.9351820.9362330.9372540.9383190.9394420.944310.9414630.9425110.9435440.9445590.945
用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做正态分布曲线X 轴 Y轴0.91510.9220.92130.92350.92420.92570.92670.927220.928350.929490.93530.931570.932830.9331150.9341650.9351820.9362330.9372540.9383190.9394420.944310.9414630.9425110.9435440.9445590.945
Excel函数 Normdist()

真要这么做的话,估计只能用画图软件修改了,两图变一图

增加一条散点线,但是先要将你的数据转化为正态分布函数,描点,用你函数中的的X,Y坐标来作图。

在添加一个图就可以了