Homework SourseHOSPITAL STAY WORKSHEET The data on the Hospital Stay worksh
HOSPITAL STAY WORKSHEET
The data on the Hospital Stay worksheet show a sample of 100 hospital stays by Sex and LOS. Stays > 3 days are coded as Long; those 3 days or less are coded short.
A. Use the pivot table capability of Excel and the chi-square to test the hypothesis of independence between Sex and Stay as coded Long or short.
B. Use conditional probabilities to provide an interpretation of the results.
| ID | Sex | LOS | Stay |
| 1 | F | 4 | Long |
| 2 | F | 8 | Long |
| 3 | F | 10 | Long |
| 4 | M | 5 | Long |
| 5 | F | 3 | Short |
| 6 | F | 2 | Short |
| 7 | F | 5 | Long |
| 8 | M | 6 | Long |
| 9 | M | 6 | Long |
| 10 | F | 14 | Long |
| 11 | F | 11 | Long |
| 12 | M | 5 | Long |
| 13 | M | 6 | Long |
| 14 | F | 3 | Short |
| 15 | M | 3 | Short |
| 16 | F | 7 | Long |
| 17 | F | 6 | Long |
| 18 | F | 3 | Short |
| 19 | F | 11 | Long |
| 20 | F | 2 | Short |
| 21 | F | 2 | Short |
| 22 | F | 2 | Short |
| 23 | M | 7 | Long |
| 24 | F | 4 | Long |
| 25 | F | 10 | Long |
| 26 | F | 6 | Long |
| 27 | F | 3 | Short |
| 28 | F | 6 | Long |
| 29 | F | 6 | Long |
| 30 | M | 1 | Short |
| 31 | M | 3 | Short |
| 32 | F | 3 | Short |
| 33 | F | 5 | Long |
| 34 | M | 5 | Long |
| 35 | M | 3 | Short |
| 36 | M | 2 | Short |
| 37 | F | 6 | Long |
| 38 | M | 1 | Short |
| 39 | F | 10 | Long |
| 40 | F | 2 | Short |
| 41 | F | 2 | Short |
| 42 | F | 2 | Short |
| 43 | F | 3 | Short |
| 44 | M | 2 | Short |
| 45 | F | 6 | Long |
| 46 | F | 4 | Long |
| 47 | F | 10 | Long |
| 48 | F | 7 | Long |
| 49 | F | 4 | Long |
| 50 | F | 1 | Short |
| 51 | M | 2 | Short |
| 52 | F | 9 | Long |
| 53 | M | 2 | Short |
| 54 | F | 3 | Short |
| 55 | M | 4 | Long |
| 56 | F | 2 | Short |
| 57 | M | 1 | Short |
| 58 | F | 5 | Long |
| 59 | M | 12 | Long |
| 60 | F | 7 | Long |
| 61 | F | 4 | Long |
| 62 | M | 4 | Long |
| 63 | F | 1 | Short |
| 64 | F | 7 | Long |
| 65 | F | 2 | Short |
| 66 | F | 4 | Long |
| 67 | F | 14 | Long |
| 68 | F | 1 | Short |
| 69 | M | 10 | Long |
| 70 | F | 2 | Short |
| 71 | M | 1 | Short |
| 72 | M | 2 | Short |
| 73 | F | 10 | Long |
| 74 | F | 3 | Short |
| 75 | F | 7 | Long |
| 76 | M | 2 | Short |
| 77 | M | 9 | Long |
| 78 | M | 3 | Short |
| 79 | M | 3 | Short |
| 80 | F | 2 | Short |
| 81 | M | 11 | Long |
| 82 | F | 16 | Long |
| 83 | F | 3 | Short |
| 84 | M | 5 | Long |
| 85 | F | 1 | Short |
| 86 | F | 8 | Long |
| 87 | M | 5 | Long |
| 88 | F | 2 | Short |
| 89 | F | 10 | Long |
| 90 | M | 9 | Long |
| 91 | F | 7 | Long |
| 92 | F | 4 | Long |
| 93 | M | 5 | Long |
| 94 | F | 2 | Short |
| 95 | F | 5 | Long |
| 96 | F | 3 | Short |
| 97 | M | 7 | Long |
| 98 | M | 9 | Long |
| 99 | M | 7 | Long |
| 100 | M | 5 | Long |
Solution
