9.5 Excel Activity 1a - Hypothesis Test for Proportion (Structured)

One of the reasons health care costs have been rising rapidly in recent years is the increasing cost of malpractice insurance for physicians. Also, fear of being sued causes doctors to run more precautionary tests (possibly unnecessary) just to make sure they are not guilty of missing something.

These precautionary tests also add to health care costs. Data in the Excel Online file provided below are consistent with findings in theReader's Digestarticle and can be used to estimate the proportion of physicians over the age of 55 who have been sued at least once. Construct a spreadsheet to answer the following questions.

(PLEASE SEE ATTACHED)

?

X HILL Excel File Home Insert Formulas Data Review View Help Tell me what you want to do X Cut Arial 10 - A" A" =E= 2 Wrap Text General Paste [B Copy Format Painter BIUDab --A- Merge & Center - Undo Clipboard Font Alignment Number C75 A B C D E F G 90 No 91 Yes 92 Yes 93 No 94 Yes 95 Yes 96 Yes 97 No 98 Yes 99 No 100 No 101 Yes 102 Yes 103 Yes 104 No 105 No 106 No 107 Yes 108 No 109 Yes 110 Yes 111 No 112 No 113 Yes 114 Yes 715 No A Data +Excel template S Home Insert Formulas Data Review View Help Tell me what you want to do X Cut Arial 10 " A A E ap Wrap Text General Paste [a Copy Format Painter BIUDab VA Merge & Center " $ ~ % Clipboard Font Alignment A B C D E F No Yes Yes Yes Yes Yes Yes Yes No Yes No Yes Yes Yes Yes No No No Yes Yes No No 8 Data + ation Mode: Automatic Workbook StatisticsExcel Home Insert Formulas Data Review View Help Tell me what yo X Cut Arial 10 AA BE 29 Wrap Tex Paste LG Copy Format Painter BIUDab VA Merge & Clipboard Font Alignment fx A B C D No Yes Yes Yes Yes Yes Yes No Yes Yes Yes Yes Yes Yes No No No Yes No Yes No Yes A Data +template - Saved Excel File Home Insert Formulas Data Review View Help Tell me what you want to do K Cut Arial - 10 . AA= = 29 Wrap Text General [B Copy Conditional Format Cell Insert Delete Format Paste Format Painter BIUDab - CA. E E Merge & Center - $ ~ % 9 68 40 Formatting . as Table . Styles Tables Cells Undo Clipboard Font Alignment Number C75 fx B C D E F G H K M 39 40 No 41 No 42 Yes 43 Yes 44 Yes 45 Yes 46 Yes 47 Yes 48 No 49 Yes 50 Yes 51 Yes 52 Yes 53 Yes 54 Yes 55 No 56 No 57 No 58 Yes 59 No 60 Yes 61 No 62 Yes 63 Yes Yes No Data + Calculation Mode: Automatic Workbook StatisticsX Excel File Home Insert Formulas Data Review View Help Tell me what you want to do X Cut Arial - 10 - A" A" 29 Wrap Text Genera Paste IB Copy Format Painter BIUDa --A- Merge & Center " Undo Clipboard Font Alignment C75 - fx A B C D E F 65 No 66 No Yes 68 Yes 69 Yes 70 No 71 Yes 72 No 73 Yes 74 No 75 Yes 76 Yes 77 No 78 Yes 79 Yes 80 No Yes 82 Yes 83 No 84 Yes 85 Yes 86 Yes No 88 Yes 89 Yes 90 No Yes A Data +X Excel File Home Insert Formulas Data Review View Help Tell me what you want to do 6 X Cut Arial 10 - A A 9 Wrap Text General Paste Le Copy Format Painter BIUD ab - -A- Merge & Center . $ - % 9 50 Undo Clipboard Font Alignment Number C75 A B C D E F G H 112 No 113 Yes 114 Yes 115 No 116 Yes 117 Yes 118 Yes 119 Yes 120 Yes 121 No 122 No 123 No 124 Yes 125 Yes 126 No 127 Yes 128 No 129 Yes 130 No 131 Yes 132 Yes 133 Yes 134 Yes 135 No 136 No 137 Yes A Data +X Excel File Home Insert Formulas Data Review View Help Tell me what you want to do X Cut Aria - 10 - A" A" E 12 Wrap Text General Paste LE Copy Format Painter BIU Dab - Q - A- BE Merge & Center . $ - % Undo Clipboard Font Alignment Num C75 A B C D E F 127 Yes 128 No 129 Yes 130 No 131 Yes 132 Yes 133 Yes 134 Yes 135 No 136 No 137 Yes 138 No 139 Yes 140 Yes 141 Yes 142 Yes 143 No 144 Yes 145 No 146 Yes 147 No 148 No 149 Yes 150 No 151 No 152 153 A Data + Calculation Mode: Automatic Workbook Statistics Type here to searchX Excel template File Home Insert Formulas Data Review View Help Tell me what you want to do X Cut Arial 10 AA ap Wrap Text Gener Paste Copy Format Painter BIUDab VAY E = = Merge & Center ~ $ - Undo Clipboard Font Alignment G12 A B C D F Have you been sued by a patient? Yes Sample Size 150 Yes No No No No No Yes 10 Yes Hypothesized Population Proportion 0.5 11 Yes 12 No 13 Yes 14 Yes 15 Yes 16 No Level of Significance (Alpha) 0.01 17 Yes 18 Yes 19 Yes 20 No vo.50 b. Use the Excel Online file provided above to compute the sample proportion of physicians over the age of 55 who have been sued at least once (to 2 decimals). Calculate the value of the test statistic (to 2 decimals). What is the p-value (to 4 decimal places)? Do not round intermediate calculations. c. At a = 0.01, what is your conclusion? Since p-value s v a= 0.01 , we reject Ho. We conclude that we have sufficient evidence to suggest that the proportion of physicians over the age of 55 who have been sued at least once is greater than .50. Back Autosaved at 8:58 PM Next