Simulation – Discrete Event 1

Subject:BusinessPrice:18.89 Bought3

Share With

Simulation – Discrete Event 1. For the past 50 days, daily sales of laundry detergent in a large grocery store have been recorded (to the nearest 10). Units Sold 30 40 50 60 70 Number of Times 8 12 15 10 5 a. Determine the relative frequency for each number of units sold. b. Suppose that the following random numbers were obtained using Excel: .12 .96 .53 .80 .95 .10 .40 .45 .77 .29 c. Use these random numbers to simulate 10 days of sales. 2. The drying rate in an industrial process is dependent on many factors and varies according to the following distribution. Minutes 3 4 5 6 7 Relative Frequency .14 .30 .27 .18 .11 a. Compute the mean drying time. b. Using these random numbers, simulate the drying time for 12 processes. 33 .09 .19 .81 .12 .88 .53 .95 .77 .61 .91 .47 c. What is the average drying time for the 12 processes you simulated? © 2021. Grand Canyon University. All Rights Reserved. 3. Greenfields is a mail order seed and plant business. The size of orders is uniformly distributed over the interval from $25 to $80. Use the following random numbers to generate the size of 10 orders. .41 .99 .07 .05 .38 .77 .19 .12 .58 .60 4. Using the spreadsheet below, give the cell address which would have the formula shown. Cell Formula Belongs in Cell =VLOOKUP(B18,$B$10:$C$12,2) =VLOOKUP(D23,$F$11:$G$14,2) =K19*($I$16-I19) =VLOOKUP(H27,$B$10:$C$12,2) =AVERAGE(L18:L27) 2