The following article introduces you to the STDEVPA function - one of the functions in the statistical group is very popular in Excel.
Description: The standard deviation estimation function is based on the whole population, including both text and logical values. Standard deviation is a measure of the dispersion of a value against the mean.
Syntax: STDEVPA (value1, [value2], .)
Inside:
- value1, [value2], .: are the values you want to calculate the standard deviation, where value1 is the required parameter, the remaining parameters are optional and contain up to 254 value parameters .
Attention:
- The STDEV.S function assumes that its arguments are the entire population.
- For large sample sizes -> the functions STDEVA and STDEVPA return the same results.
- Standard deviation calculated using the method 'n'.
- Arguments can be numbers, names or arrays that contain numbers.
- The logical value with True is 1 default, false value is 0 default.
- If the argument is an array or a reference, only values in that array are used.
- When the number is represented by a text style when typing directly into the argument list -> that value is still counted.
- Function error occurs when arguments are text or error values cannot be converted.
- If you do not want to calculate both logical values and text -> use the STDEVP function
- STDEVPA equation uses the formula:
[sqrt {frac {{sum {{{left ({x - overline x} right)} ^ 2}}}} {n}}]
Inside:
+ x is the sample mean AVERAGE (number1, number2, .)
+ n is the sample size.
For example:
Calculate the standard deviation based on the overall population of values in the following data table:
- In the cell to calculate enter the formula : = STDEVPA (D6: D12)
- Press Enter -> standard deviation based on the whole of the above values is:
Above are instructions and some specific examples when using the STDEVPA function in Excel.
Good luck!