Руководство Excel

How to Calculate Standard Deviation in Excel

Standard deviation measures how spread out numbers are from their average. Use STDEV.S for sample data and STDEV.P for entire population data.

Пошагово

1
Prepare your data
Enter your numerical data set into a single column or row in your worksheet.
2
Select a cell for the result
Click on the empty cell where you want the standard deviation value to appear.
3
Enter the function
Type '=STDEV.S(range)' for a sample or '=STDEV.P(range)' for a population, replacing 'range' with your data cells, then press Enter.

=STDEV.S(A1:A10) or =STDEV.P(A1:A10)

Use STDEV.S if your data is just a subset of a larger group; use STDEV.P if you have data for every member of the group.

What is the difference between STDEV.S and STDEV.P?

STDEV.S calculates standard deviation based on a sample, while STDEV.P calculates it based on the entire population.