Please provide the excel formulas
D E F B C Have you been sued Formulas by a patient? 150 Yes Sample Size Yes #N/A Yes Number of People Who Answered "Yes" No #N/A Yes Number of People Who Answered "No" No #N/A No Sample Proportion (2 decimals) No 0.50 Yes Hypothesized Population Proportion 10 11 Yes #N/A Yes Test Statistic (2 decimals) 13 No #N/A 14 Yes p-value (4 decimals) Yes 0.02 Yes Level of Significance (Alpha) 17 Yes #N/A 18 Yes Reject Null Hypothesis? 19 Yes Can one conclude that the proportion of physicians over the age of 55 who have been sued at least once is greater than #N/A 50? 20 No 21 Yes 22 Yes 23 No 24 No 25 Yes 26 No 27 Yes 28 Yes 29 Yes 30 Yes 31 Yes 32 No 33 Yes 34 Yes 35 Yes 36 No 37 Yes 38 Yes 39 Yes 40 No 41 Yes 42 No 43 No 44 No 45 Yes 46 No 47 Yes 48 Yes 49 No 50 No 51 No 52 Yes Yes NoA B C D 54 No 55 Yes 56 Yes 57 No 58 No 59 No 60 Yes 61 Yes 62 Yes 63 Yes 64 Yes 65 Yes 66 Yes 67 No 68 Yes 69 Yes 70 No 71 Yes 72 Yes 73 No 74 Yes 75 No 76 No 77 No 78 Yes 79 Yes 80 No 81 No 82 No 83 Yes 84 Yes 85 Yes 86 Yes 87 Yes 88 Yes 89 No 90 Yes 91 No 92 Yes 93 Yes 94 Yes 95 Yes 96 No 97 Yes 98 No 99 Yes 100 Yes 101 Yes 102 Yes 103 Yes 104 No 105 No 106 Yes 107 No 108 No 109 No 110 No 111 YesA B C 104 No 105 No 106 Yes 107 No 108 No 109 No 110 No 111 Yes 112 Yes 113 Yes 114 Yes 115 Yes 116 No 117 No 118 Yes 119 No 120 No 121 No 122 Yes 123 Yes 124 Yes 125 No 126 Yes 127 No 128 Yes 129 No 130 Yes 131 Yes 132 No 133 Yes 134 Yes 135 Yes 136 No 137 Yes 138 No 139 Yes 140 No 141 Yes 142 Yes 143 No 144 No 145 Yes 146 Yes 147 No 148 No 149 No 150 Yes 151 Yes 152One 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 le provided below are consistent with ndings in the Reader's Digest article 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. Open spreadsheet a. Formulate hypotheses that can be used to see if these data can support a finding that more than half of physicians over the age of 55 have been sued at least once. Ha = 19-9 0-50 Ha: 13-9 0'50 b. Use the Excel Online le provided above to compute the sample proportion of physicians over the age of 55 who have been sued at least once (to 2 decimals). :l Calculate the value of the test statistic (to 2 decimals). :l What is the p-value (to 4 decimal places)? Do not round intermediate calculations. :l c. At a = 0.02, what is your conclusion? Since p-value a : 0.02 , we Ho. We conclude that we have evidence to suggest that the proportion of physicians over the age of 55 who have been sued at least once is greater than .50
