HOSPITAL STAY WORKSHEET The data on the Hospital Stay worksheet show a sample of
ID: 3388689 • Letter: H
Question
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 LongExplanation / Answer
HOSPITAL STAY WORKSHEET The data on the Hospital Stay worksheet show a sample of
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.