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

The data on the hospital stay worksheet show a sample of 100 hospital stays by Sex and LOS. Stays > three days are coded as Long; those three 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 conditionalprobabilities to provide an interpretation of the results.