I need your help with the data attached. Can you kindly help me compute the problems found in the main attached?

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 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. Formu ate 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. H9: p 0.50 v V H.: p 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). :1 Calculate the value of the test statistic (to 2 decimals). :1 What is the p-value (to 4 decimal places)? Do not round intermediate calculations. :1 c. At a = 0.02, what is your conclusion? Since p-value a = 0.02 , we v Ho. We conclude that we have v evidence to suggest that the proportion of physicians over the age of 55 who have been sued at least once is greater than .50. A B C D E Have you been sued by a patient? Yes Sample Size 150 No Yes Yes No Yes No No Yes Hypothesized Population Proportion 0.5 Yes No No Yes Yes Yes Level of Significance (Alpha) 0.02 Yes Yes Yes Yes Yes Yes 23 Yes 24 No 25 Yes 26 Yes Yes 28 Yes 29 Yes 30 Yes 31 Yes 32 No 33 NoA 34 No 35 No 36 No 37 No 38 Yes 39 Yes 40 Yes 41 No 42 Yes 43 No 44 Yes 45 Yes 46 No 47 No 48 No 49 No 50 No 51 No 52 Yes 53 Yes 54 No 55 Yes 56 No 57 No 58 Yes 59 No 60 Yes 61 No 62 No 63 Yes 64 No 65 No 66 No 67 NoA B 68 No 69 Yes 70 Yes 71 Yes 72 Yes 73 No 74 No 75 Yes 76 No 77 No 78 Yes 79 Yes 80 Yes 81 No 82 Yes 83 No 84 Yes 85 No 86 No 87 No 88 Yes 89 No 90 Yes 91 Yes 92 Yes 93 Yes 94 Yes 95 No 96 Yes 97 No 98 No 99 Yes 100 Yes 101 NoCZ A B 102 No 103 No 104 No 105 No 106 Yes 107 Yes 108 Yes 109 No 110 Yes 111 Yes 112 No 113 Yes 114 No 115 Yes 116 Yes 117 Yes 118 Yes 119 No 120 Yes 121 No 122 No 123 Yes 124 No 125 Yes 126 No 127 Yes 128 Yes 129 Yes 130 Yes 131 No 132 No 133 Yes 134 Yes 135 Yes 136 Yes 137 Yes 138 Yes 139 Yes 140 Yes 141 Yes 142 No 143 No 144 No 145 Yes 146 Yes 147 Yes 148 Yes 149 Yes 150 Yes 151 Yes 152