Problem Set III.3 (3) - Mi File Home Insert Page Layout Formulas Data Review View K Cut Calibri * 11 - A Wrap Text General Normal Copy Paste 3 . A Conditional Format Check Cell Format Painter BIU - E Merge & Center * Formatting * as Table ~ Clipboard Font Alignment Number C31 =CHISQ.DIST.RT(C27,C29) A B C D E F G H K M N O 4 Observed Data Expected Values 5 None Mild Moderate Severe Row Total None Mild Moderate Severe 6 Treatment 12 24 37 49 122 Treatment 9.188285 17.86611 34.7113 60.23431 7 Placebo 6 11 31 69 117 Placebo 8.811715 17.13389 33.2887 57.76569 8 Column Total 18 35 68 118 239 9 10 1. According to the example in the video lecture, construct a table of expected values. Calculate the values that should go in the highlighted boxes (10 poin 11 12 2. Write appropriate null and alternative hypotheses for this study. (5 points) 13 Null: 14 Alternative: 15 16 3. Perform the Chi-square test for independence, using the "=chisq.test()" function that was introduced in the previous tab to obtain a P-value (5 points) 17 Please note that you do not have to input the degrees of freedom as you do with the "=t. test()" function because for chi-square, of = (Rows -1)(Columns -1) 18 P = 19 20 4. Do you reject the n