Statistics Questions Need Excel Spreadsheet Filled Out

Oct 25th, 2014
DotaCN
Category:
Mathematics
Price: $20 USD

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



Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UC Berkeley
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
kevin12622
Dec 4th, 2016
" Goes above and beyond expectations ! "
kiln82
Nov 25th, 2016
" awesome work thanks "
ashleyisgod
Nov 21st, 2016
" Top quality work from this guy! I'll be back! "
likeplum4
Nov 12th, 2016
" Excellent work as usual "
Molly_Moon
Oct 29th, 2016
" AMAZING as always! "
kpcutie
Oct 20th, 2016
" Excellent job "
Hemapathy
Oct 7th, 2016
" all I can say is wow very fast work, great work thanks "
pmallory
Sep 28th, 2016
" Totally impressed with results!! :-) "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1820 tutors are online

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