Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started