Player 1: 286, 309, 294, 290Player 2: 261, 282, 280, 273Player 3: 314, 301, 297, 312, 310I need help with part B within excel. Please show work. Thank you!

*3. The data in the accompanying table indicate the driving distance, in yards, from a random sample of drives for three golfers. a. Perform a one-way ANOVA using a = 0.05 to determine if there is a difference in the average driving distance these three players. b. Perform a multiple comparison test to determine which pairs are different using a = 0.05. 3 Click the icon to view the data table. 4 Click the icon to view a table of critical values for the studentized range. a. What are the correct hypotheses for the one-way ANOVA test? O A. Ho: Not all the means are equal. OB. Ho. H1 = H2 - H3 H1: H1 = H2 = H3 H1: H1 # H2 # H3 O C. Ho: H1 = H2 = H3 OD. Ho: H1 # H2 # H3 H1: Not all the means are equal. H1: H1 = H2 = H3 Complete the ANOVA summary table below. Sum of Degrees of Mean Sum of Source Squares Freedom Squares F Between 2408. 45 2 1204. 23 15-21 Within 791.55 10 19.16 Total 3200 12 Type integers or decimals rounded to two decimal places as needed.) * on Excel: Determine the p-value for this test. Data ? Data Analysis > Anova : Single Factor p-value = 0 .000 (Round to three decimal places as needed.) Input Range : highlight entire table. - V Labels in first row , Alpha: 05, new worksheet State the conclusion for a = 0.05. Since the p-value is (1)_ USS than the level of significance, (2) _reject the null hypothesis and conclude that the average driving distance (3) is different for these players. b. Let X1, X2, and x3 be the means for players 1, 2, and 3, respectively. Find the absolute values of the differences between the means. * 1 - X2| = 20.75 x 1 - X3 /= 12. 05 , and /x2 - X3 = 32. 80 Find the Tukey-Kramer critical range for each pair of samples. * K - 3 ( 3 Groups ) * N - sample size - 13 ( Total of " count coloma ) The critical range for samples 1 and 2 is CR1,2= * of ( between ) = 1 - 1 = 12 (Round to two decimal places as needed.) * df [ within ) - N - K = 13 - 3 = 10 The critical range for samples 1 and 3 is CR1,3= * df (total ) = N- 1 = 13-1 = 12 (Round to two decimal places as needed.) The critical range for samples 2 and 3 is CR2,3 = (Round to two decimal places as needed.) Q statistic at d : 0 .05 , K - 3 N - K . * CR - Q* SORT ( (MSW / 2) * (1/4 + ' /4 ) State the conclusion. are different. * CRIS = Q SQRT (( Mow / 2) + (1 /4 + 1 15 ) Conclude that the means for (4) * CR = Q SQRT (( MOW / 2)# (1/4 + 1 15) 3: Driving Distance in Yards for Three Golfers Driving Distance (Yards)