Buzz
In statistical probability, determining the corresponding deviations between samples is meticulous and detailed, yet some confusion may still arise. This article provides detailed guidance on the STDEV function, helping you estimate the standard deviation based on the given sample.
Description: The function helps estimate the standard deviation based on the sample, where the standard deviation is the measure of the spread of values around the mean.
Syntax: STDEV(number1,[number2],...).
In which:
- number1: The first parameter in numeric form corresponding to the values in the population sample, which is a mandatory parameter.
- number2...: The second parameter in numeric form corresponding to the population sample, which is an optional parameter. The number of parameters ranges from 2 to 255. Note that if you use separate parameters, you use commas to separate the values of number.
--- -> You can replace individual values with a single array or reference to an array.
Note:
- The calculation formula for the STDEV function:
In which:
+ x: represents the sample mean AVERAGE(number1, number2, ...).
+ n: denotes the sample size.
- In case the data represents the entire population => use the STDEVP function to calculate the standard deviation.
- The standard deviation calculation is based on the method: 'n-1'.
- The parameter values can be numbers or names, arrays, or references containing numerical values.
- The function counts arguments in cases of logical values and presents text-formatted numbers entered directly into the list.
- If the parameter is an array or reference -> only numerical values in the array are calculated, while blank values, logical values, text, etc., are ignored.
- The function will generate an error if the parameters are text or logical values that cannot be converted to numbers.
- If you want logical values, text, etc., to be included in calculations -> use the STDEVA function.
Example:
Calculate the standard deviation of the following 3 product samples:
In the cell where you want to calculate, enter the formula: =STDEV(C8:E8) to compare the durability of 3 products corresponding to the values for the 1st trial.
Press Enter to receive the standard deviation result for the durability of the 3 products:
Copy the formula for the remaining values to get the result:
Estimating a standard deviation of 1 indicates negligible deviation between the values -> the durability of the 3 products is equal.
Above is the usage and necessary notes when using the STDEV function. Hope it helps you solve the problem efficiently and quickly.
Wishing you success!
