From the course: Complete Guide to Excel Statistics with Copilot
Join today to access over 24,400 courses taught by industry experts.
Continuous: Creating a normal curve in Excel
From the course: Complete Guide to Excel Statistics with Copilot
Continuous: Creating a normal curve in Excel
- [Instructor] Throughout this course, we have seen the normal curve and the power that goes with understanding the normal distribution. So let's go ahead and build a normal curve in Excel. So as you can see in Excel, I've provided a foundation for you to build off of. I've listed the first Z-value and with a normal distribution, we're going to need many Z-values to build that distribution. So what I'm going to do is I'm going to go ahead and I'm going to add 0.1. And what this is going to allow us to do is when we copy this down, you'll notice that it's taken us from a Z-value of negative three, so three standard deviations in a negative direction, all the way to positive three, three standard deviations in the positive direction. And we can also see that this right here, a normal distribution, our mean is zero. So that's our center point. Next thing we want to do is we want to fill in some formulas here. So the first thing what we'll do is the, and you can see the formula that we're…
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.
