Can you input the answer to the practice problem into a Excel format?

Practice Problem:

A professional golf ball manufacturing company wanted to compare the distance traveled by golf balls produced using each of four different designs. Ten balls were manufactured with each design and were brought to the local golf course for the club professional to test. The order in which the balls were hit with the same club from the first tee was randomized so that the pro did not know which type of ball was being hit. All 40 balls were hit in a short period of time during which the environmental conditions were essentially the same. The results (distance traveled in yards) for the four designs are stored in the file Ball. (a) At the 0.05 level of significance, is there evidence of a difference in the mean distances traveled by the golf balls with different designs? (b) What assumptions are necessary in (a)?

Practice solution:

E bok%3A978-1-4614-8423-3.pdf 315 / 426 175% + : 1. A professional golf ball manufacturing company wanted to compare the distance traveled by golf balls produced using each of four different designs. Ten balls were manufactured with each design and were brought to the local golf course for the club professional to test. The order in which the balls were hit with the same club from the first tee was randomized so that the pro did not know which type of ball was being hit. All 40 balls were hit in a short period of time during which the environmental conditions were essentially the same. Answer: Anova: Single factor SUMMARY Groups Count Sum Average Variance Design1 10 2069.64 206.964 5.246427 Design2 10 2188.66 218.866 30.66718 Design3 10 2269.38 226.938 23.18213 Design4 10 2289.72 228.972 16.10697 ANOVA Source of variation SS df MS F P-value F crit Between groups 2990.99 3 997.00 53.03 0.00 2.87 Within groups 676.82 36 18.80 Total 3667.814 39 (a) At the 0.05 level of significance, is there evidence of a difference in the mean distances traveled by the golf balls with different designs? Because F = 53.03 > Forit = 2.8, there is a significant difference in the mean distances traveled by the golf balls with different designs (b) What assumptions are necessary in (a)? The assumptions are that the golf ball samples are randomly and indepen dently selected and the variances are constant