How to Calculate Standard Deviation in Google Sheets

Which Google Sheets Function to Use

Google Sheets can calculate standard deviation directly from a range, so you usually do not need to compute the mean, deviations, and squared deviations manually. The main decision is whether your data represent a sample or a full population.

Use `STDEV(range)` for a sample and `STDEVP(range)` for a full population. If that distinction is still fuzzy, read Sample vs. Population and Standard Deviation Formula Explained first. If you want to compare the spreadsheet answer against the site tools, use the sample standard deviation calculator and population standard deviation calculator.

Goal	Google Sheets formula	When to use it
Sample standard deviation	`=STDEV(B2:B11)`	You measured only part of a larger group
Population standard deviation	`=STDEVP(B2:B11)`	You have every value in the group you care about
Mean for a manual check	`=AVERAGE(B2:B11)`	You want to audit the result step by step

Most real business datasets are samples

If you are working with a survey, a classroom subset, a lab sample, or a recent production run, `STDEV` is usually the safer default. Reserve `STDEVP` for cases where the sheet contains the entire population of interest.

Step-by-Step Workflow

A practical Google Sheets workflow is short, but each step matters. Most wrong answers come from using the wrong range or the wrong sample-versus-population formula, not from the arithmetic itself.

Put the numeric data in one column

Place the values in a clean range such as `B2:B11`. Keep headers outside the calculation range when possible.

Decide whether the range is a sample or a population

Use `STDEV` for sample data and `STDEVP` for population data. This is the spreadsheet version of the `n - 1` versus `N` choice.

Enter the formula

Type `=STDEV(B2:B11)` or `=STDEVP(B2:B11)` into an empty cell and press Enter.

Sanity-check the mean and count

Use `=AVERAGE(B2:B11)` and `=COUNT(B2:B11)` to verify you are measuring the data you think you are measuring.

Interpret the result in context

A standard deviation has meaning only relative to the unit and process. Use How to Interpret Standard Deviation if you need help turning the number into an explanation.

Worked Example with Sample Data

Suppose you collected a sample of 8 quiz scores in cells `B2:B9`: `72, 75, 81, 79, 68, 74, 77, 84`.

Google Sheets

=STDEV(B2:B9)
=AVERAGE(B2:B9)
=COUNT(B2:B9)

The mean is 76.25, the count is 8, and the sample standard deviation is about 5.25. That means scores typically fall about 5.25 points away from the average score.

Cell range	Formula	Result
`B2:B9`	`=AVERAGE(B2:B9)`	`76.25`
`B2:B9`	`=COUNT(B2:B9)`	`8`
`B2:B9`	`=STDEV(B2:B9)`	`5.25`

Practical interpretation

A standard deviation of 5.25 does not mean every score is exactly 5.25 points from the mean. It means the dataset has a typical spread of about five points. To standardize one student's score, continue with the z-score guide or use the z-score calculator.

Worked Example with Population Data

Now suppose the values in `C2:C7` are the complete daily defect counts for every shift in a small six-shift pilot: `2, 3, 2, 4, 1, 3`. Because the sheet contains the entire group of interest, use the population formula.

Google Sheets

=STDEVP(C2:C7)
=AVERAGE(C2:C7)

The mean is 2.5 and the population standard deviation is about 0.96. In plain language, defect counts usually vary by about one defect from the average shift.

If you later append more shifts and start treating the pilot as one sample from a longer-running process, you would switch to `STDEV`. That is why the statistical question matters more than the spreadsheet syntax.

Handling Blanks, Text, and Filters

Google Sheets functions are fast, but spreadsheet data are often messy. Before trusting the result, check whether your range contains headers, text labels, hidden rows, or accidental blanks.

What usually works fine

Blank cells are typically harmless, and text inside referenced cells is usually ignored by `STDEV` and `AVERAGE`. That makes a simple numeric column the easiest case.

What still causes mistakes

A wrong range, mixed units, filtered rows you expected to exclude, or using a summary table instead of raw observations can all make the answer misleading even when the formula itself is valid.

If you need to calculate standard deviation on a filtered subset only, create a helper range first and then apply `STDEV` to that cleaned subset. If your data are already summarized into counts, read Standard Deviation from a Frequency Table instead of applying a raw-range formula to grouped data.

Situation in the sheet	What to do	Why
Header accidentally included in the range	Change `B1:B11` to `B2:B11`	Keeps labels out of the calculation and makes `COUNT` easier to audit
Filtered rows should be excluded	Copy the visible values to a helper column before running `STDEV`	A standard range formula may still evaluate values you did not intend to report
Percentages and raw counts are mixed together	Standardize the unit before calculating	Standard deviation is only meaningful when every observation uses the same scale
Pivot table or grouped summary is the only data available	Switch to a grouped-data method instead of raw-range `STDEV`	Aggregated summaries answer a different variability question

Do not calculate standard deviation on averages unless that is your real variable

A common spreadsheet error is to compute standard deviation on monthly averages, department averages, or percentages that have already been aggregated. That answers a different question from the spread of the original observations.

Common Mistakes

Using `STDEVP` on a sample just because it looks more official.
Selecting the wrong range and including totals, labels, or a hidden scratch column.
Comparing standard deviations across variables with very different means without checking the coefficient of variation.
Expecting standard deviation to tell you whether an observation is unusual without also checking a z-score or outlier workflow.
Applying a raw-data formula to grouped tables, bins, or pivoted summaries.

Google Sheets Checklist

Checkpoint	Why it matters	Quick check
Raw values, not summaries	Standard deviation depends on the actual observation-level spread	Inspect the source column before entering the formula
Correct function	Sample and population formulas answer different questions	Use `STDEV` for samples and `STDEVP` for populations
Correct range	One extra total row can distort the result	Compare `COUNT(range)` with the expected number of observations
Interpretation plan	The number alone is not the decision	Pair the result with interpretation guidance or the descriptive statistics calculator

If you want a spreadsheet-specific shortcut, Google Sheets is excellent for the calculation step. If you want the conceptual foundation behind the answer, continue with What Is Standard Deviation?, Standard Deviation Formula Explained, and Calculate Standard Deviation in Excel & Python.

Sources

References and further authoritative reading used in preparing this article.

Google Docs Editors Help: STDEV — Google
Google Docs Editors Help: STDEVP — Google
Google Docs Editors Help: AVERAGE — Google

← शिक्षण केंद्र