Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Use the Emergency room wait spreadsheet in file Chpt 6-2.xls. a. Draw a simple random sample of 60 records, using any method you choose.

3. Use the Emergency room wait spreadsheet in file Chpt 6-2.xls.

a. Draw a simple random sample of 60 records, using any method you choose.

b. Test the null hypothesis at the 95 percent level of confidence that the average wait time is 38.4 minutes (H0 W = 38.4) against the alternative that the average wait time is not 38.4 minutes (H1 W 38.4), and state your conclusion.

c. Test the same hypothesis at the 99 percent level of confidence, and state your conclusion.

PLEASE USS EXCEL FORMULAS IN EXCEL FORMAT

Person Waiting Time
1 35
2 25
3 40
4 51
5 50
6 55
7 16
8 36
9 49
10 27
11 31
12 21
13 20
14 28
15 30
16 17
17 32
18 34
19 39
20 34
21 35
22 34
23 51
24 37
25 36
26 33
27 58
28 47
29 62
30 31
31 55
32 22
33 43
34 47
35 57
36 37
37 33
38 45
39 34
40 46
41 24
42 30
43 23
44 34
45 38
46 38
47 35
48 60
49 21
50 31
51 12
52 52
53 25
54 31
55 46
56 43
57 47
58 44
59 24
60 27
61 45
62 41
63 29
64 36
65 39
66 44
67 39
68 29
69 57
70 43
71 39
72 46
73 47
74 32
75 29
76 49
77 26
78 22
79 45
80 44
81 60
82 52
83 51
84 39
85 38
86 43
87 38
88 27
89 20
90 46
91 42
92 44
93 40
94 28
95 50
96 35
97 30
98 30
99 34
100 33
101 33
102 46
103 43
104 32
105 51
106 20
107 44
108 37
109 38
110 31
111 33
112 46
113 46
114 43
115 45
116 54
117 41
118 44
119 57
120 35
121 48
122 39
123 49
124 37
125 30
126 49
127 32
128 43
129 43
130 35
131 34
132 24
133 58
134 32
135 39
136 36
137 66
138 51
139 47
140 51
141 40
142 43
143 36
144 26
145 51
146 35
147 25
148 46
149 46
150 42
151 42
152 32
153 45
154 43
155 49
156 10
157 43
158 53
159 21
160 38
161 52
162 55
163 40
164 39
165 57
166 38
167 31
168 47
169 38
170 48
171 42
172 53
173 37
174 28
175 23
176 12
177 39
178 41
179 38
180 40
181 41
182 53
183 39
184 27
185 24
186 40
187 48
188 23
189 32
190 43
191 36
192 35
193 36
194 34
195 30
196 44
197 39
198 51
199 41
200 39
201 40
202 40
203 38
204 26
205 40
206 39
207 46
208 31
209 44
210 40
211 39
212 47
213 56
214 25
215 26
216 44
217 50
218 29
219 17
220 29
221 40
222 42
223 28
224 29
225 43
226 39
227 33
228 39
229 29
230 29
231 48
232 54
233 31
234 36
235 39
236 56
237 44
238 55
239 40
240 54
241 32
242 28
243 50
244 47
245 21
246 51
247 36
248 27
249 19
250 30
251 43
252 47
253 37
254 37
255 40
256 34
257 47
258 33
259 61
260 45
261 44
262 28
263 47
264 52
265 31
266 35
267 25
268 52
269 48
270 40
271 16
272 43
273 43
274 50
275 28
276 50
277 32
278 31
279 21
280 52
281 28
282 53
283 26
284 34
285 25
286 54
287 38
288 41
289 48
290 57
291 37
292 28
293 32
294 46
295 47
296 43
297 23
298 24
299 37
300 32
301 32
302 47
303 30
304 37
305 36
306 53
307 25
308 29
309 36
310 27
311 24
312 16
313 44
314 35
315 42
316 18
317 50
318 19
319 33
320 28
321 37
322 39
323 55
324 33
325 30
326 31
327 44
328 51
329 24
330 48
331 54
332 31
333 39
334 30
335 45
336 40
337 38
338 28
339 35
340 45
341 38
342 48
343 28
344 46
345 50
346 26
347 42
348 20
349 39
350 48
351 48
352 39
353 30
354 44
355 43
356 45
357 29
358 44
359 54
360 40
361 34
362 40
363 56
364 14
365 38
366 37
367 48
368 50
369 54
370 20
371 46
372 42
373 45
374 43
375 37
376 55
377 43
378 38
379 38
380 37
381 21
382 42
383 40
384 45
385 36
386 46
387 51
388 57
389 25
390 44
391 36
392 31
393 45
394 61
395 51
396 40
397 33
398 36
399 27
400 39
401 35
402 44
403 25
404 43
405 48
406 29
407 42
408 43
409 48
410 36
411 40
412 34
413 43
414 54
415 36
416 28
417 29
418 45
419 54
420 32
421 30
422 48
423 40
424 42
425 64
426 32
427 30
428 50
429 35
430 24
431 49
432 25
433 34
434 24
435 27
436 44
437 39
438 21
439 58
440 40
441 52
442 38
443 36
444 38
445 19
446 31
447 52
448 40
449 34
450 32
451 27
452 50
453 63
454 47
455 37
456 29
457 37
458 35
459 34
460 47
461 35
462 41
463 46
464 40
465 22
466 38
467 45
468 36
469 22
470 22
471 30
472 41
473 32
474 59
475 36
476 47
477 50
478 33
479 20
480 29
481 39
482 41
483 47
484 17
485 31
486 40
487 39
488 37
489 36
490 53
491 46
492 25
493 33
494 35
495 29
496 36
497 39
498 28
499 46
500 36
501 45
502 30
503 41
504 25
505 61
506 46
507 27
508 53
509 35
510 24
511 34
512 41
513 31
514 44
515 36
516 43
517 19
518 27
519 53
520 40
521 47
522 26
523 25
524 36
525 36
526 48
527 48
528 35
529 43
530 48
531 30
532 31
533 35
534 43
535 21
536 50
537 57
538 38
539 25
540 38
541 53
542 40
543 51
544 49
545 42
546 30
547 34
548 51
549 43
550 45
551 29
552 17
553 37
554 48
555 47
556 33
557 31
558 41
559 27
560 43
561 22
562 53
563 54
564 31
565 51
566 45
567 47
568 27
569 51
570 34
571 50
572 22
573 29
574 68
575 34
576 34
577 45
578 35
579 21
580 38
581 47
582 47
583 35
584 42
585 56
586 42
587 39
588 33
589 41
590 38
591 54
592 67
593 20
594 39
595 55
596 48
597 40
598 50
599 48
600 37
601 30
602 28
603 26
604 13
605 26
606 45
607 46
608 50
609 34
610 25
611 19
612 33
613 34
614 48
615 32
616 48
617 41
618 47
619 49
620 44
621 41
622 36
623 42
624 33
625 46
626 37
627 31
628 30
629 56
630 42
631 39
632 48
633 29
634 39
635 36
636 43
637 56
638 34
639 53
640 44
641 54
642 58
643 47
644 58
645 37
646 38
647 53
648 31
649 40
650 27
651 38
652 52
653 41
654 39
655 30
656 19
657 32
658 22
659 49
660 38
661 50
662 49
663 47
664 44
665 46
666 41
667 37
668 35
669 31
670 37
671 57
672 38
673 53
674 31
675 55
676 25
677 42
678 43
679 27
680 63
681 44
682 28
683 23
684 21
685 34
686 22
687 25
688 20
689 31
690 35
691 49
692 45
693 37
694 36
695 29
696 51
697 48
698 32
699 55
700 28
701 46
702 53
703 41
704 31
705 36
706 45
707 19
708 30
709 41
710 34
711 26
712 40
713 46
714 21
715 34
716 30
717 42
718 36
719 33
720 40
721 28
722 29
723 34
724 57
725 20
726 37
727 42
728 41
729 54
730 21
731 41
732 28
733 42
734 45
735 29
736 36
737 33
738 25
739 42
740 42
741 37
742 43
743 41
744 61
745 29
746 42
747 17
748 37
749 48
750 29
751 34
752 32
753 34
754 46
755 37
756 56
757 34
758 26
759 44
760 37
761 36
762 22
763 30
764 32
765 30
766 25
767 37
768 49
769 31
770 37
771 37
772 47
773 36
774 63
775 14
776 38
777 31
778 37
779 51
780 42
781 35
782 25
783 34
784 30
785 50
786 33
787 34
788 38
789 32
790 49
791 39
792 38
793 37
794 27
795 39
796 36
797 26
798 31
799 44
800 49
801 45
802 43
803 28
804 49
805 25
806 45
807 23
808 49
809 53
810 41
811 47
812 41
813 23
814 21
815 47
816 49
817 41
818 34
819 29
820 32
821 26
822 30
823 42
824 28
825 57
826 45
827 36
828 34
829 33
830 42
831 51
832 22

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Stochastic Processes

Authors: Emanuel Parzen

1st Edition

0486804712, 9780486804712

More Books

Students also viewed these Mathematics questions

Question

Draw a Cayley digraph for Z 8 taking as generating set S = {2, 5}.

Answered: 1 week ago

Question

e. What age client does the person see?

Answered: 1 week ago