A high school principal wanted to know if there was a difference in absences for 9thgrade, 10th grade, 11th grade, or 12th grade among students with less than a 2.0GPA. She took a random sample of n = 5 students from each grade and comparedabsences among the four grades using ANOVA. The data are below: 1. A high school principal wanted to know if there was a difference in absences for 9thgrade, 10th grade, 11th grade, or 12th grade among students with less than a 2.0GPA. She took a random sample of n = 5 students from each grade and comparedabsences among the four grades using ANOVA. The data are below:9th grade10th grade 11 th grade 12th gradevee ditiontssfol theThe data1017159.128.166.11111271114127141512A) Calculate the degrees of freedom Between Groups (dfBG)B) Calculate the degrees of freedom Within Group (dfwG)C) Calculate the Sum of Squares total (SStot)D) Calculate the Sum of Squares Between Groups (SSBG)E) Calculate Sum of Squares Within Groups (SSWG)F) Calculate Mean Square Between Group (MSBG)G) Calculate Mean Square Within Group (MSWG)H) Calculate the F statisticI) Using the table in the back of the book, find the critical value for F (Ferit) with a = .01J) Calculate the Tukey HSD using a = .01. Which are the appropriate statisticalconclusions?6

Since you have posted a question with multiple sub-parts, we will solve first three sub- parts for you. To get remaining sub-part solved please repost the complete question and mention the sub-parts to be solved.” (b) Obtain the value of the between degrees of freedom. Use EXCEL Procedure to obtain the value of the between degrees of freedom.. Follow the instruction to obtain the value of the between degrees of freedom.. Open EXCEL Go to Data>Data Analysis. Choose ANOVA: Single Factor. Enter the input range as $A$1:$D$6. Select Grouped By as Columns. Check the Labels in the first row. Set the alpha as 0.01 Click OK. EXCEL output: From the EXCEL output, the between groups degrees of freedom is 3 Thus, the value of between groups degrees of freedom is 3. . (b) Obtain the degrees of freedom for within groups. From the EXCEL output, the within groups degrees of freedom is 16 Thus, the value of within groups degrees of freedom is 16. (c ) Obtain the value of total sum of squares. From the EXCEL output, the value of total sum of squares is 209.75 Thus, the value of total sum of squares is 209.75.