\fComplete the Excel Template: Assignment # 10. You will find Table B on pages 2 and 3. NOTE: Report all calculations using at least 4 decimals. (i.e. 0.1234 or 12.34%) Problem #1: Coronary Mortality The Scandinavian simvastatin survival study was a randomized clinical trial designed to evaluate the effects of the cholesterol lowering agent simvastatin in patients with coronary heart disease. Over 5.4 years of follow up, the treatment group consisting of 2221 individuals experienced 111 heart attacks. The placebo group of 2223 individuals experienced 189 heart attacks. a.) What are the risks in each group? b.) Test the difference for significance. c.) By what percentage did simvastatin lower heart attack mortality? Problem #2: Mortality due to any cause The Scandinavian study also tallied deaths due to any cause. The treatment group experienced 182 deaths, and the control group experienced 256 deaths. a.) What is the Relative Risk, RR? b.) What is the Association? c.) What is the Percentage Above or Below the Baseline? d.) Using OpenEpi.com, find the 95% Confidence Interval e.) At a Significance Level of 0.05, is there a significance difference.\fCoronary Mortality 1/2 pt Complete the 2x2 table Group Deaths Non-Deaths Total Treatment Control a) Treatment Risk pl-hat 1 pt Control Risk p2-hat b) Difference 1/2 pt (x1 + x2) / (n1 + n2) =combined occurences / combined sample sizes Common Standard Error: SQRT(( p x q )x(11 + 12)) p xq= 0 11 = 12 : (1] + 12) = p x qx (1] + 12) = 0 1/2 pt Common SE 0 1/2 pt z-stat = 1/2 pt p-value = (from Table B) 1 pt Conclusion C) Percent Simvastatin lowers heart attack mortality 1/2 pt 2 Mortality from all causes - Relative Risk, RR 1/2 pt Group Deaths Non-Deaths Total Treatment Control a) Treatment Risk - pl-hat 1 pt Control Risk =p2-hat 1/2 pt RR-hat = b) Association is Positive or Negative?: 1/2 pt C) Percetage compared to Baseline 1/2 pt Above or Below? d) 95 % Confidence Interval: 1 pt Using http://www.openepi.com/Twoby Two/TwobyTwo.htm 95% Confidence Level RR LCL UCL Risk Ratio e) Significant at the 5% Signifcance Level? 1 pt Conclusion