A researcher is interested to know whether caffeine improves students' test performance. Study participants were divided into three groups: 1) No caffeine before the test 2) Low dose of caffeine before the test 3) High dose of caffeine before the test Below are test results for each group. Conduct ANOVA in Excel to determine if there are significant mean differences between any of the three groups. Assume alpha = 0.05 In your answer, state the null and the research hypotheses and explain whether the results of the ANOVA test led you to reject or fail to reject the null hypothesis. Copy/paste the data below into an Excel Sheet (or Google Sheets) and run ANOVA. Copy/paste the results in the response window below. Be sure to include your interpretation of the results. In your answer, state the null and the research hypotheses and explain whether the results of the ANOVA test led you to reject or fail to reject the null hypothesis. No caffeine Low Caffeine High Caffeine 87.99 84.62 79.79 71.15 86.90 56.93 70.21 94.12 79.10 64.44 96.43 88.30 76.02 93.75 84.70 73.10 85.71 84.04 84.50 98.02 95.62 70.97 96.07 92.86 82.83 84.38 79.81 94.22 87.09 81.15 92.71 80.00 55.00 79.48 78.57 77.66 85.45 87.50 91.79 70.49 89.29 80.55 83.28 75.80 77.20
A researcher is interested to know whether caffeine improves students' test performance.
Study participants were divided into three groups:
1) No caffeine before the test
2) Low dose of caffeine before the test
3) High dose of caffeine before the test
Below are test results for each group.
Conduct ANOVA in Excel to determine if there are significant mean differences between any of the three groups.
Assume alpha = 0.05
In your answer, state the null and the research hypotheses and explain whether the results of the ANOVA test led you to reject or fail to reject the null hypothesis.
Copy/paste the data below into an Excel Sheet (or Google Sheets) and run ANOVA.
Copy/paste the results in the response window below. Be sure to include your interpretation of the results. In your answer, state the null and the research hypotheses and explain whether the results of the ANOVA test led you to reject or fail to reject the null hypothesis.
| No caffeine | Low Caffeine | High Caffeine |
| 87.99 | 84.62 | 79.79 |
| 71.15 | 86.90 | 56.93 |
| 70.21 | 94.12 | 79.10 |
| 64.44 | 96.43 | 88.30 |
| 76.02 | 93.75 | 84.70 |
| 73.10 | 85.71 | 84.04 |
| 84.50 | 98.02 | 95.62 |
| 70.97 | 96.07 | 92.86 |
| 82.83 | 84.38 | 79.81 |
| 94.22 | 87.09 | 81.15 |
| 92.71 | 80.00 | 55.00 |
| 79.48 | 78.57 | 77.66 |
| 85.45 | 87.50 | 91.79 |
| 70.49 | 89.29 | 80.55 |
| 83.28 | 75.80 | 77.20 |
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
