From the course: Complete Guide to Excel Statistics with Copilot
Join today to access over 24,400 courses taught by industry experts.
Copilot: ANOVA
From the course: Complete Guide to Excel Statistics with Copilot
Copilot: ANOVA
- [Instructor] In this chapter, we moved further into hypothesis tests, and this time, we were looking at ANOVA, analysis of variance. And we found that there's a lot of calculations, and we're really moving towards finding that F statistic. And we want to see whether or not Copilot can do some of the work for us to find that F statistic. And so we have a very small group here, three groups, and each group has three data points. So we want to see whether or not it can find the F statistic for us. So let's go ahead and ask that very simple question. All right, so I've put everything into a table, and I told it that we want to perform ANOVA on the three groups that are in that table. And simply what we want to find is the F statistic. So let's see how helpful it can be. All right, so it didn't actually calculate the F statistic for us. What it did was it did, it's basically walking us through a lot of the things that we did in the previous video. So it said find the mean of Group 1…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
