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. 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. H0: p.050 Ha: p.050 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). Calculate the value of the test statistic (to 2 decimals). What is the pvalue (to 4 decimal places)? Do not round intermediate calculations. c. At a = 0.01, what is your conclusion? Since p-value a = 0.01 , 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. Excel template - Saved v Search (Option + Q) File Home Insert Draw Page Layout Formulas Data Review View Help Edi 5 v Q v Arial 10 B Av . . . Number D4 fx F G A B C D E Have you been sued by a patient? Formulas Yes Sample Size 150 Yes No Number of People Who Answered "Yes" #N/A No Yes Number of People Who Answered "No" #N/A Yes No Sample Proportion (2 decimals) #N/A Yes Yes Hypothesized Population Proportion 0.50 Yes Yes Test Statistic (2 decimals) #N/A No Yes p-value (4 decimals) #N/A Yes No Level of Significance (Alpha) 0.01 Yes Yes Reject Null Hypothesis? #N/A Yes Can one conclude that the proportion of physicians over the age of 55 who have been sued at least once is greater than 20 Yes 50? #N/A 21 Yes 22 No No Yes No No Yes Yes Yes Yes Yes 32 Yes 33 Yes 34 No 35 Yes 36 Yes Yes No 39 Notemplate Saved v File Home Insert Draw \"9 v E v s? : D4 v X \\/ r A A B 40 No 41 Yes 42 Yes 43 Yes 44 Yes 45 Yes 46 Yes 47 No 48 No 49 No 50 No 51 Yes 52 No 53 Yes 54 Yes 55 No 56 Yes 57 Yes 58 Yes 59 Yes 60 No 61 Yes 62 No 63 No 64 No 65 Yes 66 No 67 Yes 68 Yes 69 No 70 No 71 No 72 Yes 73 Yes 74 Yes 75 No 76 No 77 Yes 78 No 79 No 80 Yes 81 No Excel template - Saved v File Home Insert \"WW/WE D4 v>