1. (3 pts) Use the file GolfBall_.xls found in the Problem Sets folder (*Note* the date will be different than the table in the textbook). You are trying to evaluate which golf ball goes the furthest distance. a. Set up your null and alternative hypotheses. Use PHStat –> Multi-Sample Tests -> One Way ANOVA select the Tukey-Kramer Proceedure checkbox. Get the P-value from the ANOVA sheet generated. Use the p-value to find your confidence and write up a short conclusion.
Your report should include:
• Hypotheses
• Output from Descriptive Statistics that check assumptions. If there are assumption issues then explain how they might affect your results.
• Output from excel that give you the P-value.
• A write-up that details how confident you are that the means differ and if they do, how they differ. If there were assumption issues account for these in your conclusions (for example, if the normality of the data was in question but the p-value was very high your conclusion may still be valid).
Design1 | Design2 | Design3 | Design4 |
199.78 | 217.27 | 224.11 | 207.28 |
200.38 | 211.46 | 236.22 | 199.22 |
201.37 | 217.31 | 226.33 | 201.96 |
201.55 | 223.31 | 228.52 | 202.25 |
202.9 | 211.99 | 221.44 | 194.97 |
201.47 | 230.05 | 230.36 | 198.75 |
198.98 | 214.81 | 231.48 | 201.9 |
201.67 | 220.93 | 220.15 | 206.19 |
200.99 | 217.71 | 223.31 | 196.15 |
201.7 | 221.5 | 232.12 | 201.15 |
A) Using Ms-excel
Anova: Single Factor | ||||||
SUMMARY | ||||||
Groups | Count | Sum | Average | Variance | ||
Design1 | 10 | 2010.79 | 201.079 | 1.233343 | ||
Design2 | 10 | 2186.34 | 218.634 | 31.15276 | ||
Design3 | 10 | 2274.04 | 227.404 | 27.05714 | ||
Design4 | 10 | 2009.82 | 200.982 | 15.31135 | ||
ANOVA | ||||||
Source of Variation | SS | df | MS | F | P-value | F crit |
Between Groups | 5219.553 | 3 | 1739.851 | 93.09667 | 5.02E-17 | 2.866266 |
Within Groups | 672.7913 | 36 | 18.68865 | |||
Total | 5892.344 | 39 |
Get Answers For Free
Most questions answered within 1 hours.