Question: Calculate the probability that a repair will require 3 0 or fewer minutes ( 0 . 5 hours ) to complete. Place your calculation in
Calculate the probability that a repair will require or fewer minutes hours to complete.
Place your calculation in cellE
Use the EXPON.DIST function.
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
