In: Statistics and Probability
a psychologist would like to examine the effects of a new drug on the activity level of animals. Three samples of rats are selected with n=5 in each sample. The rats in the first sample serve as a control and do not get any of the drug. The rats in the second group receive a small dose, and the rats in the third group get a large dose of the drug. The psychologist records the activity level for each animal. The data frm this experiment are presented below. No drug 0, 2, 2, 0, 1. Small dose 2, 2, 3, 2, 1. Large dose 5, 3, 2, 2, 3. What is SS, df, MS, F, and Pvalue between groups? Withing groups and total?
In Excel, enter the given data. Then go to "Data" - "Data Analysis" - select "Anova:Single Factor" in Analysis Tools and click "OK" as shown below:
A box opens with the title 'Anova: Single Factor'. Enter the input as shown below:
The significance level(Alpha) is 0.05 which is by default. If the question specifies any other significance level such as 0.10 or 0.01, you need to type that.
Then click "OK". You will get the output in the selected output range of 'e1' as follows:
Thus, we have SS, df, MS, F, and P-value for between groups, within groups and total from the above Anova table.