STDEV.S
Excel STDEV.S Function
An Excel prepared function called STDEV.S determines the Standard Deviation (Std) for a given sample.
The type is =STDEV.S.
Note: Cells containing logic and text are ignored by this function.
Note: The standard deviation (σ) expresses the distance between a “typical” observation and the data average (μ). Visit our Statistics – Standard Deviation Tutorial to learn more about standard deviation.
Advice: If you have the population’s data, you can utilize an additional function named STDEV.P.
How to use the =STDEV.S function:
- Select a cell (H5)
- Type =STDEV.S
- Double click the STDEV.S command
- Select a range (E2:E21)
- Hit enter
Let’s have a look at an example!
Find the Standard Deviation for the sample of Pokemon total stats in the range E2:E21:
That is the method! The Standard Deviation for the sample of Pokemon Total stats, which is 113,2319, has been correctly returned using the STDEV.S function.
