![]() ![]() 05, we can reject the null hypothesis and conclude that the means between the three groups are not equal. The p-value from the ANOVA table is 0.000588. #HOW TO DO AN ANOVA IN EXCEL 2013 HOW TO#Related: How to Perform a One-Way ANOVA in Excel The results of the one-way ANOVA are shown below: Suppose we perform a one-way ANOVA on three groups: A, B, and C. The following example shows how to perform the Tukey-Kramer test in Excel. The most commonly used post hoc test is the Tukey-Kramer test, which compares the mean between each pairwise combination of groups. It simply tells us that not all of the group means are equal. In order to find out exactly which groups are different from each other, we must conduct a post hoc test. However, this doesn’t tell us which groups are different from each other. If the p-value from the ANOVA is less than the significance level, we can reject the null hypothesis and conclude that we have sufficient evidence to say that at least one of the means of the groups is different from the others. The alternative hypothesis: (Ha): at least one of the means is different from the others ![]() The null hypothesis (H 0): µ 1 = µ 2 = µ 3 = … = µ k (the means are equal for each group) The hypotheses used in an ANOVA are as follows: A one-way ANOVA is used to determine whether or not there is a statistically significant difference between the means of three or more independent groups. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |