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 simple comparisons

Performing simple comparisons

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

Start my 1-month free trial

Performing simple comparisons

- [Instructor] Now I'm going to show you what to do after you do an ANOVA. An ANOVA just lets you know whether or not you have a significance difference somewhere in a set of sample means. That's not enough; you have to know exactly where that difference is and that's what I'll cover right now. 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, probably based on theory or on previous research. Like will the mean of sample A be different from the mean of sample B? Will sample C have a lower mean than sample 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 kinds of comparisons are called Planned Comparisons. I've also seen them called A Priori Comparisons. You can use a t-Test for a Planned Comparison and here's the formula for comparing the mean of sample A with the mean of sample B…

Contents