Question: Calculate the probability that a repair will require more than 3 0 and less than or equal to 6 0 minutes to complete. Place your

Calculate the probability that a repair will require more than 30 and less than or equal to 60 minutes to complete.
Place your calculation in cellE9.
Use the EXPON.DIST function.
Reference lambda (C2) in your formula.
Note that the service time is expressed in hours.
Reference the lambda (C2) in your formula.
Note that the service time is expressed in hours.
Place your calculation in cellC5.
Use the EXPON.DIST function.
Reference the required service time (B5) and lambda of 0.75(C2) 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 (C2) in your formula.
Use the POISSON.DIST function.
Reference the number of customers in cellB5and the average number of customers needing service per day (C2) in your formula.
Reuse your formula to calculate the individual probabilities of the numbers of customers needing service in rangeB5:B34on a given day.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!