# How to Calculate Standard Deviations in Excel Visual Basic

Written by contributing writer
• Share
• Tweet
• Share
• Pin
• Email

Excel is the spreadsheet program included in the Microsoft Office Suite of productivity software. A spreadsheet program manages data through a series of tables. Each data value is placed within an individual cell within the table. Values can be manipulated through a set of built-in functions. Standard deviation is average deviation from the mean of the values of a set. Simply put, it identifies the precision of a set of values. Standard deviation can be calculated using the built-in function STDEV in Excel, or Visual Basic for Applications (VBA).

Skill level:
Easy

• Data set

## Instructions

1. 1

Open Excel and the data set where you want to find the standard deviation.

2. 2

Type"=STDEV(" in the cell where you want to display the standard deviation. Do not press "Enter."

3. 3

Holding down shift, select the range of cells containing the data points. If the cells are not continuous, hold down Ctrl while selecting the non-continuous cells. This should place a series of cells names in the formula bar after "=STDEV(".

4. 4

Type ")" in the formula bar and press "Enter." The standard deviation will be calculated using the unbiased method.

1. 1

This same built-in function can be used in a VBA script to calculate standard deviation. Open VBA and click on the end of the module where you are going to calculate the standard deviation.

2. 2

Type "Function StDev( Rng As Range)" and then press "Enter." This should also create a new line "End Function."

3. 3

On the line between "Function ..." and "End Function," type "StDev = Application.WorksheetFunction.StDev( Rng)" and then press "Enter."

4. 4

To calculate the standard deviation in VBA, simply use the function StDev().

#### Tips and warnings

• This same method can be used to access any of the built-in functions of Excel within VBA.

### Don't Miss

#### References

• All types
• Articles
• Slideshows
• Videos
##### Sort:
• Most relevant
• Most popular
• Most recent