Purchase Solution

Calculate One-Way ANOVA Using Raw Data and Excel

Not what you're looking for?

Ask Custom Question

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):

Purchase this Solution

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.

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 ...

Purchase this Solution


Free BrainMass Quizzes
Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.