Description
Use this function to calculate the standard deviation based on the entire population, including text and logical values. Supported in Chains. Can be used with CHILDREFS.
STDEVPA is useful when you need to include logical and text values in your calculation.
Syntax
STDEVPA(value_1, […, value_254])
Inputs
This function accepts the following arguments:
| Name | Required | Description | Valid input |
|---|---|---|---|
value_1 |
Yes | The first value or range of the population. | A number, text, logical value, a reference to a cell containing any of these, or a cell range that includes them. |
value_n |
No | Additional sample population values. | A number, text, or logical value, a reference to a cell containing any of these, a cell range that includes any of these, or a formula which results in any of these. Up to 254 additional values can be considered. |
Example
Sample data
A |
||
|---|---|---|
| 1 | Values |
|
| 2 | 10 |
|
| 3 | 20 |
|
| 4 | 30 |
|
| 5 | 40 |
|
| 6 | 50 |
|
| 7 | TRUE |
|
| 8 | FALSE |
|
| 9 | "Text" |
Sample formulas
| Use case | Formula | Explanation and Result |
|---|---|---|
| Calculate the population standard deviation of a range that includes logical and text values. | =STDEVPA(A2:A9) |
Treats TRUE as 1, FALSE as 0, and "Text" as 0, then calculates the standard deviation across the entire population of 8 values. Result: ≈18.2032793 |
| Calculate the population standard deviation of values typed directly into the formula, including logical and text values. | =STDEVPA(10, 20, 30, 40, 50, TRUE, FALSE, "Text") |
Same calculation as above, but with the values entered literally instead of pulled from a range. Result: ≈18.2032793 |
Notes
- STDEVPA evaluates both text values and FALSE as 0, and TRUE as 1.
- Use STDEV.P if you want to calculate the standard deviation excluding text and logical values.
- The function treats text and logical values differently from purely numerical functions.
Tips
- Use STDEVPA to analyze data sets that include logical and text values to get a comprehensive understanding of variability.
- You can combine STDEVPA with other statistical functions such as AVERAGE for detailed data analysis.
- Make sure that you understand the implications of including text and logical values in your calculations when using STDEVPA, as they may distort your results.