Estimates standard deviation based on a sample.
Cú pháp
STDEV(number1, [number2], …)Đối số
number1bắt buộc
The first number or range of cells corresponding to a sample of a population.
number2tùy chọn
Additional numbers or ranges, up to a maximum of 255 arguments.
The STDEV function calculates the standard deviation of a dataset, assuming the data represents a sample of the entire population. It measures how widely values are dispersed from the average (mean) value. Note that this function is provided for compatibility with older versions of Excel; for newer versions, STDEV.S is recommended.
=STDEV(10, 12, 23, 23, 16, 23, 21, 16)→4.898979Calculates the sample standard deviation for the provided list of numbers.
Select a cell
Click on the cell where you want to display the standard deviation result.
Enter the formula
Type =STDEV( and select the range of cells containing your sample data, then close the parenthesis.
Press Enter
Press Enter to calculate the standard deviation of the selected sample.
STDEV calculates standard deviation based on a sample, while STDEVP calculates it based on the entire population.
STDEV.S is the modern, more descriptive replacement for STDEV, providing better clarity in newer versions of Excel.