Skip to content
Back to template gallery
Google Sheets
Google Sheets

How to find standard deviation in Google Sheets

Measure how spread out your numbers are with the STDEV function.

Operations
2 steps 1 min Community template
1

Click an empty cell

Click the cell where the result should go. Type =STDEV( then the range of numbers and a closing bracket - here, =STDEV(B2:B6). Use STDEVP for a whole population. Press Enter to confirm.

docs.google.com/spreadsheets/
Click an empty cell
2

Standard deviation calculated

The cell shows how far the scores typically sit from their average.

docs.google.com/spreadsheets/
Standard deviation calculated

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.