In: Statistics and Probability
I need a step by step for entering in excel.
For this assignment, your group will utilize the preliminary data collected in the Topic 2 assignment. Considering the specific requirements of your scenario, complete the following steps using Excel. The accuracy of formulas and calculations will be assessed.
Sol:
1).
20 | n | |
0.4 | p | |
cumulative | ||
X | P(X) | probability |
0 | 0.00004 | 0.00004 |
1 | 0.00049 | 0.00052 |
2 | 0.00309 | 0.00361 |
3 | 0.01235 | 0.01596 |
4 | 0.03499 | 0.05095 |
5 | 0.07465 | 0.12560 |
6 | 0.12441 | 0.25001 |
7 | 0.16588 | 0.41589 |
8 | 0.17971 | 0.59560 |
9 | 0.15974 | 0.75534 |
10 | 0.11714 | 0.87248 |
11 | 0.07099 | 0.94347 |
12 | 0.03550 | 0.97897 |
13 | 0.01456 | 0.99353 |
14 | 0.00485 | 0.99839 |
15 | 0.00129 | 0.99968 |
16 | 0.00027 | 0.99995 |
17 | 0.00004 | 0.99999 |
18 | 0.00000 | 1.00000 |
19 | 0.00000 | 1.00000 |
20 | 0.00000 | 1.00000 |
1.00000 | ||
8.000 | expected value | |
4.800 | variance | |
2.191 | standard deviation |
2)
. 0 = 0.00004
< 5 = 0.05095
10 = 0.24466
3).
cumulative | ||
X | P(X) | probability |
0 | 0% | 0% |
1 | 0% | 0% |
2 | 0% | 0% |
3 | 1% | 2% |
4 | 3% | 5% |
5 | 7% | 13% |
6 | 12% | 25% |
7 | 17% | 42% |
8 | 18% | 60% |
9 | 16% | 76% |
10 | 12% | 87% |
11 | 7% | 94% |
12 | 4% | 98% |
13 | 1% | 99% |
14 | 0% | 100% |
15 | 0% | 100% |
16 | 0% | 100% |
17 | 0% | 100% |
18 | 0% | 100% |
19 | 0% | 100% |
20 | 0% | 100% |
X of 20% = 6
X of top 10% = 11
95% = 4 < X < 12