概率紙圖的制作方法

1、概概率率紙紙圖圖的的制制作作方方法法1.先假設(shè)橫坐標(biāo)的數(shù)值范圍為0100，實(shí)際使用中可以按情況自行調(diào)整，按下面的數(shù)據(jù)作為自定義坐標(biāo)Y軸的數(shù)據(jù)。X軸值取數(shù)值范圍的最小值，累積分布值就是累積概率分布值，網(wǎng)格值就是用NORMSINV函數(shù)計(jì)算的達(dá)到指定累積概率值時(shí)的對應(yīng)數(shù)值。X軸值累積分布值Y軸次網(wǎng)格值 累積分布值Y軸主網(wǎng)格值 請繼續(xù)往下閱讀00.02% -3.54008380.01% -3.719016500.03% -3.43161440.05% -3.290526700.04% -3.35279480.10% -3.090232300.06% -3.23888010.50% -2.5758293

2、00.07% -3.19465111.00% -2.326347900.08% -3.15590685.00% -1.644853600.09% -3.121389110.00% -1.281551600.20% -2.878161715.00% -1.036433400.30% -2.747781420.00% -0.841621200.40% -2.652069830.00% -0.524400500.60% -2.512144340.00% -0.253347100.70% -2.457263450.00%-1.392E-1600.80% -2.408915560.00%0.253347

3、100.90% -2.365618170.00% 0.5244005102.00% -2.053748980.00% 0.8416212303.00% -1.880793685.00% 1.0364333904.00% -1.750686190.00% 1.2815515706.00% -1.554773695.00% 1.6448536307.00%-1.47579199.00% 2.3263478708.00% -1.405071699.50%2.575829309.00%-1.34075599.90% 3.09023231011.00% -1.226528199.95% 3.290526

4、73012.00% -1.174986899.99% 3.71901649013.00% -1.1263911014.00% -1.0803193016.00% -0.9944579017.00% -0.9541653018.00% -0.9153651019.00% -0.8778963022.00% -0.7721932024.00% -0.7063026026.00% -0.6433454028.00% -0.5828415032.00% -0.4676988034.00% -0.4124631036.00% -0.3584588038.00% -0.3054808042.00% -0.

5、2018935044.00% -0.1509692046.00% -0.1004337048.00% -0.0501536052.00% 0.05015358054.00% 0.10043372056.00% 000% 0.20189348062.00% 0.30548079064.00% 0.35845879066.00% 0.41246313068.00%0.4676988072.00% 0.58284151074.00% 0.64334541076.00% 0.70630256078.00% 0.77219321081.00%0.8778963082.00% 0

6、.91536509083.00% 0.95416525084.00% 0.99445788086.00% 1.08031934087.00% 1.12639113088.00% 100% 1.22652812091.00% 1.34075503092.00% 1.40507156093.00% 1.47579103094.00% 1.55477359096.00% 1.75068607097.00% 1.88079361098.00% 2.05374891099.10% 2.36561813099.20% 2.40891555099.30% 2.45726339099

7、.40% 2.51214433099.60% 2.65206981099.70% 2.74778139099.80% 2.87816174099.91% 3.12138915099.92% 393% 3.19465105099.94% 3.23888012099.96% 3.35279478099.97%3.4316144099.98%3.54008382.按上面的兩組網(wǎng)格值數(shù)據(jù)作2個(gè)XY散點(diǎn)圖系列。3.按下兩圖設(shè)置兩個(gè)坐標(biāo)軸的刻度，其中的3.71946953237056為主網(wǎng)格值的最大最小值，0和100為X軸值的范圍。Y坐標(biāo)軸格式X坐標(biāo)軸格式概概率率紙紙圖圖10.8

8、0.60.40.20-5-4-3-2-1012345Leq累累積積概概率率( (% %) )Y軸主網(wǎng)格值Y軸次網(wǎng)格值4.隱藏坐標(biāo)Y軸、圖例，并顯示坐標(biāo)X軸的主要網(wǎng)格線。5.分別設(shè)置Y軸主次網(wǎng)格值系列的誤差線X為定值100，其中的100為X坐標(biāo)的最大最小刻度差值。概概率率紙紙圖圖1009080706050403020100-3.7-2.7-1.7-0.70.31.32.33.3Leq累累積積概概率率( (% %) )Y軸主網(wǎng)格值Y軸次網(wǎng)格值概概率率紙紙圖圖1009080706050403020100Leq累累積積概概率率( (% %) )概概率率紙紙圖圖100908070605040302010

9、0Leq累累積積概概率率( (% %) )6.隱藏“Y軸次網(wǎng)格值”系列的“數(shù)據(jù)標(biāo)記”，并顯示“Y軸主網(wǎng)格值”系列的“數(shù)據(jù)標(biāo)志”為“顯示值”。選擇已顯示出的數(shù)據(jù)標(biāo)志值，在“數(shù)據(jù)標(biāo)志格式對齊標(biāo)志位置”中設(shè)置“靠左”。-3.719016485-3.290526731-3.090232306-2.575829304-2.326347874-1.644853627-1.281551566-1.036433389-0.841621234-0.524400513-0.253347103-1.39214E-160.2533471030.5244005130.8416212341.0364333891.2815

10、515661.6448536272.3263478742.5758293043.0902323063.2905267313.719016485概概率率紙紙圖圖1009080706050403020100Leq累累積積概概率率( (% %) )概概率率紙紙圖圖1009080706050403020100Leq累累積積概概率率( (% %) )7.隱藏“Y軸主網(wǎng)格值”系列的“數(shù)據(jù)標(biāo)記”。并單選每一個(gè)顯示的數(shù)據(jù)標(biāo)志，在公式編輯欄中用公式對指定單元格進(jìn)行鏈接，不要顯示的就刪除。8.這樣概率紙已做好，只要將下列數(shù)據(jù)作為一個(gè)新的系列加入到圖表中就完成了，請注意概率紙不能反映100%的概率，所以用99.99

11、%代替。右端點(diǎn)值累計(jì)頻率(%) 作圖值456.90% -1.48328015027.60% -0.59476585548.30% -0.04262566065.50% 0.398855076582.80% 0.946291367093.10% 1.483280137599.99% 3.719016490.01%0.10%1.00%5.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%90.00%95.00%99.00%99.90%99.99%概概率率紙紙圖圖1009080706050403020100Leq累累積積概概率率0.01%0.10%

12、1.00%5.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%90.00%95.00%99.00%99.90%99.99%概概率率紙紙圖圖1009080706050403020100Leq累累積積概概率率-3.719016485-3.290526731-3.090232306-2.575829304-2.326347874-1.644853627-1.281551566-1.036433389-0.841621234-0.524400513-0.253347103-1.39214E-160.2533471030.5244005130.8416212341.0364333891.2815515661.6448536272.3263478742.5758293043.0902323063.2905267313.719016485概概率率紙紙圖圖1009080706050403020100Leq累累積積概概率率( (% %) )0.01%0.10%1.00%5.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%90.00%95.00%99.00%99.90%99.99%概概率率紙紙圖圖1009080706050403020100Leq累累積積概概率率8.