STDEV Function Generator
STDEV calculates the standard deviation of a data set — how spread out values are from the mean. Use STDEV.S for samples (default in statistics), STDEV.P for entire populations.
Syntax
=STDEV.S(range) or =STDEV.P(range)Try it — generate a STDEV formula
Examples
Sample standard deviation
=STDEV.S(A2:A100)Standard statistics default — uses n-1 denominator.
Outlier flag
=ABS(A2-AVERAGE(A:A))>2*STDEV.S(A:A)More than 2 SDs from mean = potential outlier.
Coefficient of variation
=STDEV.S(A:A)/AVERAGE(A:A)Relative variability — unitless.
Tips
- ✓STDEV.S vs STDEV.P: S for a sample, P for entire population.
- ✓Ignores text and logical values in the range.
- ✓Combined with AVERAGE + 2*STDEV is a quick outlier detector.
Related Formulas
MEDIAN
MEDIAN returns the middle value when a range is sorted. More robust than AVERAGE...
PERCENTILE
PERCENTILE returns the Kth percentile of a data range. Common in performance (p9...
RANK
RANK returns the position of a value within a range when sorted. Use RANK.EQ for...
Need a different formula?
Describe any formula in plain English and FormulaPad will generate it.
Try FormulaPad Free