Standard deviation range in Excel

For example, I have test scores of 50 students drawn from a population of 2000 students that took an exam. I want to get an estimate of Standard Deviation.

To do it in Excel, here is the answer:

a) Enter formula =STDEV.S(W3:AA12) where W3:AA12 corresponds to the range with Test Scores.

In case the 50 Test scores represent the entire population, Standard Deviation for the population can be calculated by substituting STDEV.S with STDEV.P.

excel standard deviation range


You can find similar Excel Questions and Answer hereunder

1) Here some more advanced range objects and what you can do with the range object in VBA

2) How can I clear all formats (formats alone not data) from a range of cells?

3) Sumifs with date range as criteria in Excel

4) How can I find the slab in which a given value fits?

5) How do I get the 2nd highest number in a range of numbers?

6) How can I find the count of records that meet multiple conditions in my raw data table?

7) Is there a way I can average a range of numbers even if there is an error value in range?

8) How can I fill a range of cells with incremental times?

9) How can I quickly remove all blank cells in a data range?

10) How can I set FreezePanes in a certain range using VBA?


Here the previous and next chapter