Statistics Questions Need Excel Spreadsheet Filled Out

User Generated

goevryyr

Mathematics

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-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.



Unformatted Attachment Preview

MAT540 Homework Week 3 Page 1 of 2 MAT540 Week 3 Homework Chapter 14 1. 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.) 1 2 3 4 5 6 Probability 0.05 0.10 0.30 0.30 0.20 0.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? 2. The time between arrivals of cars at the Petroco Service Station is defined by the following probability distribution: Time Between Arrivals (min.) 1 2 3 4 Probability 0.15 0.30 0.40 0.15 1.00 a. Simulate the arrival of cars at the service station for 20 arrivals and compute the average time between arrivals. b. Simulate the arrival of cars at the service station for 1 hour, using a different stream of random numbers from those used in (a) and compute the average time between arrivals. c. Compare the results obtained in (a) and (b). 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: MAT540 Homework Week 3 Page 2 of 2 Machine Breakdowns per Week 0 1 2 3 4 5 Probability 0.10 0.10 0.20 0.25 0.30 0.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. 5. Simulate the decision situation described in Problem 16(a) at the end of Chapter 12 for 20 weeks, and recommend the best decision. Reference Problem 16(a) in Chapter 12: A concessions manager at the Tech versus A&M football game must decide whether to have the vendors sell sun visors or umbrellas. There is a 30% chance of rain, a 15% chance of overcast skies, and a 55% chance of sunshine, according to the weather forecast in College Junction, where the game is to be held. The manager estimates that the following profits will result from each decision, given each set of weather conditions: Weather Conditions Overcast Sunshine .15 .55 Sun visors $-200 $1,500 Umbrellas 0 -900 a. Compute the expected value for each decision and select the best one. Decision Rain .30 $-500 2,000 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.) 1 2 3 Probability 0.30 0.50 0.20 1.00 a. Simulate the repair time for 20 weeks and then compute the average weekly repair time. Hoylake Rescue Squad Probability of Time between calls P(x) 0.05 0.1 0.3 0.3 0.2 0.05 1 Time between calls Cumulative 0 1 0.05 2 0.15 3 0.45 4 0.75 5 0.95 6 EV = Average Time = Simulation RN Time Cumulative between calls clock Petroco service Simulation Probability 0.15 0.3 0.4 0.15 1 a. Avg Arrival time b. Avg. arrival time Compare a. and b. Cumulative 0 0.15 0.45 0.85 Time between arrival (min) 1 2 3 4 Counts 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 RN Time between calls RN Time between calls Cumulative clock Dynaco Manufacturing Probability breakdown per week P(x) 0.1 0.1 0.2 0.25 0.3 0.05 1 Cumulative 0 0.1 0.2 0.4 0.65 0.95 Simulated avg. breakdown Average breakdowns = Breakdown 0 1 2 3 4 5 Simulation Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 RN Breakdowns Sun Visor or Umbrella? Simulation P(x) 0.3 Cumulative 0 Sun Visor -500 Week 1 0.15 0.3 -200 2 0.55 1 0.45 1500 3 4 5 P(x) 0.3 0.15 0.55 1 Cumulative 0 0.3 0.45 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Umbrella 2000 0 -900 Average RN SunVisor ($) RN Umbrella ($) Decision Sun visors Rain 0.3 ($500) Umbrellas 2,000 a. Ans: Weather Conditions Overcast Sunshine 0.15 0.55 ($200) $1,500 0 -900 Compute the expected value for each decision and select the best one. Sun Visor Umbrella $ $645 105.00 Dynaco Manufacturing Repair Time P(x) 0.3 0.5 0.2 1 Simulation Cumulative 0 0.3 0.8 Simulated avg. repair time Repair (hrs) 1 2 3 Week 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 RN Repair time (hours)
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer


Anonymous
Great! Studypool always delivers quality work.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags