威布尔分布在excel中应用实例

1、alternative：true是分布函数；false是密度函数统计变量形状参数特征寿命分布函数尺寸参数结果1结果2结果3tB1B2B3B4Talternative012.53.552TRUEFALSE0.00%0.00%0.00%0.112.53.552TRUEFALSE4.88%0.06%0.00%0.212.53.552TRUEFALSE9.52%0.32%0.03%0.312.53.552TRUEFALSE13.93%0.87%0.13%0.412.53.552TRUEFALSE18.13%1.77%0.36%0.512.53.552TRUEFALSE22.12%3.08%0.78%0

2、.612.53.552TRUEFALSE25.92%4.81%1.47%0.712.53.552TRUEFALSE29.53%6.99%2.50%0.812.53.552TRUEFALSE32.97%9.62%3.97%0.912.53.552TRUEFALSE36.24%12.70%5.93%112.53.552TRUEFALSE39.35%16.20%8.46%1.112.53.552TRUEFALSE42.31%20.10%11.61%1.212.53.552TRUEFALSE45.12%24.34%15.41%1.312.53.552TRUEFALSE47.80%28.87%19.86

3、%1.412.53.552TRUEFALSE50.34%33.63%24.95%1.512.53.552TRUEFALSE52.76%38.56%30.60%1.612.53.552TRUEFALSE55.07%43.58%36.74%1.712.53.552TRUEFALSE57.26%48.63%43.23%1.812.53.552TRUEFALSE59.34%53.63%49.92%1.912.53.552TRUEFALSE61.33%58.51%56.64%212.53.552TRUEFALSE63.21%63.21%63.21%2.112.53.552TRUEFALSE65.01%6

4、7.69%69.46%2.212.53.552TRUEFALSE66.71%71.89%75.24%2.312.53.552TRUEFALSE68.34%75.79%80.43%2.412.53.552TRUEFALSE69.88%79.35%84.94%2.512.53.552TRUEFALSE71.35%82.57%88.74%2.612.53.552TRUEFALSE72.75%85.44%91.83%2.712.53.552TRUEFALSE74.08%87.97%94.27%2.812.53.552TRUEFALSE75.34%90.16%96.11%2.912.53.552TRUE

5、FALSE76.54%92.05%97.45%312.53.552TRUEFALSE77.69%93.64%98.40%3.112.53.552TRUEFALSE78.78%94.98%99.03%3.212.53.552TRUEFALSE79.81%96.08%99.44%3.312.53.552TRUEFALSE80.80%96.97%99.69%3.412.53.552TRUEFALSE81.73%97.69%99.83%3.512.53.552TRUEFALSE82.62%98.26%99.92%3.612.53.552TRUEFALSE83.47%98.71%99.96%3.712.

6、53.552TRUEFALSE84.28%99.05%99.98%3.812.53.552TRUEFALSE85.04%99.31%99.99%3.912.53.552TRUEFALSE85.77%99.51%100.00%412.53.552TRUEFALSE86.47%99.65%100.00%4.112.53.552TRUEFALSE87.13%99.76%100.00%4.212.53.552TRUEFALSE87.75%99.83%100.00%4.312.53.552TRUEFALSE88.35%99.89%100.00%4.412.53.552TRUEFALSE88.92%99.

7、92%100.00%4.512.53.552TRUEFALSE89.46%99.95%100.00%4.612.53.552TRUEFALSE89.97%99.97%100.00%4.712.53.552TRUEFALSE90.46%99.98%100.00%4.812.53.552TRUEFALSE90.93%99.99%100.00%4.912.53.552TRUEFALSE91.37%99.99%100.00%512.53.552TRUEFALSE91.79%99.99%100.00%密度函数结果4结果1结果2结果3结果40.00%0.00%47.56%1.40%0.10%0.00%0.

8、00%45.24%3.94%0.55%0.02%0.01%43.04%7.20%1.52%0.13%0.03%40.94%10.98%3.12%0.40%0.10%38.94%15.14%5.43%0.98%0.24%37.04%19.55%8.50%2.02%0.52%35.23%24.07%12.36%3.73%1.02%33.52%28.58%17.01%6.33%1.83%31.88%32.94%22.36%10.06%3.08%30.33%37.03%28.32%15.14%4.91%28.85%40.74%34.70%21.75%7.48%27.44%43.96%41.28%29.

9、98%10.96%26.10%46.60%47.77%39.74%15.47%24.83%48.59%53.85%50.74%21.12%23.62%49.88%59.16%62.39%27.94%22.47%50.46%63.37%73.79%35.83%21.37%50.32%66.17%83.74%44.59%20.33%49.49%67.34%90.88%53.87%19.34%48.03%66.75%93.93%63.21%18.39%45.98%64.38%91.97%72.09%17.50%43.46%60.37%84.80%80.02%16.64%40.54%54.99%73.

10、13%86.62%15.83%37.33%48.58%58.51%91.70%15.06%33.93%41.58%43.05%95.27%14.33%30.45%34.43%28.85%97.56%13.63%26.98%27.54%17.43%98.87%12.96%23.59%21.25%9.37%99.54%12.33%20.37%15.79%4.43%99.84%11.73%17.36%11.28%1.82%99.95%11.16%14.60%7.73%0.64%99.99%10.61%12.12%5.07%0.19%100.00%10.09%9.93%3.19%0.05%100.00

11、%9.60%8.02%1.91%0.01%100.00%9.13%6.40%1.09%0.00%100.00%8.69%5.04%0.59%0.00%100.00%8.26%3.91%0.30%0.00%100.00%7.86%2.99%0.15%0.00%100.00%7.48%2.26%0.07%0.00%100.00%7.11%1.68%0.03%0.00%100.00%6.77%1.24%0.01%0.00%100.00%6.44%0.89%0.00%0.00%100.00%6.12%0.64%0.00%0.00%100.00%5.82%0.45%0.00%0.00%100.00%5.

12、54%0.31%0.00%0.00%100.00%5.27%0.21%0.00%0.00%100.00%5.01%0.14%0.00%0.00%100.00%4.77%0.09%0.00%0.00%100.00%4.54%0.06%0.00%0.00%100.00%4.31%0.04%0.00%0.00%00.20.40.60.811.21.41.61.822.22.42.62.833.23.43.63.844.24.44.64.850.00%20.00%40.00%60.00%80.00%100.00%120.00%00.30.60.91.21.51.82.12.42.733.33.63.9

13、4.24.54.80.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%90.00%100.00%Series1Series2Series3Series4alternative：true是分布函数；false是密度函数分布函数100.00%4.10%0.03%0.00%0.00%x00.20.40.60.811.21.41.61.822.22.42.62.833.23.43.63.844.24.44.64.850.00%20.00%40.00%60.00%80.00%100.00%120.00%00.30.60.91.21.51.82.12.

14、42.733.33.63.94.24.54.80.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%90.00%100.00%Series1Series2Series3Series4样本1234567891011121314151011.7917.75.99.812.511.89.913.29.78.712.610.76.61011.7917.75.99.812.511.89.913.29.78.712.610.76.618.615.886.910.91234567891011121314151617181920024681012141618

15、201617181920average 方差VAR.S众数18.615.886.910.91111.70#N/A5.012.72.5f（t）5.90%8.5420%11.1840%13.7525%16.315%18.9210%20F(t）5.90%8.5420%11.11260%13.71785%16.31890%18.920100%R(t)5.920100%8.51680%11.1840%13.7315%16.3210%18.900%（t）5.90.008.50.2511.11.0013.71.6716.30.5018.92.50485125.98.511.113.716.318.90123

16、4567894121718205.98.511.113.716.318.90510152025201683205.98.511.113.716.318.905101520251011.7917.75.99.812.511.89.913.29.78.712.610.76.618.615.886.910.91234567891011121314151617181920024681012141618200%20%40%25%5%10%概概率率密密度度5.98.511.113.716.318.90%5%10%15%20%25%30%35%40%45%0%20%60%85%90%100%分分布布概概率率

17、5.98.511.113.716.318.90%20%40%60%80%100%120%100%80%40%15%10%0%生生存存概概率率5.98.511.113.716.318.90%20%40%60%80%100%120%0.00 0.25 1.00 1.67 0.50 失失效效率率5.98.511.113.716.318.90.00 0.50 1.00 1.50 2.00 2.50 3.00 485125.98.511.113.716.318.901234567894121718205.98.511.113.716.318.90510152025201683205.98.511.113.716.318.905101520250.00 0.25 1.00 1.67 0.50 失失效效率率5.98.511.113.716.318.90.00 0.50 1.00 1.50 2.00 2.50 3.00 0%20%40%25%5%10%概概率率密密度度5.98.511.113.716.318.90%5%10%15%20%25%30%35%40%45%0%20%60%85%90%100%分分布布概概率率5.98.511.1