Probability and Statistics > Basic Statistics > How to Find the Sample Variance

Watch the video for an example or read on below for several more example of how to find the sample variance:

The sample variance and standard deviation are ways to measure how spread out a data set is. The sample variance is just the variance in a sample. It gives you an idea of how much your sample differs from the average population. By itself, the variance isn’t really a meaningful number. Technically, the variance is used to determine the “error bound” for estimates. But it’s an essential step in calculating the standard deviation. **Standard deviation is just the square root of variance**. The variance formula can be tricky to use—especially if you are rusty on order of operations. By far the easiest way to find the variance is to use an online standard deviation calculator . You can also use it to check your work. Have to work the formula by hand? Read on!

## How to Find the Sample Variance

If you’re finding the sample variance by hand, the “usual” formula you’re given in textbooks is:

However, if you’re working the formula by hand, it can be a bit cumbersome. An alternative version is the computational formula, which can be easier to work:

Click for examples:

- Example 1: Variance (computational formula).
- Example 1: Standard Deviation.
- Example 2 (computational formula, both).
- Example 3 (usual formula, both).
- Example 4 (computational formula, both).
- How to Find the Sample Variance in Excel

## How to Find the Sample Variance by Hand: Variance Example 1

**Question**: Find the variance for the following set of data representing trees in California (heights in feet): 3, 21, 98, 203, 17, 9

Step 1: Add up the numbers in your given data set.

3 + 21 + 98 + 203 + 17 + 9 = 351

Step 2: Square your answer:

351 × 351 = 123,201

…and divide by the number of items. We have 6 items in our example so:

123,201 / 6 = 20,533.5

Set this number aside for a moment.

Step 3: Take your set of original numbers from Step 1, and square them individually this time:

3 × 3 + 21 × 21 + 98 × 98 + 203 × 203 + 17 × 17 + 9 × 9

Add those numbers (the squares) together:

9 + 441 + 9604 + 41209 + 289 + 81 = 51,633

Step 4: Subtract the amount in Step 2 from the amount in Step 3.

51,633 – 20,533.5 = 31,099.5

Set this number aside for a moment.

Step 5: Subtract 1 from the number of items in your data set*. For our example:

6 – 1 = 5

Step 6: Divide the number in Step 4 by the number in Step 5. This gives you the **variance**:

31,099.5 / 5 = 6,219.9

### How to find the sample variance: Standard Deviation Example 1

Step 7: Take the square root of your answer from Step 6. This gives you the **standard deviation**:

√6,219.9 = 78.86634

*That’s it!*

***Important note: **The standard deviation formula is **slightly different **for populations and samples (a portion of the population). If you have a population, you’ll be dividing by “n” (the number of items in your data set). However, if you have a sample (which is the case for most statistics questions you’ll get in class!) you’ll need to divide by n-1.

Like the explanation? Check out the Practically Cheating Statistics Handbook, which has hundreds more step-by-step solutions, just like this one!

## How to Find the Sample Variance: Example 2

Your paychecks for the last few weeks are: $600, $470, $430, $300 and $170. What is the standard deviation?

Step 1: Add up all of the numbers:

170 + 300 + 430 + 470 + 600 = 1970

Step 2: Square the total, and then divide by the number of items in the data set

1970 x 1970 = 3880900

3880900 / 5 = 776180

Step 3: Take your set of original numbers from step 1, and square them individually this time. Then add them all up:

(170 x 170) + (300 x 300) + (430 x 430) + (470 x 470) + (600 x 600) = 884700

Step 4: Subtract the amount in step 2 from the amount in step 3:

884700 – 776180 = 108520

Step 5: I subtracted 1 from the number of items in my data set:

5 – 1 = 4

Step 6: Divide the number in step 4 by the number in step 5:

108520 / 4 = 27130

This is my Variance!

Step 7: Take the square root of the number from step 6 (the Variance),

√(27130) = 164.7118696390761

This is my Standard Deviation!

Back to Top

## How to Find the Sample Variance: Example 3

This example uses the same formula, it’s just a slightly different way of working it.

You survey households in your area to find the average rent they are paying. Find the standard deviation from the following data:

$1550, $1700, $900, $850, $1000, $950.

Step 1: Find the mean:

($1550 + $1700 + $900 + $850 + $1000 + $950)/6 = $1158.33

Step 2: Subtract the mean from each value. This gives you the differences:

$1550 – $1158.33 = $391.67

$1700 – $1158.33 = $541.67

$900 – $1158.33 = -$258.33

$850 – $1158.33 = -$308.33

$1000 – $1158.33 = $158.33

$950 – $1158.33 = $208.33

Step 3: Square the differences you found in Step 3:

$391.67^{2} = 153405.3889

$541.67^{2} = 293406.3889

-$258.33^{2} = 66734.3889

-$308.33^{2} = 95067.3889

$158.33^{2} = 25068.3889

$208.33^{2} = 43401.3889

Step 4: Add up all of the squares you found in Step 3 and divide by 5 (which is 6 – 1):

(153405.3889 + 293406.3889 + 66734.3889 + 95067.3889 + 25068.3889 + 43401.3889) / 5 = 135416.66668

Step 5: Find the square root of the number you found in Step 4 (the variance):

√135416.66668 = 367.99

The standard deviation is 367.99.

## Find Variance Example 4

## How to Find Sample Variance: Steps

**Sample Question: **Find sample variance / standard deviation for the following data set: 1245, 1255, 1654, 1547, 1787, 1989, 1878, 2011, 2145, 2545, 2656.

Step 1: **Add up all of the numbers in your data set**:

1245 + 1255 + 1547 + 1654 + 1787 + 1878 + 1989 + 2011 + 2145 + 2545 + 2656 = 20712

Step 2: **Square the number you found in Step 1:**

20712 x 20712 = 428986944

…and then divide by the number of items on your data set.

428986944 / 11 = 38998813.09090909

Set this number aside for a moment.

Step 3: **Square all of the numbers in your data set and then add them together**.

(1245 x 1245) + (1255 x 1255) + (1547 x 1547) + (1654 x 1654) + (1787 x 1787) + (1878 x 1878) + (1989 x 1989) + (2011 x 2011) + (2145 x 2145) + (2545 x 2545) + (2656 x 2656) = 41106856

Step 4: **Subtract the number you calculated in Step 2 from the number you calculated in Step 3**:

41106856 – 38998813.09090909 = 2108042.9090909064

Step 5: **Subtract 1 from the number of items in your data set**:

11 – 1 = 10.

Step 6: **Divide the number you calculated in step 4 by the number you calculated in step 5**:

2108042.9090909064 / 10 = 210804.29090909063

This is the Variance.

Step 7: Take the square root of Step 6 to find the standard deviation:

√ 210804.29090909063 = 459.13.

*That’s it!*

## How to Find the Sample Variance in Excel 2007-2013

Contents:

## Sample Variance in Excel 2013

Watch the video or read the steps below:

## Sample Variance Excel 2013: Overview

Variance is a tool to tell you how much a data set varies. Its major use in stats is as a way to find the standard deviation, which is a more useful measure of spread and in fact is much more widely used than the sample variance. The equations for finding the sample variance are quite ugly. Technology is the best way to find it without the chance of math errors creeping in.

Excel gives you two options. If you haven’t already, be sure to load the Data analysis Toolpak (How to load the Data Analysis Toolpak). It’s a powerful tool that you’ll use over and over again in stats. If you don’t have the Toolpak (or don’t want to install it), your second option is to use the VAR function.

### Sample Variance Excel 2013: Data Analysis Toolpak

Step 1: Click the “Data” tab and then click “Data Analysis.”

Step 2: Click “Descriptive Statistics” and then click “OK.”

Step 3: Click the Input Range box and then type the location for your data. For example, if you typed your data into cells A1 to A10, type “A1:A10” into that box

Step 4: Click the radio button for Rows or Columns, depending on how your data is laid out.

Step 5: Click the “Labels in first row” box if your data has column headers.

Step 6: Click the “Descriptive Statistics” check box.

Step 7: Select a location for your output. For example, click the “New Worksheet” radio button.

Step 8: Click “OK.”

### Sample Variance Excel 2013: VAR Function

Step 1: Type your data into a single column.

Step 2: Click a blank cell.

Step 3: Type “=VAR(A1:A100)” where A1:A100 is the location of your data set (i.e. in cells A1 to A100). Press the “Enter” key to get the sample variance.

## Sample Variance in Excel 2010

Sample variance in Excel 2007-2010 is calculated using the “Var” function. Watch this one-minute video on how to calculate it, or read the steps below.

**Sample question:** Find the sample variance in Excel 2007-2010 for the following sample data: 123, 129, 233, 302, 442, 542, 545, 600, 694, 777

Step 1: **Type your data into a single column **in an Excel worksheet. For this example, I typed “123, 129, 233, 302, 442, 542, 545, 600, 694, 777” into column A. Don’t leave any blank cells between your data.

Step 2: **Click any empty cell**.

Step 3: **Click the “Insert function” button on the toolbar. **This opens the Insert Function dialog box.

Step 4: **Type “Var” into the Search for a Function text box **and then click “Go.” VAR should be highlighted in the function list.

Step 5: **Click “OK.”**

Step 6: **Type the location of the sample data into the Number1 text box**. This sample data was typed into cells A1 to A10, so I typed “A1:A10” into the text box. Make sure to separate the first and last cells by a colon (A1**:**A10).

Step 7: **Click “OK.”** Excel will return the sample variance in the cell you chose in Step 2. For this question, the variance of 123, 129, 233, 302, 442, 542, 545, 600, 694, 777 is 53800.46.

**Tip:** You can also access the VAR function from the “Formulas” tab in Excel. Click the “Formulas” tab and then click the “Insert Function” button on the far left of the toolbar. Continue from Step 4 above to calculate the variance.

**Tip:** You don’t *have* to type your sample data into a worksheet. Technically, you could open the VAR function dialog box and then type your data into the Number1, Number2 etc. boxes. However, the advantage of typing the data directly into the worksheet is that you can perform more functions on your data (like standard deviation) if you need to.

Check out our YouTube channel for more Excel help and tips!

I felt that this article was ok but it could have been just alittle bit thorough on this subject since we have done a good bit of problems regarding the sample ariance and the standard deviation in statistics. There were some good points just to let you know.

You put step 3 twice. It should be step 4 on the second “step 3”

You are completely right. Thanks!

So what’s the variance??

Kim,

See Step 6.

Regards,

Stephanie

I never though it could be so sample! I truly thank Professor Stephaine Deviant MAT. Thanks

Hello

I want to thank you for this sight. I am a online student and 57 years of age. I have never understood numbers and can never get the formula for most equalization math problems and solutions. I have never seen such clear and precise steps and I must say I am amazed.

Lisa Travis

Please how can I get the standard deviation of a sample population using the second method formula. What i got in the question I am dealing with did not agree with the corresponding standard deviation in the first formula. But in the case of entire population, both calculated values are the same.

Can you post your question? The one you’re dealing with? And how you worked out the solution. I’ll take a look.

Hi,

I am a little bit puzzled by your calculations here. If I’m correct, the formula for standard deviation asks for the sum of square values of (Xi – Y), with Y representing the mean:

∑(xi – Y)2/(N-1)

and this is what I believe you did in the Example 3.

But, if I understand correctly what you did in Examples 1 and 2, you simply subtracted the sums of squares one from another:

∑Xi2 – ∑Y2/(N-1),

which in no way corresponds to the previous formula.

What am I missing here? :)

Hi, Bran,

There are two variance formulas. One is called the computational formula. I added those formulas to the top of the examples, so I hope that will clarify things. Thank you for commenting.

Regards,

S