USING EXCEL TO SOLVESusan Sherer’s grocery store has noted the following figures with regard to the number of people who arrive at the store’s three checkout stands and the time it takes to check them out:ARRIVALS/MINUTEFREQUENCY00.310.520.2 SERVICE TIME/MINUTEFREQUENCY10.120.330.440.2Simulate the utilization of the three checkout stands over 5 minutes, using the following random numbers: 07, 60, 77, 49, 76, 95, 51, 16, and 14. Record the results at the end of the 5-minute period. Start at time = 0.

Answered: USING EXCEL TO SOLVE Susan Sherer’s…

Holt Mcdougal Larson Pre-algebra: Student Edition 2012

1st Edition

ISBN:9780547587776

Author:HOLT MCDOUGAL

Publisher:HOLT MCDOUGAL

Chapter6: Ratio, Proportion, And Probability

Section6.7: Probability And Odds

Problem 2C

See similar textbooks

Related questions

Question

USING EXCEL TO SOLVE

Susan Sherer’s grocery store has noted the following figures with regard to the number of people who arrive at the store’s three checkout stands and the time it takes to check them out:

ARRIVALS/MINUTE	FREQUENCY
0	0.3
1	0.5
2	0.2

SERVICE TIME/MINUTE	FREQUENCY
1	0.1
2	0.3
3	0.4
4	0.2

Simulate the utilization of the three checkout stands over 5 minutes, using the following random numbers: 07, 60, 77, 49, 76, 95, 51, 16, and 14. Record the results at the end of the 5-minute period. Start at time = 0.

Expert Solution