excel怎样做数据分布图 excel表格怎么把行高均匀分布一页？

excel表格怎么把行高均匀分布一页？

Excel表格要想把行高均匀分布一页，我们这个可以将所有的行数全部选择上，也就是按在数字键的地方，将所有的行中,选择之后，然后把我们按在这一行之后一行的下边框上面，后再向上鼠标拖动一下，拖动很小的幅度，这样的所有的行高全是一样的高度。这样的话在一页当中所有的房高也是一样的。

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。

这样的就可以得出一张正态其分布表了。

Excel怎样画对数正太分布的图？

一、声望兑换正态分布概念密度

正态分布概率密度正态分布函数“NORMDIST”资源。

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

MeanAVERAGE(A:A)(数据算术来算）

Standard_devSTDEV(A:A)(数据的标准方差）

Cumulative0(概率密度函数）

二、向上填充。

三、在直方图中增强正态分布曲线图。

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