說明
Use this function to calculate the standard deviation of a sample, including numbers, text, and logical values. Supported in Chains. Can be used with CHILDREFS.
語法
STDEVA(value_1, […, value_254])
Inputs
This function accepts the following arguments:
| 名稱 | 必要 | 說明 | Valid input |
|---|---|---|---|
value_1 |
是 | The first value or range in the sample. | 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. |
value_n |
沒有 | Additional 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 | B |
|---|---|
| 值 | 類型 |
| 10 | 數量 |
| 20 | 數量 |
| TRUE | Logical |
| 範例 | 文字 |
| 30 | 數量 |
Sample formulas
| 公式 | 說明 | 結果 |
|---|---|---|
=STDEVA(A2:A6) |
Calculates the standard deviation of all values, including text and logical values | 12.81 |
=STDEVA(10, 20, TRUE, "Sample", 30) |
Calculates the standard deviation using direct input of values | 12.81 |
=STDEVA(A2:A3, A5:A6) |
Calculates the standard deviation of numeric values only | 10 |
附註
- STDEVA treats TRUE as 1, FALSE as 0, and text as 0.
- STDEVA uses the formula:
√[Σ(x - x̄)² / (n-1)], where x is the sample mean and n is the sample size. - STDEVA assumes that its arguments are a sample of the population. If your data represents the entire population, use STDEVPA instead.
- If the sample contains no numeric data, STDEVA returns the #DIV/0! error.
- Cells that contain empty text ("") are ignored.
提示
- Use STDEVA when you want to include text and logical values in your standard deviation calculation.
- STDEVA is particularly useful in datasets where text or logical values represent numeric information.
- For datasets with only numeric values, consider using STDEV.S instead.
- You can combine STDEVA with other statistical functions such as AVERAGEA for comprehensive data analysis.
- Be careful when interpreting results: STDEVA's inclusion of text and logical values may lead to different outcomes compared to strictly numeric standard deviation calculations.
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