《威布尔分布在excel中应用实例.xls》由会员分享，可在线阅读，更多相关《威布尔分布在excel中应用实例.xls（13页珍藏版）》请在三一文库上搜索。
1、alternative：true是分布函数；false是密度函数 统计 变量 形状参数 特征寿命分布函数 尺寸参数结果1结果2结果3 tB1B2B3B4Talternative 012.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
2、%3.08%0.78% 0.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.552TRUEFA
3、LSE47.80%28.87%19.86% 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%
4、2.112.53.552TRUEFALSE65.01%67.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.552TRUEFALS
5、E75.34%90.16%96.11% 2.912.53.552TRUEFALSE76.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.
6、612.53.552TRUEFALSE83.47%98.71%99.96% 3.712.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.552TRUEFALS
7、E88.35%99.89%100.00% 4.412.53.552TRUEFALSE88.92%99.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%10
8、0.00% 密度函数 结果4结果1结果2结果3结果4 0.00% 0.00%47.56%1.40%0.10%0.00% 0.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.
9、03%28.32%15.14% 4.91%28.85%40.74%34.70%21.75% 7.48%27.44%43.96%41.28%29.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%1
10、8.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.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%
11、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%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%
12、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.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% 0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8 2
13、 2.2 2.4 2.6 2.8 3 3.2 3.4 3.6 3.8 4 4.2 4.4 4.6 4.8 5 0.00% 20.00% 40.00% 60.00% 80.00% 100.00% 120.00% 0 0.3 0.6 0.9 1.2 1.5 1.8 2.1 2.4 2.7 3 3.3 3.6 3.9 4.2 4.5 4.8 0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% 80.00% 90.00% 100.00% Series1 Series2 Series3 Series4 alternative：true是分布函数；
14、false是密度函数 分布函数 100.00%4.10%0.03%0.00%0.00% x 0 0.2 0.4 0.6 0.8 1 1.2 1.4 1.6 1.8 2 2.2 2.4 2.6 2.8 3 3.2 3.4 3.6 3.8 4 4.2 4.4 4.6 4.8 5 0.00% 20.00% 40.00% 60.00% 80.00% 100.00% 120.00% 0 0.3 0.6 0.9 1.2 1.5 1.8 2.1 2.4 2.7 3 3.3 3.6 3.9 4.2 4.5 4.8 0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00%
15、70.00% 80.00% 90.00% 100.00% Series1 Series2 Series3 Series4 样本123456789101112131415 1011.7917.75.99.812.511.89.913.29.78.712.610.76.6 10 11.7 9 17.7 5.9 9.8 12.5 11.8 9.9 13.2 9.7 8.7 12.6 10.7 6.6 18.6 15.8 8 6.9 10.9 1234567891011121314151617181920 0 2 4 6 8 10 12 14 16 18 20 1617181920average 方差
16、VAR.S众数 18.615.886.910.91111.70#N/A 5.0 12.7 2.5 f（t） 5.90% 8.5420% 11.1840% 13.7525% 16.315% 18.9210% 20 F(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.00 8.50.25 11.11.00 13.71.67 16.30.50 18.92.50 4 8 5 1 2 5.98.511.
17、113.716.318.9 0 1 2 3 4 5 6 7 8 9 4 12 17 18 20 5.98.511.113.716.318.9 0 5 10 15 20 25 20 16 8 3 2 0 5.98.511.113.716.318.9 0 5 10 15 20 25 10 11.7 9 17.7 5.9 9.8 12.5 11.8 9.9 13.2 9.7 8.7 12.6 10.7 6.6 18.6 15.8 8 6.9 10.9 1234567891011121314151617181920 0 2 4 6 8 10 12 14 16 18 20 0% 20% 40% 25%
18、5% 10% 概概率率密密度度 5.98.511.113.716.318.9 0% 5% 10% 15% 20% 25% 30% 35% 40% 45% 0% 20% 60% 85% 90% 100% 分分布布概概率率 5.98.511.113.716.318.9 0% 20% 40% 60% 80% 100% 120% 100% 80% 40% 15% 10% 0% 生生存存概概率率 5.98.511.113.716.318.9 0% 20% 40% 60% 80% 100% 120% 0.00 0.25 1.00 1.67 0.50 失失效效率率 5.98.511.113.716.318.
19、9 0.00 0.50 1.00 1.50 2.00 2.50 3.00 4 8 5 1 2 5.98.511.113.716.318.9 0 1 2 3 4 5 6 7 8 9 4 12 17 18 20 5.98.511.113.716.318.9 0 5 10 15 20 25 20 16 8 3 2 0 5.98.511.113.716.318.9 0 5 10 15 20 25 0.00 0.25 1.00 1.67 0.50 失失效效率率 5.98.511.113.716.318.9 0.00 0.50 1.00 1.50 2.00 2.50 3.00 0% 20% 40% 25%
20、 5% 10% 概概率率密密度度 5.98.511.113.716.318.9 0% 5% 10% 15% 20% 25% 30% 35% 40% 45% 0% 20% 60% 85% 90% 100% 分分布布概概率率 5.98.511.113.716.318.9 0% 20% 40% 60% 80% 100% 120% 100% 80% 40% 15% 10% 0% 生生存存概概率率 5.98.511.113.716.318.9 0% 20% 40% 60% 80% 100% 120% 0.00 0.25 1.00 1.67 0.50 失失效效率率 5.98.511.113.716.318.9 0.00 0.50 1.00 1.50 2.00 2.50 3.00 0.00 0.25 1.00 1.67 0.50 失失效效率率 5.98.511.113.716.318.9 0.00 0.50 1.00 1.50 2.00 2.50 3.00