Standard deviation is a measure of how close the numbers are to the mean. It is calculated as the square root of the variance and denoted by σ (the Greek letter sigma).
Formula to calculate standard deviation in google sheets.
Just like in excel, we will use the standard deviation function ( STDEV ) and the arguments to calculate standard deviation.
Example:
Calculate the standard deviation of the following set of data using google sheets.
Name | Age |
Chris | 33 |
Rose | 24 |
Ann | 26 |
Ben | 5 |
Joe | 72 |
- We begin by rewriting our data on the spreadsheet.

- Choose where you want your answer to appear.
- Click on insert.
- Choose the STDEV function.
- Choose the arguments and then click enter to get your answer.

Therefore, the standard deviation is 22.04540769.