Excel 怎样画对数正态分布图，不是累积分布图

Excel 怎样画对数正态分布图，不是累积分布图

正态分布函数为NORMDIST：
要绘制正态分布图：首先计算有效数据样本的最大值、最小值、有效算术平均值、标准偏差。
确定统计样本有效数据的分布范围。
2、用正态分布涵数计算样本有效数据范围间数据的正态分布。NORMIDST（样本统计的范围，有效样本算术平均值，有效样本的标准偏差，{1或0}）第四参数如果是1，返回的是累计分布，0返回的是概率分布，根据自己对样本统计的需要选择！

一、获取正态分布概念密度  正态分布概率密度正态分布函数“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