excel表格怎么把行高均勻分布一頁？Excel表格要想把行高均勻分布一頁，我們這個可以將所有的行數(shù)全部選擇上，也就是按在數(shù)字鍵的地方，將所有的行中,選擇之后，然后把我們按在這一行之后一行的下邊框上面

excel表格怎么把行高均勻分布一頁？

Excel表格要想把行高均勻分布一頁，我們這個可以將所有的行數(shù)全部選擇上，也就是按在數(shù)字鍵的地方，將所有的行中,選擇之后，然后把我們按在這一行之后一行的下邊框上面，后再向上鼠標(biāo)拖動一下，拖動很小的幅度，這樣的所有的行高全是一樣的高度。這樣的話在一頁當(dāng)中所有的房高也是一樣的。

excel生成正態(tài)分布函數(shù)？

詳細(xì)會會用到excel的正態(tài)分布函數(shù)Normdist（）

輸入輸入數(shù)據(jù)。

1.在單元格A1輸入。

2.挑選單元格A1：A121。

3.篩選“編輯器”菜單下的“填充后”—“序列”。

在“序列有一種在”框，先選“列”選項(xiàng)；

在“類型”框，選定“等差序列”選項(xiàng)；

在“步長值”框，然后輸入0.05（是可以據(jù)自己的需要輸入步長值）；

在“重新開啟值”框，再輸入3。

4.左鍵單擊“判斷”。

5.在單元格B1中輸入輸入“Normdist(a1,0,1,0)”，回車得0.004432，即為x-3時的標(biāo)準(zhǔn)正態(tài)分布的概率密度函數(shù)值。

6.把鼠標(biāo)裝在單元格B1上的單元格圖案填充柄上，當(dāng)鼠標(biāo)變的十字時，往上拖曳鼠標(biāo)至B121。

這樣的就可以得出一張正態(tài)其分布表了。

Excel怎樣畫對數(shù)正太分布的圖？

一、聲望兌換正態(tài)分布概念密度

正態(tài)分布概率密度正態(tài)分布函數(shù)“NORMDIST”資源。

在這里是以分組邊界值為“X”來換算：

MeanAVERAGE(A:A)(數(shù)據(jù)算術(shù)來算）

Standard_devSTDEV(A:A)(數(shù)據(jù)的標(biāo)準(zhǔn)方差）

Cumulative0(概率密度函數(shù)）

二、向上填充。

三、在直方圖中增強(qiáng)正態(tài)分布曲線圖。

1、在直方圖內(nèi)右鍵→你選擇數(shù)據(jù)→添加→。

2、系列名稱：選中H1單元格。

3、系列值：選中H2:H21。

4、確認(rèn)。

四、修整圖形

1、在圖表區(qū)柱形較下方鼠標(biāo)右鍵點(diǎn)擊正態(tài)分布曲線數(shù)據(jù)，（正態(tài)分布密度值和頻率數(shù)值相比太小了，真的看不清楚，多試過，左鍵單擊后如圖，同樣的正態(tài)分布曲線那數(shù)數(shù)據(jù)在左鍵單擊狀態(tài)）。

2、右鍵→系統(tǒng)設(shè)置數(shù)據(jù)列格式→系列手工繪制在→次坐標(biāo)軸；

自動關(guān)閉，如圖。

五、改系列圖表類型

1、左鍵單擊正態(tài)分布柱形圖→右鍵→可以修改系列圖表類型。

2、鼠標(biāo)右鍵點(diǎn)擊“縫針圖”。

3、確定。

六、平滑正態(tài)分布圖。

選中后正態(tài)分布曲線→右鍵→可以設(shè)置數(shù)據(jù)列格式→線型→選項(xiàng)卡“平滑線”→自動關(guān)閉。

一命歸西！?。?/p>

本例中原始數(shù)據(jù)：

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