The following article details how to use the STDEVP function in Excel, which helps you calculate standard deviations based on patterns.
Description: Unlike the STDEV function, the STDEVP function helps you calculate the standard deviation or measure the dispersion of values against the average value.
Syntax: STDEVP (number1, [number2] .) .
Inside:
- number1: The first argument value corresponding to the whole, is a required parameter.
- number2: The argument value from 2 to 255 corresponding to the whole, is an optional parameter. Values can be individual values (separated by commas) or values are single or reference arrays.
Attention:
- The formula for calculating the function STDEVP :
Where: X is the average value of the AVERAGE function (number1, number2, .) and n is the sample size.
- If the data represent a sample of the population, then calculate the standard deviation using the STDEV function .
- STDEV and STDEVP return nearly equal values in case of large size samples.
- The standard deviation is calculated based on the "n" method .
- Value parameters can be numbers or names, arrays, or references that contain numeric values.
- The function counts arguments in the case of logical values and presents the number of textual forms directly typed into the list.
- If the parameter is an array or reference -> only numeric values in the array are counted, in addition, blank values, logical values, text . are ignored.
- The function will give an error in case the parameters are text or logical values cannot be converted to numeric types.
- In case you want logical values, text . are allowed to calculate -> use STDEVPA function .
For example:
Calculate the standard deviation for durability of 3 products based on the following data table:
In the cell to be calculated enter the following formula: = STDEVP (C8: E8) .
Press Enter the standard deviation value between 3 products is:
Make a copy of the formula for the remaining data cells -> The result is:
With the above 3 products, if the durability of the 3 products is nearly the same -> the standard deviation value is usually less than 1. In case of 3 products with the same durability -> the value of STDEVP function = 0. Where the endurance of 3 products is nearly the same, the STDEV function has a value of 1, and the more accurate STDEVP function usually gets closer to 1.
The above is the usage and necessary notes when using the STDEVP function. Hope to help you solve the problem effectively and quickly. Good luck!