Calculate standard deviation
=STDEV.S(B2:B9)Excel · result on the sample sheet: 1.60
Describe what you need and get a working STDEV formula for Excel and Google Sheets, tested on real data before you copy it. STDEV measures how spread out a set of numbers is, treating them as a sample of a larger group.
Each formula below was calculated on its own sample sheet. Open one to see the sheet, why it works, and to try it yourself.
=STDEV.S(B2:B9)Excel · result on the sample sheet: 1.60
=STDEV.S(B2:B7)/AVERAGE(B2:B7)Excel · result on the sample sheet: 11.1%
=STDEV.S(FILTER(C2:C9,B2:B9=F1))Excel · result on the sample sheet: 3.17
You describe the task in plain English, and it writes the formula, using STDEV where that's the right tool, for your table or a sample one. The formula is run in our engine in Excel and Google Sheets mode before you see it, so you get its result, not just a guess.
STDEV measures how spread out a set of numbers is, treating them as a sample of a larger group.
Yes. Each example below opens a page where you try the formula in a live grid and it's checked as you go, and the STDEV function page has a practice exercise.