# How to Calculate Standard Deviation in Google Sheets

Standard deviation is a statistical measure of how dispersed the data is in relation to the mean. Google Sheets comes with a built-in function to calculate the standard deviation. This article will show how to calculate standard deviation in Google Sheets.

## Calculating Standard Deviation using the STDEV function

#### Syntax

``STDEV(value1, [value2, ...])``

#### Arguments

• value1 is the first value or range of the sample.
• value2, … is the additional values or ranges of the sample.

#### Steps

1. In any cell, type =STDEV()

2. Between the parenthesis, enter the range of data. In my case, I’m selecting the range B3:B7.

3. Press Enter. This is the standard deviation of the given data.

Phoebe is an HR assistant in her day job, but is also a web blogger that loves writing guides and sharing her experiences. When she is not out with her friends, she enjoys traveling or binge-watching Netflix. She graduated with a BA in Communication and Media Studies from the University of Utah, and is a chief editor at TechObservatory.