From the course: Learning Excel: Data Analysis

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Analyze data using variance and standard deviation

Analyze data using variance and standard deviation - Microsoft Excel Tutorial

From the course: Learning Excel: Data Analysis

Start my 1-month free trial Buy for my team

Analyze data using variance and standard deviation

“

- [Instructor] In this movie I will show you how to calculate two important measures, variance and standard deviation. Variance is one measure of error that is the distance of values from the mean. Standard deviation is the square root of the variance. And as we'll see elsewhere in this course is extremely useful. My sample file is 0103 variance and you can find it in the chapter 1 folder of the exercise files collection. In this workbook I have a data set in cells A4 through A13. And in it I have values that reflect orders for a company. I've already calculated the mean or average in cell C1. To start, I need to calculate the error or distance from the mean of each of my order values. So I'll click and cell B4 and I'll type equal and I want to start with the value in A4, which is the order. And I will subtract the value in C1 which is the average. So if the order is lower than the average, then we'll get a negative value. I do want the cell reference to A4 to change, but I don't want…

Contents