Statistics How To

How to Find the Sample Variance

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 (click for examples):

  1. Example 1: Variance.
  2. Example 1: Standard Deviation.
  3. Example 2 (both).
  4. Example 3 (both).
  5. Example 4 (both).
  6. 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

How to find the sample variance
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!

Back to top

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.672 = 153405.3889
$541.672 = 293406.3889
-$258.332 = 66734.3889
-$308.332 = 95067.3889
$158.332 = 25068.3889
$208.332 = 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.

Back to Top


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!

Back to Top


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

Sample Variance ExcelVariance 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.

Back to Top


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.
sample variance in excel 2007-2010

Step 2: Click any empty cell.

Step 3: Click the “Insert function” button on the toolbar. This opens the Insert Function dialog box.
variance in excel 2

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!

How to Find the Sample Variance was last modified: January 14th, 2016 by Stephanie

7 thoughts on “How to Find the Sample Variance

  1. Lisa Barcomb

    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.

  2. Lisa Travis

    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

Leave a Reply

Your email address will not be published. Required fields are marked *