Question: Calculate the probability that a repair will require more than 9 0 minutes ( 1 . 5 hours ) to complete. Place your calculation in
Calculate the probability that a repair will require more than minutes hours to complete.
Place your calculation in cellE
Use the EXPON.DIST function.
Reference lambda C in your formula.
Note that the average service time is expressed in hours.
Hint: the probability of a repair taking more than minutes to complete is equal to one minus the probability of a repair taking or fewer minutes to complete.
Use the EXPON.DIST function.
Reference lambda C in your formula.
Note that the service time is expressed in hours.
Use the EXPON.DIST function.
Reference lambda C in your formula.
Note that the service time is expressed in hours.
Reference the lambda C in your formula.
Note that the service time is expressed in hours.
Place your calculation in cellC
Use the EXPON.DIST function.
Reference the required service time B and lambda of C in your formula.
Reuse your formula to calculate the individual probabilities of the other required service times in
Use the POISSON.DIST function.
Reference the average number of customers needing service per day C in your formula.
Use the POISSON.DIST function.
Reference the number of customers in cellBand the average number of customers needing service per day C in your formula.
Reuse your formula to calculate the individual probabilities of the numbers of customers needing service in rangeB:Bon a given day.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
