Standard deviation sounds scary. It’s really not. It just tells you how spread out your numbers are from the average. And Excel does all the hard math for you. Here’s how to get it done in under two minutes.
First Which Formula Do You Actually Need?
This is where most people get confused. Excel gives you six options. Nah, you don’t need all of them. In most cases, you only care about two:
- =STDEV.S( ) → Use this for a sample (a chunk of your data)
- =STDEV.P( ) → Use this for the entire population (every single data point)
Quick tip if you pulled data from a survey or a month of sales records, that’s a sample. Use STDEV.S. That’s the one 90% of people need.
Step-by-Step: How to Do It
Let’s say you have daily sales numbers in cells B2 to B31. Here’s all you do:
- Click on an empty cell
- Type: =STDEV.S(B2:B31)
- Hit Enter
Done. Excel spits out the standard deviation instantly.
That’s it. No formulas to build by hand. No manual math. Excel handles everything.
A Real Example (So It Clicks)
My friend Neha runs a small clothing store. She tracked her daily sales for 30 days average was ₹8,500 per day. She ran STDEV.S and got ₹1,200.
What does that mean? Most days, her sales fell somewhere between ₹7,300 and ₹9,700. Some days were quiet, some were busy but nothing too wild.
That single number told her her business was pretty stable. Felt like a relief, honestly.
Which Formula for Which Situation Quick Cheat Sheet
- STDEV.S → Sample data, numbers only (most common)
- STDEV.P → Full population, numbers only
- STDEVA → Sample data, includes text and TRUE/FALSE values
- STDEVPA → Full population, includes text and TRUE/FALSE values
- STDEV → Older Excel versions (2007 or earlier), same as STDEV.S
Stick to STDEV.S unless you have a specific reason not to. That’s the real win.
FAQ’s
Q: What’s the difference between STDEV.S and STDEV.P?
STDEV.S is for a sample a portion of your data. STDEV.P is for the full dataset. Most everyday use cases call for STDEV.S.
Q: Can I use standard deviation on text or logical values?
Yeah, but you’d need STDEVA or STDEVPA for that. Regular STDEV.S skips text and TRUE/FALSE cells entirely.
Q: My standard deviation result looks really high is that bad?
Not necessarily. A high number just means your data is spread out. Low means it’s clustered close to the average. Neither is “wrong” it just describes your data.