Am I on the right track with my decision? Or do you advice me to use the classic one-way ANOVA or Welch’s ANOVA instead? If the classic one-way ANOVA is applicable, I plan to run Hsu’s MCB instead as my post hoc test, as I see it more powerful in this case compared to Tukey’s HSD.Īnother question I have is regarding the FWER, because I believe that having 5 groups will cause alpha inflation (my target alpha is 0.05). I remember being adviced that Brown-Forsythe F* leads to more valid results that Welch’s ANOVA when the sample size per group is incredibly small such as that lower than 7, so I plan to use it, along with Games-Howell. As such, I plan instead to conduct Welch’s ANOVA or Brown-Forsythe F*. The thing is I can only have 3 scores as my sample size per group and I cannot increase it anymore due to certain constraints. The significantly small sample size concerns me as I believe this will certainly affect the validity due to a highly likely unequal variances. My sample size within one group is 3 and this is the same for all groups. However, I am concerned that my sample size is too small. As such, I planned to conduct one-way ANOVA to identify equality in all means. I plan to propose conducting an experiment with 5 independent samples. If you do not mind, I would like to humbly ask for your advice. However, the ANOVA does not tell you where the difference lies.Good day.

The means of the three populations are not all equal. Therefore, we reject the null hypothesis. Click in the output range and select E1 CellĬonclusion: if F > F crit, we reject the null hypothesis. Click in the input range box and select range A2 to C10Ĥ. Select ANOVA: single factor and click okģ. If you don’t find Data Analysis Option click here to see how to enable Data Analysis Option.Ģ. Click on Data Menu, on top right-click on Data Analysis. To perform single factor ANOVA, execute following steps.ġ. H1: at least one of the means is different. Below you find weight loss per kg by using different methods. 9 undergo in diet program 9 in Exercise and another 9 in diet and exercise both. He takes 27 people and divide into three groups. We can Understand how to calculate by following example:-Įxample: A Dietician testing weight loss techniques. It determines that difference between samples are by chance or due to systematic treatment effect. It determines equality between two or more population mean.

How to do an anova in excel 2007