fx =STDEV(A1:A100)ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

STDEV Formula for Statistical

Calculate standard deviation. Copy-paste ready for Excel, Google Sheets, and Airtable.

=STDEV(A1:A100)
When you need this: When you measure quality control data (defects A1:A100) and need to understand variation — is quality consistent?

How it works

  1. 1Calculate distance of each value from the average.
  2. 2Square all distances, find their average (variance).
  3. 3Take the square root (standard deviation) — shows variability.
  4. 4Higher STDEV = more scattered data, lower STDEV = more consistent.

Variations

Sample standard deviation
=STDEV.S(A1:A100)
Population standard deviation
=STDEV.P(A1:A100)

Related Formulas

AVERAGE — Calculate the average of a rangeStatisticalCOUNTIF — Count cells that meet a conditionStatisticalCOUNTIFS — Count cells meeting multiple conditionsStatisticalMAX / MIN — Find the largest or smallest value in a rangeStatistical

Need a formula that's not here?

Generate custom formula →