Google Sheets STDEV.S Function
The STDEV.S function is a premade function in Google Sheets, which calculates the Standard Deviation (Stdev) for a sample of a population.
It is typed
=STDEV.S and gets a list of cells:
You can select cells one by one, but also ranges, or even multiple ranges.
The STDEV.S function ignores cells that do not contain numbers.
Note: Standard deviation (σ) measures how far a 'typical' observation is from the average of the data (μ). You can read more about standard deviation in the Statistics - Standard Deviation Chapter.
Tip: There is another function called
=STDEV.P that can be used if you have the data for the entire population.
Let's have a look at an example!
STDEV.S Function Example
Find the standard deviation of the total stats for the Pokemon in this sample:
The STDEV.S function, step by step:
- Select the cell
- Click the STDEV.S command
- Specify the range
B2:B21for the Total stats for the sample Pokemon
- Hit enter
Now, the function returns the standard deviation of all the Total stat values:
The STDEV.S function has successfully returned the Standard Deviation for the sample as