# Calculate One-Way ANOVA Using Raw Data and Excel

We have two drugs for the control of depression. Both are effective. However, we want to determine whether the motor-perceptual coordination of subjects under the

effects of these drugs is not significantly affected. The researcher selects a sample of 30 participants and divides it randomly into three groups: one for each drug and a

control group. The first group receives a placebo; the second group takes drug A and the third group, drug B. Then, the researcher measures the coordination of each

group and obtains the following data:

X1(control) X2(drug A) X3(drug B)

7 4 2

9 6 4

8 5 3

7 4 2

5 2 1

8 5 3

8 5 3

9 6 4

10 7 5

8 5 3

What should you conclude?

Using the 5% level of significance (alpha):

© BrainMass Inc. brainmass.com June 1, 2020, 8:46 pm ad1c9bdddfhttps://brainmass.com/statistics/analysis-of-variance/calculate-one-way-anova-raw-data-excel-317875

#### Solution Preview

1. Calculate the mean for each group by entering the raw data in columns A, D and G (cells A4-A13, D4-D13 and G4-G13)

2. Calculate the group mean for each group (cells A30, D30 and G30); you can create the formula or use the Excel function AVERAGE.

3. From each raw score, subtract the group mean to calculate deviations from the group mean (columns B, E and H).

4. Calculate the square of each deviation from the group mean (columns C, F and I).

5. Calculate the sums of the deviations and the sums of the squares of the deviations (cells B30, C30, E30, F30, H30 and I30) by adding the columns (you can create the formula or ...

#### Solution Summary

Given the raw data for three groups of subjects in an experimental study, this solution describes, step by step, how to calculate the F statistic and how to determine whether the differences between the means of the three groups are statistically significant.