-
GS Tutorial
- GS HOME
- GS Introduction
- GS Get Started
- GS Overview
- GS Syntax
- GS Ranges
- GS Fill
- GS Move Cells
- GS Add Cells
- GS Delete Cells
- GS Undo Redo
- GS Formulas
- GS Relative Reference
- GS Absolute Reference
- GS Arithmetic Operators
- GS Parentheses
- GS Functions
- GS Location Settings
- GS Formatting
- GS Format Painter
- GS Format Colors
- GS Format Fonts
- GS Format Borders
- GS Format Numbers
- GS Format Grids
- GS Format Clear
- GS Sort
- GS Sort Sheet
- GS Sort By Range
- GS Sort Range
- GS Conditional Formatting
- GS Single Color Formatting
- GS Color Scale Formatting
GS Functions
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
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:
=STDEV.S(value1, [value2, ...])
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:
E3=STDEV.S
B2:B21 for the Total stats for the sample Pokemon
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 113,2319464.
function copyFormulas(elementId){ /* Get the text field */ var copyText = document.getElementById(elementId); /* Select the text field */ copyText.select(); copyText.setSelectionRange(0, 99999); /* For mobile devices */ /* Copy the text inside the text field */ navigator.clipboard.writeText(copyText.value) .then(() => { alert('Range copied to clipboard.\nIt can now be pasted into the Google Sheets spreadsheet.') }) .catch((error) => { alert(`Copy failed! ${error}`) }) }