当前位置:文档之家› Excel制作直方图正态分布图示例

Excel制作直方图正态分布图示例

Excel制作直方图正态分布图示例
Excel制作直方图正态分布图示例

51.7最大值

57.9序号分组频率

正态分布曲线

50.6最小值

50.6150.50000.00265457.9极差

7.3250.90610.00748556.9分组数

18351.31100.01864556.7分组组距0.406451.71710.04103656.7552.12260.07979355.3平均值54.096652.52880.13707456.1标准偏差

1.1522

752.933230.20803953.7853.339590.27895454.5953.744380.33045856.91054.150380.34585851.91154.556360.31979952.11254.961280.26124855.11355.367180.1885554.91455.772220.12022654.71556.178100.06772855.31656.58330.03370855.31756.98960.01482254.51857.39400.00575854.91957.80020.00197654.52058.206

1

0.000599

55.354.954.353.753.5具体步骤:https://www.doczj.com/doc/dd2783931.html,/article/f3ad7d0fffa41509c2345b6e.html

53.753.154.553.153.953.553.353.953.553.552.553.353.553.353.753.154.553.956.754.554.355.154.1

50.50050.90651.31151.71752.12252.52852.93353.744

53.3 55.3

55.7

56.1 54.7 53.1 53.3

52.7

53.1

52.9

53.1

54.3 53.1

52.7

53.1 53.3 53.1 53.3 53.1 53.3 55.1 54.7 54.9 54.3 53.9 53.7 53.9

53.5

54.5

54.3

55.5 55.7 55.5

54.9

55.3 55.5

53.7

54.1 53.9 55.7 55.9 53.7 53.5 53.1 52.3 52.7 52.9

53.5 53.1 52.7

51.9

52.5

53.9

54.5

55.7 55.3 54.9 53.1 52.9 54.1

53.3

54.7

53.9

54.3 54.1 53.7 53.3 52.7 52.9

52.5

53.9

53.5

54.1 54.1 54.7 54.9 54.9 54.1 53.3

52.9

53.7

53.9

54.3 54.1 54.5 54.7 54.9 52.1

52.9

53.5

52.7

53.1 53.1 53.5

53.3

52.7

53.5

53.9

54.9

55.1

54.3

55.1 54.3 54.3

53.9

54.5 54.5

54.3

55.3 54.5 54.9 53.5 52.1 55.3 55.7 55.7 55.5 54.5 57.7 54.7 53.7 53.1 53.7

55.9

56.1 53.9 53.7 53.3 53.9

53.9

54.5 54.7 56.1 55.7 53.1 53.7 53.5 53.9 53.9 53.5 53.3

55.7 54.1 54.3 54.1 54.1 54.5

54.5

55.1 53.1

53.3

54.1 54.3

53.9

54.1 54.7 54.7 53.7 53.1 53.3

52.7

53.5

52.9

53.7 56.5 56.1 55.7

55.5

56.9

57.7 56.5 55.7 54.1

54.7

55.7 55.5 53.1

52.7

53.1 53.3

53.5

54.3 54.1 54.5

54.7

55.7 55.5 54.1

53.3 53.1

52.7

53.1 53.7

53.1

54.7

54.5

55.1 54.7 54.5 56.1 55.7 53.3

52.5

53.7

54.1 53.3 52.1

52.3

53.1 53.3 53.5 53.3 53.1

52.7

53.1 55.7 55.1 54.3 53.7 53.1

52.9

53.1 52.7

52.5

53.1 53.5 53.1

53.3

54.1

55.1 54.9 56.1

55.7

56.5 54.7

数轴744………

相关主题
文本预览
相关文档 最新文档