Data Matters with Excel®

Activity 8.2

Your task in this section is to redo the project from Section 8.1, replacing the equation for the observations.

In the last project, the formula for gathering the observations was =RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND()+RAND() . . . .

If you want to have the same mean but different variances, enter a different formula for each group.

Can you beat my populations that led the ANOVA to reject the null hypothesis 49% of the time even though the means of both populations were the same?

Can you find distributions with equal means for which the ANOVA would reject the null hypothesis 50% of the time?