Plz can u include excel file

Font Alignment Number Styles Cells Editing TextBox 5 X V f A B C D E F G H K M N O P Q R S 1 School A School B School C School D School E School F School G School H School 1 School J School K School L School M School N School O Residual cal (A, C Sorted Resid Index i Pr 18 20 22 20 19 20 16 23 14 19 24 17 25 18 18 23 20 18 20 25 20 21 18 18 26 18 20 17 20 19 Q4. (6 marks) A school superintendent wants 21 19 17 21 21 18 21 25 26 16 20 22 18 21 18 to test a new method of teaching arithmetic 19 18 23 22 23 18 20 22 21 27 23 17 21 17 21 to 4th graders at the 15 schools in his district. 22 22 18 16 19 18 19 16 23 22 17 18 18 20 18 He plans to select 8 students from each 23 19 17 19 25 19 19 19 22 21 18 22 17 19 18 school to take part in the experiment, but to 16 18 20 15 25 20 22 23 25 19 15 19 22 23 20 make sure they are roughly of the same 19 22 19 21 17 21 26 24 19 22 21 15 19 18 ability, he first gives a test to all 120 students 10 and the test scores are listed in the table above 12 O O A) Answer O 13 I a) State the null and alternate hypothesis we 14 O would run to determine if the test scores 15 across all 15 schools is the same. O b) Run a one-way ANOVA on these data. Show O O Excel output. 17 B) Answer See the page for ANOVA output c) What conclusions can you make based on 18 the p-value of this test? 19 F-value = d) Obtain boxplots and residuals plots of this 20 p-value = data set. 21 e) Draw box plot to illustrate all data set in 22 C) Answer one graph. Draw one residual NPP and a box 23 plot with combined residual for School A, 24 school G and School O, and discussion if all 25 assumptions been met? Explain using your 26 plots to illustrate your answer. 27 D) Answer 28 29 Cover-intro Q1 02 0 Q4 05 Q6 Scroll Lock