Use excel spreadsheet and ANOVA
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. The results (distance traveled in yards) for the four designs are provided in the following table
Design 1 206.27 207.84 206.26 204.45 209.58 203.84 206.81 205.71 204.46 210.85
Design 2 217.16 221.42 218.09 224.17 211.91 213.84 221.36 229.39 213.51 214.52
Design 3 226.72 224.69 229.65 228.48 221.41 223.77 223.99 234.29 219.41 233.00
Design 4 230.54 227.94 231.77 224.94 229.53 231.03 221.56 235.51 228.28 225.13
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. If the results in (a) indicate that it is appropriate, use the Tukey-Kramer procedure to determine which designs differ in mean distances. C. At the 0.05 level of significance, is there evidence of a difference in the variation in the distances traveled by the golf balls with different designs? d. What golf ball design should the manufacturing manager choose? explain