說明
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.
語法
STDEVPA(value_1, […, value_254])
Inputs
This function accepts the following arguments:
| 名稱 | 必要 | 說明 | Valid input |
|---|---|---|---|
value_1 |
是 | 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 |
沒有 | 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. |
範例
範例資料
| A |
|---|
| 值 |
| 10 |
| 20 |
| 30 |
| 40 |
| 50 |
| TRUE |
| FALSE |
| "Text" |
Sample formulas
| 公式 | 說明 | 結果 |
|---|---|---|
=STDEVPA(A2:A9) |
Calculates the standard deviation for the entire population of values in the range A2:A9. | 17.7482393 |
=STDEVPA(10, 20, 30, 40, 50, TRUE, FALSE, "Text") |
Calculates the standard deviation for the provided values including text and logical values. | 17.7482393 |
附註
- 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.
提示
- 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.
Related functions
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
LARGE
MAX
MAXA
MAXIFS
MEDIAN
MIN
MINA
MINIFS
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
QUARTILE
QUARTILE.EXC
QUARTILE.INC
RANK
RANK.AVG
RANK.EQ
SMALL
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVPA