A golf ball manufacturer desires to compare the distance traveled by golf balls using four unique designs. Fifteen balls were manufactured and each was brought to the local golf course for testing by the local pro. The order of the golf balls hit by the professional was randomized so the pro did not know which ball was being hit. All 60 balls were hit over a short time period to reduce any potential environmental effects. Distances traveled for each ball are linked here Preview the documentView in a new window(xlsx). Use the data linked above to answer the following questions: 1 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? 2 Do the results in question 1 indicate that it is appropriate to use the Tukey-Kramer procedure to determine which designs differ in mean distances? You may need to do a little research of your own to get the equations to do thisit is not hard but Excel does not do this calculation with a couple of clicks. 3 If the golf ball manufacturer wished to build the golf ball with the greatest distance which design should the firm select?
A B C D 1 198.07 218.66 221.33 208.40 2 199.62 215.80 218.83 212.57 3 197.94 220.56 222.57 209.32 4 196.27 219.37 215.88 215.16 5 201.26 212.58 220.31 203.35 6 195.66 214.90 221.86 205.34 7 198.48 215.01 212.67 212.43 8 197.45 224.93 226.03 220.25 9 196.31 210.72 219.22 205.00 10 202.43 223.68 216.09 205.93 11 191.64 207.17 210.08 204.07 12 188.42 210.59 207.24 206.56 13 187.83 206.30 212.98 197.13 14 189.55 215.93 216.99 211.44 15 194.33 214.73 207.44 197.69