In: Statistics and Probability
Run the following ANOVA analysis in excel and interpret your findings. Upload your screen shots of the steps you took in running the analysis in excel.
Treatment 1 | Treatment 2 | Treatment 3 |
---|---|---|
0 | 1 | 6 |
1 | 4 | 5 |
0 | 1 | 8 |
3 | 2 | 5 |
Click Data----Data Analysis
Click OK
Give input range
tick Labels in First Row
Give Output Range
Click OK
Since P-value=0.0017<0.05 so we conclude that there population means of three treatments are not all equal.