Standard Error in Google Sheets
Use the Google Sheets formula for standard error and check a sample through the canonical column-stats logic.
At a glance
- Answer
- =STDEV(range)/SQRT(COUNT(range)) gives the standard error of the mean.
- Because
- STDEV returns the sample standard deviation, and COUNT counts only numeric cells.
- Common error
- Using COUNTA, which counts text and zero-length strings and can inflate n.
- Not for
- The standard error of a proportion, a slope, or a difference. Confidence Interval Calculator
Google Sheets standard error
STDEV / SQRT(COUNT)
Formula ready for Google Sheets.
| Metric | Value |
|---|
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))
Sources
- Google Docs Editors Help, STDEV. Google. Retrieved .
- Google Docs Editors Help, SQRT. Google. Retrieved .
- Google Docs Editors Help, COUNT. Google. Retrieved .
- Google Docs Editors Help, COUNTA. Google. Retrieved .
- NIST Engineering Statistics Handbook, Measures of Scale. NIST. Retrieved .
Method last reviewed