学习啦 > 学习电脑 > 工具软件 > 办公软件学习 > Excel教程 > Excel2007教程 > excel2007生成正态分布曲线图的方法

excel2007生成正态分布曲线图的方法

时间: 晓生931 分享

excel2007生成正态分布曲线图的方法

  在学习工作中总会有一些用到正态分布曲线图的地方,今天,学习啦小编就教大家在Excel2007中制作正态分布曲线图的方法。

  Excel2007生成正态分布曲线图的步骤如下:

  获取正态分布概念密度。

  正态分布概率密度正态分布函数“NORMDIST”获取。

  在这里是以分组边界值为“X”来计算:

  Mean=AVERAGE(A:A)(数据算术平均)

  Standard_dev=STDEV(A:A)(数据的标准方差)

  Cumulative=0(概率密度函数)

  向下填充。

  在直方图中增加正态分布曲线图。

  1、在直方图内右键→选择数据→添加→

  2、系列名称:选中H1单元格。

  3、系列值:选中H2:H21。

  4、确定、确定。

  修整图形。

  1、在图表区柱形较下方选中正态分布曲线数据,(正态分布密度值和频率数值相比太小了,实在看不清,多试几次,选中后如图,同时正态分布曲线那数数据处于选中状态)。

  2、右键→设置数据列格式→系列绘制在→次坐标轴;

  关闭,如图。

  更改系列图表类型。

  1、选中正态分布柱形图→右键→更改系列图表类型。

  2、选中“拆线图”。

  3、确定。

  平滑正态分布图。

  选中正态分布曲线→右键→设置数据列格式→线型→勾选“平滑线”→关闭。

  大功告成!!!

  本例中原始数据:

  51.7,50.6,57.9,56.9,56.7,56.7,55.3,56.1,53.7,54.5,56.9,51.9,52.1,55.1,54.9,54.7,55.3,55.3,54.5,54.9,54.5,55.3,54.9,54.3,53.7,53.5,53.7,53.1,54.5,53.1,53.9,53.5,53.3,53.9,53.5,53.5,52.5,53.3,53.5,53.3,53.7,53.1,54.5,53.9,56.7,54.5,54.3,55.1,54.1,54.5,53.9,53.1,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.3,53.9,52.7,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,52.9,52.9,53.1,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,53.1,52.5,55.9,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,54.3,54.7,53.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,53.7

1987181