From the course: Excel: Statistical Process Control

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Calculate means and standard deviations

Calculate means and standard deviations - Microsoft Excel Tutorial

From the course: Excel: Statistical Process Control

Start my 1-month free trial

Calculate means and standard deviations

“

- [Instructor] In the previous movie, I described the normal distribution and how it can be used to evaluate data. In this movie I'll show you how to calculate the two main components of the distribution, means and standard deviations, using Excel formulas. My sample file is 01_03 Means and Standard Deviations, which is an Excel file that you can find in the chapter 1 folder of the exercise files collection. At the left of the screen, I have an Excel table that has the average daytime temperature for 10 days. And what I'd like to do is to determine two things. The first is the mean, or the average, and the second is the standard deviation. So I'm interested in a typical value and also how much it tends to vary. Once I have calculated the standard deviation I want to see what plus or minus 3 standard deviations look like. Remember, under the normal curve 99.7% of all values will be within plus or minus 3 standard deviations of the average, so knowing those values can help you know when…

Contents