From the course: Google Sheets: Advanced Formulas and Functions
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Calculate values in the normal distribution - Google Sheets Tutorial
From the course: Google Sheets: Advanced Formulas and Functions
Calculate values in the normal distribution
- [Instructor] Once you know the average and standard deviation of a data set, you can estimate how likely it is you'll see values in a given range. For example, you would know you'll only see values in one standard deviation above the mean about 32% of the time. No estimate is perfect but they can give you an idea of how likely a given value is. I'll start by describing normal distribution and how it relates to standard deviation before moving over to Google Sheets and show you how to perform relevant calculations. The normal distribution is centered on the mean and then this graph shows plus 1, plus 2, plus 3, plus 4, and plus 5 standard deviations above the mean. And then minus 1 through minus 5 standard deviations below the mean. The characteristics of the curve are such that 68% of the values will fall within plus or minus 1 standard deviation. 95% of the value will fall within plus or minus 2 standard deviations. And 99.7% will fall within plus or minus 3 standard deviations…
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.