当前位置:文档之家› 威布尔分布在excel中应用实例

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

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

alternative:true是分布函数;false是密度函数特征寿命尺寸参数结果1结果2结果3t

B1B2B3B4T 0

1 2.5 3.552TRUE FALSE 0.00%0.00%0.00%0.1

1 2.5 3.552TRUE FALSE 4.88%0.06%0.00%0.2

1 2.5 3.552TRUE FALSE 9.52%0.32%0.03%0.3

1 2.5 3.552TRUE FALSE 13.93%0.87%0.13%0.4

1 2.5 3.552TRUE FALSE 18.13% 1.77%0.36%0.5

1 2.5 3.552TRUE FALSE 22.12% 3.08%0.78%0.6

1 2.5 3.552TRUE FALSE 25.92% 4.81% 1.47%0.7

1 2.5 3.552TRUE FALSE 29.53% 6.99% 2.50%0.8

1 2.5 3.552TRUE FALSE 32.97%9.62% 3.97%0.9

1 2.5 3.552TRUE FALSE 36.24%12.70% 5.93%1

1 2.5 3.552TRUE FALSE 39.35%16.20%8.46%1.1

1 2.5 3.552TRUE FALSE 42.31%20.10%11.61%1.2

1 2.5 3.552TRUE FALSE 45.12%24.34%15.41%1.3

1 2.5 3.552TRUE FALSE 47.80%28.87%19.86%1.4

1 2.5 3.552TRUE FALSE 50.34%33.63%24.95%1.5

1 2.5 3.552TRUE FALSE 52.76%38.56%30.60%1.6

1 2.5 3.552TRUE FALSE 55.07%43.58%36.74%1.7

1 2.5 3.552TRUE FALSE 57.26%48.63%43.23%1.8

1 2.5 3.552TRUE FALSE 59.34%53.63%49.92%1.9

1 2.5 3.552TRUE FALSE 61.33%58.51%56.64%2

1 2.5 3.552TRUE FALSE 63.21%63.21%63.21%2.1

1 2.5 3.552TRUE FALSE 65.01%67.69%69.46%2.2

1 2.5 3.552TRUE FALSE 66.71%71.89%75.24%2.3

1 2.5 3.552TRUE FALSE 68.34%75.79%80.43%2.4

1 2.5 3.552TRUE FALSE 69.88%79.35%84.94%2.5

1 2.5 3.552TRUE FALSE 71.35%82.57%88.74%2.6

1 2.5 3.552TRUE FALSE 72.75%85.44%91.83%2.7

1 2.5 3.552TRUE FALSE 74.08%87.97%94.27%2.8

1 2.5 3.552TRUE FALSE 75.34%90.16%96.11%2.9

1 2.5 3.552TRUE FALSE 76.54%92.05%97.45%3

1 2.5 3.552TRUE FALSE 77.69%93.64%98.40%3.1

1 2.5 3.552TRUE FALSE 78.78%94.98%99.03%3.2

1 2.5 3.552TRUE FALSE 79.81%96.08%99.44%3.3

1 2.5 3.552TRUE FALSE 80.80%96.97%99.69%3.4

1 2.5 3.552TRUE FALSE 81.73%97.69%99.83%3.5

1 2.5 3.552TRUE FALSE 82.62%98.26%99.92%3.6

1 2.5 3.552TRUE FALSE 83.47%98.71%99.96%3.7

1 2.5 3.552TRUE FALSE 84.28%99.05%99.98%3.8

1 2.5 3.552TRUE FALSE 85.04%99.31%99.99%3.9

1 2.5 3.552TRUE FALSE 85.77%99.51%100.00%4

1 2.5 3.552TRUE FALSE 86.47%99.65%100.00%4.1

1 2.5 3.552TRUE FALSE 87.13%99.76%100.00%4.2

1 2.5 3.552TRUE FALSE 87.75%99.83%100.00%4.3

1 2.5 3.552TRUE FALSE 88.35%99.89%100.00%4.4

1 2.5 3.552TRUE FALSE 88.92%99.92%100.00%4.5

1 2.5 3.552TRUE FALSE 89.46%99.95%100.00%4.6

1 2.5 3.552TRUE FALSE 89.97%99.97%100.00%4.7

1 2.5 3.552TRUE FALSE 90.46%99.98%100.00%4.81 2.5 3.552TRUE FALSE 90.93%99.99%100.00%

统计

变量

形状参数分布函数alternative

4.91 2.5 3.552TRUE FALSE91.37%99.99%100.00% 51 2.5 3.552TRUE FALSE91.79%99.99%100.00%

alse是密度函数结果4结果1结果2结果3结果40.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%3

2.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.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.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%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.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%密度函数

0.00%20.00%40.00%60.00%80.00%100.00%120.00%00.20.40.60.811.21.41.61.822.20.00%10.00%20.00%30.00%40.00%50.00%60.00%70.00%80.00%90.00%100.00%00.30.60.91.21.51.82.12.42.7

100.00% 4.31%0.04%0.00%0.00% 100.00% 4.10%0.03%0.00%0.00%

x

相关主题
文本预览
相关文档 最新文档