Please Calculate the Comulative Probability and Random Digit Assignment. Please Solve the problem ASAP. Show me how it is done in Excel if possible:
A store has one counter. The probability of inter-arrival time (in min) and service time (in min.) of customers are given in the following table.
Distribution of time between Arrival
Interarrival time(min) |
Probability |
Cumulative Probability |
Random Digit Assignment |
1 |
0.13 |
||
2 |
0.15 |
||
3 |
0.03 |
||
4 |
0.17 |
||
5 |
0.06 |
||
6 |
0.14 |
||
7 |
0.15 |
||
8 |
0.09 |
||
9 |
0.19 |
||
10 |
0.08 |
Interarrival time(min) | Probability | Cumulative Probability | Random Digit | |
Assignment | ||||
1 | 0.13 | 0.13 | 1------13 | |
2 | 0.15 | 0.28 | 14-----28 | |
3 | 0.03 | 0.31 | 29----31 | |
4 | 0.17 | 0.48 | 32----48 | |
5 | 0.06 | 0.54 | 49----54 | |
6 | 0.14 | 0.68 | 55---68 | |
7 | 0.15 | 0.83 | 69----83 | |
8 | 0.09 | 0.92 | 84---92 | |
9 | 0.02 | 0.94 | 93---94 | |
10 | 0.06 | 1 | 95---00 | |
sum= | 1 | |||
Note: | sum of probabilty should be 1 | |||
so I have changed last two probability | ||||
please see the same and | ||||
please alter accordingly | ||||
Get Answers For Free
Most questions answered within 1 hours.