From the course: Complete Guide to Excel Statistics with Copilot
Join today to access over 24,400 courses taught by industry experts.
Copilot: Confidence intervals
From the course: Complete Guide to Excel Statistics with Copilot
Copilot: Confidence intervals
- [Instructor] So we just looked at confidence intervals, and we looked at it using both proportions and means. And we looked at t-scores, and we looked at a number of different things. So what we want to do here is take a look at a few different scenarios, which we just saw, or something very similar to those, and we want to see whether or not it can help us find our lower limits and upper limits for our confidence intervals. And you may remember this video or this set of data from a video we just saw. And in order to complete this, what we need to do is we need to find for our upper and lower limits for our confidence interval, we need a p-hat, we need a z-value, and we need a standard error. Now, the z-value, we've already established that we're looking for 1.96 because we know that that is the 95% confidence interval. That's the special number that we use over and over again. So we're going to just stick with that number. But what we need to do is, if we have our sample here of 50…
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.
