From the course: Complete Guide to Excel Statistics with Copilot
Join today to access over 24,400 courses taught by industry experts.
Copilot: Hypothesis testing
From the course: Complete Guide to Excel Statistics with Copilot
Copilot: Hypothesis testing
- [Instructor] Okay. In that chapter, we looked at hypothesis tests, and we saw there was a lot of heavy lifting to get our hypothesis tests complete, setting them up, establishing a level of significance, having our data and then from there, figuring out what our Z-score was, if what's what the test statistic that we were going to use. And knowing whether or not everything was within expectations or not. And in this case right here, we're looking at whether or not bags of food are filled or of dog food are filled appropriately. So do they have 40 pounds or do they not have 40 pounds? Are they too full or not full enough? And so we had our expected population of 40, our population standard deviation of 1.5, but then our sample was lower than 40, 39.59 and our sample size was 50. And then it was able to calc.. We calculated our standard error of the mean based off of these numbers. That being said, let's see how much of the work Copilot can do for us. So we're going to ask a rather…
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.
