Students will will run a a statistical test using excel for a given data set (See attached). This data set includes 4 exams for two different classes. Students will a) summarize what the data set is, b) identify a problem in which a statistical test could be used, c) identify which statistical test would be appropriate d) run the statistical test in excel e) explain the findings of and implications of the test results Formatting: Double spaced, size 12 Times New Roman font Submit as PDF or DOC A) Summarize what the data set is B) Identify a problem in which a statistical test could be used and why it is important to analyze this . Here are some examples of problems: o Is the average score of all exams greater than 70? o We want to compare performance on exams of online vs in person students o We want to compare the difficulty of Exam 1 vs Exam 4. o We want to see if we can predict Exam 4 score from Exam 1 score. c) Identify which statistical test would be appropriate . Why did you choose this statistical test? . What are your null and alternative hypotheses? . The appropriate statistical test will depend on what you are analyzing. o One sample hypothesis testing o Two sample tests o One way ANOVA o Simple Linear Regression D) Run the statistical test in excel and provide the output . Depending on the type of statistical test you choose, what coefficients should you interpret (e.g. p-value less than 05, positiveegative slope). . What do these numbers mean? E) explain the findings of and implications of the test results. . How do your results answer your original question? . What are the weaknesses and strengths of this study?Exam 1 Exam 2 Exam 3 Exam 4 A 2 Mean 84.33766234 Mean 75.14285714 Mean 73.32467532 Mean 64.31846414 3 Standard Error 1.125363219 Standard Error 2.134067185 Standard Error 2.097946915 Standard Error 2.464546182 Median 86 Median 78 Median 78 Median 69.56521739 5 Mode 94 Mode 76 Mode 80 Mode 0 6 Standard Deviation 9.875022171 Standard Deviation 18.72636355 Standard Deviation 18.40940946 Standard Deviation 21.62630498 7 Sample Variance 97.51606288 Sample Variance 350.6766917 Sample Variance 338.9063568 Sample Variance 467.697067 8 Kurtosis 0.145811447 Kurtosis 8.355691976 Kurtosis 8.163904266 Kurtosis 3.899183398 9 Skewness -0.69914302 Skewness -2.505818484 Skewness -2.510689949 Skewness -1.957949154 10 Range 44 Range 100 Range 100 Range 96 11 Minimum 56 Minimum 0 Minimum 0 Minimum 0 12 Maximum 100 Maximum 100 Maximum 100 Maximum 96 13 Sum 6494 Sum 5786 Sum 5646 Sum 4952.521739 14 Count 77 Count 77 Count 77 Count 77 15