Download the hypo_test_twomeans.xls. This is hypothetical data about two groups of students. A magic drug was given to group 1 and a placebo to group 2 and their grades were recorded to see if the drug made any difference. a. Moving on to the two-sample test, we will use a z-test to test for the equality between two means when the variances are known. ? Go to Data/Data Analysis/z-Test: Two Sample for Means ? Tell excel that your Variable 1 range is B2:B31 and variable 2 is B32:B61 ? The hypothesized mean difference is 0, Variable 1 variance is 1296, Variable 2 variance is 961, and check the box for Labels ? Leave ? = .05 ? Your output should be put in cell D6 b. Decide whether to reject or not reject the null hypothesis for both the 1 and 2 tailed tests. Put your answer in cells I10 and I16, respectively. c. We will now use a t-test to test for the equality of two means, when the standard deviations are assumed to be equal. ? Go to Data/Data Analysis/t-Test: Two Sample Assuming Equal Variances ? Tell excel that your Variable 1 range is B2:B31 and variable 2 is B32:B61 ? The hypothesized mean difference is 0 and check the box for Labels ? Leave ? = .05 ? Your output should be put in cell D21 d. Decide whether to reject or not reject the null hypothesis for both the 1 and 2 tailed tests. Put your answer in cells I25 and I31, respectively.

Excel file attached. please check my answers for accuracy and provide solution and explanation thanks

Magic Drug Exam Score 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 2 2 z-test Two Samples of Means 261 175 215 242 186 233 268 244 234 184 278 252 299 185 185 182 272 225 187 196 231 282 267 228 198 273 227 245 204 188 254 181 200 206 205 223 248 195 254 175 261 222 281 BEFORE Variance= AFTER 1296 Variance = z-Test: Two Sample for Means Mean Known Variance Observations Hypothesized Mean Difference z P(Z a reject or n reject TWO-TAILED Ho: b= a Ha: b a reject or n accept ONE-TAILED Ho: b a Ha: b > a reject or n reject TWO-TAILED Ho: b= a Ha: b a reject or n accept