How to Use the STDEV Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Intermediate · 5 min read · includes 2 free exercises

In short: STDEV returns the sample standard deviation of the values you give it. The formula is =STDEV(value1, [value2, ...]). For an entire population use STDEVP.

What STDEV does

The average tells you where the middle is. Standard deviation tells you how far values typically stray from it. Two classes can both average 70, but if one has scores clustered tightly and the other has scores all over the place, STDEV shows the difference.

STDEV syntax

=STDEV(value1, [value2, ...])

Per Google's help page, value1 is the first value or range of the sample, and further values or ranges are optional. Several rules apply:

A step-by-step example

Here are five scores in cells A1:A6.

A
1Score
210
320
430
540
650
=STDEV(A2:A6)

This returns the sample standard deviation of the five scores. If the five scores are the whole group you care about, rather than a sample drawn from a bigger group, use the population version instead:

=STDEVP(A2:A6)

The population result is a little smaller, because it divides differently than the sample version.

Common mistakes

Try it yourself

Use the scores above (A2:A6). Type your formula into the box, starting with =, then press Check.

Exercise 1: Sample deviation

Write a formula that returns the sample standard deviation of A2:A6.

Hint: pass the range.

Exercise 2: Whole population

Write a formula that returns the population standard deviation of A2:A6.

Hint: the function name ends with P.

What to learn next

Syntax and rules in this guide were checked against Google's STDEV help page. See all guides.