From the course: Excel Statistics Essential Training: 2 (2019)

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Performing complex comparisons

Performing complex comparisons

From the course: Excel Statistics Essential Training: 2 (2019)

Start my 1-month free trial

Performing complex comparisons

- [Instructor] Now I'm going to show you some more about what to do after you do an ANOVA. The planned comparisons can get complex, and that's what I'll talk about here. When you plan a study with multiple samples, like, say, four samples called A, B, C and D, you typically have some specific comparisons in mind based on theory or on previous research, and here are some possible comparisons that aren't so simple, like will the average of sample A and B be different from the average of sample C and D? Will sample C have a lower mean than the average of sample A, B and D? Before gathering any data, you plan these comparisons in advance. You only carry them out if your results allow you to reject the null hypothesis. So these types of comparisons are called complex planned comparisons. Here's a formula for comparing the average of A and B versus the average of C and D. The 1/2 and the minus 1/2 are the comparison coefficients. The 1/2 to the left of the mean in A and the 1/2 to the left…

Contents