Find Number of Data Points within 1, 2 or 3 St Deviations in Excel

Learn how to use formulas in Excel to find out how many of the data points fall within 1, 2, or 3 standard deviations of the mean.
For more help, visit my website: mathandstatshel...

[@ashr4922]

You are a lifesaver!

[@rengawds2]

Good instructions...one thing to note is when you are wanting to a cell by including "$", for another shortcut you can use the F4 key to lock the referenced cell in. Try it...1st time keying F4 locks the whole cell reference (e.g. $C$4), 2nd time locks only the row reference (e.g. C$4), 3rd time locks only the column reference (e.g. $C4) and 4th time unlocks the cell reference (e.g. C4).

[@MathandStatsHelp]

Thank you for the tip

[@syedammarhasan9611]

This is very helpful. Thanks.

[@MathandStatsHelp]

Glad to hear it helped!

[@twafsu9]

This is helpful. How would I determine the frequency below a certain number? For example, what is I only wanted to know how many instances were below 9,800?

[@alvydasjokubauskas2587]

Press f4 on selected range, to add dolar signs, you don't need to manually add dollar signs

[@MathandStatsHelp]

Thanks for the tip!

[@raqiibnoor2452]

Is the frequency the same thing as the number of data points

[@MathandStatsHelp]

Yes, it's how many of the values that fall between the lower and upper limits.

[@shreyaSingh-ci4yd]

Thanku so much

[@alvydasjokubauskas2587]

Also instead of "=" sign to start formula by typing "+", closer to numpad and it's a big button, hard to missclick

[@YouCallThataKnife253]

Anyone know h ow to do this in SPSS?

[@user-zo3qu6ze4t]

i want to do it on spss, did you find a way?