Question

Suppose you want to know if different dosages of caffeine affect students’ performance on a test. We randomly sampled 15 college students and randomly assigned them to three conditions.

• Group 1: Very large dose of caffeine
• Group 2: Moderate dose of caffeine
• Group 3: Placebo (no caffeine)

The table below displays these 15 students’ scores.

Group1	Group 2	Group 3
15	26	10
16	25	9
14	23	9
13	20	6
12	21	6

1. Calculate SSB, SSW, SST, MSB, MSW, and F observed value. Fill out the blanks of this table.

	X	Y	Suppose you want to know if different dosages of caffeine affect students’ performance on a test. We randomly sampled 15 college students and randomly assigned them to three conditions. Group 1: Very large dose of caffeine Group 2: Moderate dose of caffeine Group 3: Placebo (no caffeine) The table below displays these 15 students’ scores. Group1 Group 2 Group 3 15 26 10 16 25 9 14 23 9 13 20 6 12 21 6 Calculate SSB, SSW, SST, MSB, MSW, and F observed value. Fill out the blanks of this table. X Y 1 15 1 16 1 14 1 13 1 12 2 26 2 25 2 23 2 20 2 21 3 10 3 9 3 9 3 6 3 6 SUM: SSB=                                                                dfB= MSB = SSW=      dfW= MSW = SST =   Fobs= 2. Fill out the blanks of the following ANOVA table. Source SS df MS F   Between Groups   Within Groups     Total 3. Perform the hypothesis testing to see if there are differences in test scores among the three groups. 4. Perform post-hoc comparisons. Find which groups are significantly different in test scores. 5. Enter the data in EXCEL. Analyze the data and attach the output. Confirm your results with the EXCEL output. Submit the output.

Answer 1

Anova by hand

Anova by excel

1. Arrange the data in excel as shown

2. In data analysis tab select one way anova .

3. Input the values as shown.

4. The output will be provided as shown below.