From the course: Excel Statistics Essential Training: 2
Unlock the full course today
Join today to access over 24,200 courses taught by industry experts.
ANOVA: What is analysis of variance? - Microsoft Excel Tutorial
From the course: Excel Statistics Essential Training: 2
ANOVA: What is analysis of variance?
- [Instructor] All right, in this chapter, we're going to cover something called ANOVA. ANOVA stands for the Analysis of Variance. And before we get there, let's figure out where we just came from. We've been comparing populations. Up until now, we've been comparing two populations. How are they similar? How are they different? But ANOVA allows us to compare not two groups or not two populations but rather, three or more populations. And we're able to see whether or not they're the same or they're different. And if there is variance, is there variance between the groups or within the groups? So let's begin our journey in ANOVA here. And let's say that we have these three groups that are given to us. Maybe it's exam scores, maybe these are customer satisfaction scores for three different companies but these are three different groups. And each, we've grabbed a sample of three scores. So we have a sample size of…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.