Functions
STDEV
Sample standard deviation
Try it
When to use it
When should I use STDEV instead of STDEVP?
Use STDEV when your data is a sample of a larger population; it divides by n minus 1 to correct for sampling. Use STDEVP when your data covers the entire population.
What does the standard deviation tell me?
It measures how spread out the values are around the average. A small STDEV means values cluster near the mean; a large one means they vary widely, which signals more risk or inconsistency.
Use cases
Variability of monthly returns
Consistency of process measurements
Used in
finance · science · operations
Syntax
STDEV(value1,...)Examples
=STDEV(1,2,3,4,5,6,7,8,9,10) // => 3.0276503540974917
=STDEV({1,2,3,4,5,6,7,8,9,10}) // => 3.0276503540974917