Statistics Questions Need Excel Spreadsheet Filled Out

mat540 hw wk3(1) (1).docx HW3_answer_sheet.xlsx 

I am attaching 2 Excel Spreadhsheets.  The Professor is grading it more on the process than the final answer therefore I need the spreadsheets completely filled in.

1-a

The Hoylake Rescue Squad receives an emergency call every 1, 2, 3, 4, 5, or 6 hours, according

to the following probability distribution. The squad is on duty 24 hours per day, 7 days per 

week:

Time Between 

Emergency Calls (hr.) Probability

1 .05

2 .10

3 .30

4 .30

5 .20

6 .05

1.00

a. Simulate the emergency calls for 3 days (note that this will require a “running,” or

cumulative, hourly clock), using the random number table.

b. Compute the average time between calls and compare this value with the expected

value of the time between calls from the probability distribution. Why are the results

different?

Q-3

3. The Dynaco Manufacturing Company produces a product in a process consisting of operations of

five machines. The probability distribution of the number of machines that will break down in a

week follows:

Machine Breakdowns

per Week Probability

0 .10

1 .10

2 .20

3 .25

4 .30

5 .05

1.00

a. Simulate the machine breakdowns per week for 20 weeks.

b. Compute the average number of machines that will break down per week.

Q-5

5. Simulate the decision situation described in Problem 16(a) at the end of Chapter 12 for 20 weeks,

and recommend the best decision.

Q- 6

 Every time a machine breaks down at the Dynaco Manufacturing Company (Problem 3), either 1,

2, or 3 hours are required to fix it, according to the following probability distribution:

Repair Time (hr.) Probability

1 .30

2 .50

3 .20

1.00

a. Simulate the repair time for 20 weeks and then compute the average weekly repair time.