Solved: Eddie's Bicycle shop has a thriving business repairing bicycles. Trisha runs the reception

Eddie’s Bicycle shop has a thriving business repairing bicycles. Trisha runs the reception area

where customers check in their bicycles to be repaired and then later pick up their bicycles and

pay their bills. She estimates that the time required to serve a customer on each visit has a

uniform distribution between three minutes and eight minutes.

c.) Use Excel to generate 500 random observations and calculate the average. Compare this average to the mean of the service-time distribution.

The question is for only part c. of the question.
How did they get the service time numbers for excel. simply show what the formula is. One Study help told me to type in =(random_number*5)+3
I did that I got #NAME? reply. what is the correct way to inter the numbers with formula.

Can someone explain question c. to get the avarage to be 5.49.

Expert Answer

Answer

You can use the formula =INT(RANDBETWEEN(0,500)). The numbers 0 and 500 means the random numbers selected will be between 0 and 500 and the first function INT represents that these random numbers between 0 and 500 will be converted to integers.

Still stressed from student homework?

Get quality assistance from academic writers!

Order now