From the course: Google Sheets: Advanced Formulas and Functions
Unlock the full course today
Join today to access over 22,600 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.
Contents
-
-
-
-
-
(Locked)
Find the nth largest or smallest value1m 56s
-
(Locked)
Identify the smallest and largest values3m 49s
-
(Locked)
Rank values in a range4m 32s
-
Calculate distribution statistics3m 16s
-
(Locked)
Calculate values in the normal distribution8m 13s
-
(Locked)
Represent data using a mean of zero and standard deviation of one3m 26s
-
(Locked)
-
-
-
-
-