Eigenstate Labs
Eigenstate Labs
Search instruments

Standard Error in Google Sheets

Use the Google Sheets formula for standard error and check a sample through the canonical column-stats logic.

One numeric value per line. Leave blank if you only need the spreadsheet formula.

Google Sheets standard error

STDEV / SQRT(COUNT)

Formula ready for Google Sheets.

Optional example
MetricValue
Export

standard error = STDEV(range) / SQRT(COUNT(range)) How?

How this is calculated

Google Sheets `STDEV` returns sample standard deviation and `COUNT` counts numeric cells. This page computes the optional example by calling the canonical CSV/JSON column-stats logic, then divides sample SD by the square root of the numeric count.

Formula: standard error = STDEV(range) / SQRT(COUNT(range))

See Sources below

Sources

  1. Google Docs Editors Help, STDEV. Google. Retrieved .
  2. Google Docs Editors Help, SQRT. Google. Retrieved .
  3. Google Docs Editors Help, COUNT. Google. Retrieved .
  4. NIST Engineering Statistics Handbook, Measures of Scale. NIST. Retrieved .

Method last reviewed

How we choose and check our formulas