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-aThe Hoylake Rescue Squad receives an emergency call every 1, 2, 3, 4, 5, or 6 hours, accordingto the following probability distribution. The squad is on duty 24 hours per day, 7 days per week:Time Between Emergency Calls (hr.) Probability1 .052 .103 .304 .305 .206 .051.00a. Simulate the emergency calls for 3 days (note that this will require a “running,” orcumulative, hourly clock), using the random number table.b. Compute the average time between calls and compare this value with the expectedvalue of the time between calls from the probability distribution. Why are the resultsdifferent?Q-33. The Dynaco Manufacturing Company produces a product in a process consisting of operations offive machines. The probability distribution of the number of machines that will break down in aweek follows:Machine Breakdownsper Week Probability0 .101 .102 .203 .254 .305 .051.00a. 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- 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.) Probability1 .302 .503 .201.00a. Simulate the repair time for 20 weeks and then compute the average weekly repair time.

Looking for this or a Similar Assignment? Click below to Place your Order

Open chat