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.
