# Statistics Questions Need Excel Spreadsheet Filled Out

**Question description**

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-55. Simulate the decision situation described in Problem 16(a) at the end of Chapter 12 for 20 weeks,

and recommend the best decision.

Q- 6Every 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.

## Tutor Answer

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors