Question: Simulation - Discrete Event 1. For the past 50 days, daily sales of laundry detergent in a large grocery store have been recorded (to the

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 Number of Times 30 8 12 50 15 10 70 5 40 60 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. .27 2. The drying rate in an industrial process is dependent on many factors and varies according to the following distribution. Relative Minutes Frequency 3 1.14 4 .30 5 6 .18 7 .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? 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 177 1.19 1.12 058 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) EK19 ($1$16-119) =VLOOKUP(H27,$B$10:$C$12) N 12) WEAVERAGE(L18:L27)

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!

PROBSTATS1 1. For Each Claim below, write: (1) claim in mathematical form; (2) Null hypothesis (Ho); (3) alternative hypothesis (H,); (4) what tailed test. Use notations Hi. Hz (for mean), P-Pz (for...

Please can someone walk me though step by step in answering the question 1 through 4. Excel required in answering question Simulation - Discrete Event 1. For the past 50 days, daily sales of laundry...

SET A: One of the questions in a study of marital satisfaction of dual-career couples was to rate the statement, "I'm pleased with the way we divide the responsibilities for childcare." The ratings...

SET A: 1. For each Claim below, write: (1) claim in mathematical form; (2) Null hypothesis (Ho); (3) alternative hypothesis (H,); (4) what tailed test. Use notations Hi. Hz (for mean), P-Pz (for...

QUESTION 1: 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...

The quantity of clients hanging tight for blessing wrap administration at a retail chain is a rv X with potential qualities 0, 1, 2, 3, 4 and comparing probabilities 0.1, 0.2, 0.3, 0.25, 0.15. A...

Please i would need a step by step detailed explanation process to answers Simulation - Discrete Event 3.Greenfields is a mail order seed and plant business. The size of orders is uniformly...

Problem solving 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 Number of Times 30 8 40 12 50 15 60 10 70 5 a....

For the past 50 days, daily sales of laundry detergent in a large grocery store have been recorded to the nearest 10) Units Sola 30 40 SO 60 70 Number of Times 8 12 15 10 S Determine the relative...

Problem 5 (10 Points): 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....

The following are several of Graf Corporations accounts at the end of 2016: Account Credit Balance Common Stock, $10 par............. $ 47,100 Bonds Payable (due 2017)............ 126,000 Additional...

A furnace with an aperture of 20-mm diameter and emissive power of 3.72 x 105 W/m2 is used to calibrate a heat flux gage having a sensitive area of 1.6 x 10-5 m2. (a) At what distance, measured along...

Question 1 ( 1 0 points ) Today is Max s lucky day! They won $ 8 5 , 0 0 0 . 0 0 on a lottery scratch ticket. Max is excited to pay off a car loan they took out 1 8 months ago. The first $ 2 , 0 0 0...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...