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
- In any cell, type =STDEV()
Enter =STDEV() in any cell. - Between the parenthesis, enter the range of data. In my case, I’m selecting the range B3:B7.
Enter the arguments. - Press Enter. This is the standard deviation of the given data.
Calculated Standard Deviation using STDEV function.