**ONLY NEED PROBLEM 3** Show work in Excel QM

The number of cars arriving per hour at Lundbergs Car Wash during the past 200 hours of operation is observed to be the following:

Number of Cars Arriving	Frequency
3 or fewer	0
4	20
5	30
6	50
7	60
8	40
9 or more	0
Total:	200

• Set up a probability and cumulative probability distribution for the variable of car arrivals.
• Establish random number intervals for the variable.
• Simulate 15 hours of car arrivals and compute the average number of arrivals per hour. Select the random numbers needed from the random number table.

Problem-3:

Compute the expected number of cars arriving in the previous problem using the expected value formula. Compare this with the results obtained in the simulation.