In this article
STDEVPA is the population version of STDEVA.
Advertisement
Syntax
=STDEVPA(value1, [value2], ...)| Argument | What it means |
|---|---|
value1… |
Values |
Examples
Example 1
=ROUND(STDEVPA(A2:C2),3)Result: 35.59. See the worked example table below for more cases.
STDEVPA in practice
Where you will use it
- Complete data with text entries
- Logical data
- Mixed columns
Worked example
| Value 1 | Value 2 | Value 3 | Formula | Result |
|---|---|---|---|---|
| 80 | Absent | 70 | =ROUND(STDEVPA(A2:C2),3) | 35.59 |
| 80 | 70 | TRUE | =ROUND(STDEVPA(A3:C3),3) | 35.122 |
| 80 | 70 | 90 | =ROUND(STDEVPA(A4:C4),3) | 8.165 |
Results calculated in Excel. Text counts as 0 and TRUE as 1; compare with the all-numbers row.
Mistakes people make
| Mistake | What to do instead |
|---|---|
| Text counts as 0 | Clean data first if that's wrong |
| Sample data | Use STDEVA |
Related functions
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong