1. 正态分布图excel图
一、获取正态分布概念密度
正态分布概率密度正态分布函数“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
2. excel标准正态分布图
用EXCEL怎么计算平均数、方差、标准差：
1、平均数=average(A1:A100)。
2、方差=vara(A1:A100)。
3、标准差=stdev(A1:A100)。 Microsoft Excel： Microsoft Excel是微软公司的办公软件Microsoft office的组件之一，是由Microsoft为Windows和Apple Macintosh操作系统的电脑而编写和运行的一款试算表软件。Excel 是微软办公套装软件的一个重要的组成部分，它可以进行各种数据的处理、统计分析和辅助决策操作，广泛地应用于管理、统计财经、金融等众多领域。
3. 正态分布图Excel
具体会用到excel的正态分布函数Normdist（）
输入数据。
1.在单元格A1输入 。
2.选定单元格A1：A121。
3.选取“编辑”菜单下的“填充”—“序列”。
在“序列产生在”框，选定“列”选项；
在“类型”框，选定“等差序列”选项；
在“步长值”框，输入0.05（可以根据自己的需要输入步长值）；
在“终止值”框，输入3。
4.单击“确定”。
5.在单元格B1中输入“=Normdist(a1,0,1,0) ”，回车得0.004432 ，即为 x=-3 时的标准正态分布的概率密度函数值。
6.把鼠标放在单元格B1上的单元格填充柄上，当鼠标变成十字时，向下拖曳鼠标至B121。
这样就可以得出一张正态分布表了。
4. 正态分布图用excel 怎么做
具体会用到excel的正态分布函数Normdist（）
输入数据。
1.在单元格A1输入 。
2.选定单元格A1：A121。
3.选取“编辑”菜单下的“填充”—“序列”。
在“序列产生在”框，选定“列”选项；
在“类型”框，选定“等差序列”选项；
在“步长值”框，输入0.05（可以根据自己的需要输入步长值）；
在“终止值”框，输入3。
4.单击“确定”。
5.在单元格B1中输入“=Normdist(a1,0,1,0) ”，回车得0.004432 ，即为 x=-3 时的标准正态分布的概率密度函数值。
6.把鼠标放在单元格B1上的单元格填充柄上，当鼠标变成十字时，向下拖曳鼠标至B121。
这样就可以得出一张正态分布表了。
5. 正态分布图怎么用excel做
使用=NORMINV(RAND(),均值,标准差），就可以产生正态随机数据了。
6. excel标准正态分布表完整图
有几种方式：
1. 可以用插入折线图或者柱状图来看是否属于正态分布。
2. 通过偏度SKEW公式来进行计算。
3. 通过分析工具库来进行查看。
7. excel中正态分布图怎么做
1.
首先选中Excel表格,双击打开。
2.
然后在该界面中,选中要显示正态分布概率的单元格。
3.
再者在该界面中,公示栏中输入计算正态分布概率的公式“=NORMSDIST(A1:A11)”。
4.
之后在该界面中,单元格里成功显示正态分布概率结果。希望这个答案对你有用谢谢谢谢。
8. 正态分布柱状图Excel
先用柱状图把你的数据绘制好，然后用Gaussian函数对这组数据拟合。
如果你用的是Origin 7.5 或更低的版本， 选择 Analysis — Non-linear Curve Fit — Advanced Fitting Tool， 在弹出的对话框中的菜单栏中点第二个Function，点Select，在 Categories中选择Origin Basic Function，在 Functions 中选择Gauss或者GaussAmp都可以，然后在菜单栏中点第三个Action，点Fit，然后点100 lter，Done
如果你用的是Origin 8.0 或更高的版本，选择Analysis — Fitting — Non-linear Fit — Open Dialog — Funcition 选择Gauss或者GaussAmp都可以。按默认的初值拟合，点Fit就好了。
9. excel正态分布图怎么做
要在Excel中快速创建正态分布或钟形曲线图，请通过以下步骤应用此功能：
1。 点击 库工具 > 图表 > 数据分布 > 正态分布/钟形曲线。 见下图：
2。 在弹出 快速创建正态分布图 在对话框中，检查要创建的图表类型，然后选择要基于其创建图表的数据范围，然后已计算出最大值，最小值，平均值和标准偏差，并在对话框中列出。 看下图：
3。 然后，点击 OK 按钮，立即创建了正态分布或钟形曲线图，请参见下图：
- 相关评论
- 我要评论
-
