Menu
EXCEL STDEVPA FUNCTION
Excel STDEVPA Function Introduction
The STDEVPA function in Excel computes the standard deviation of a given collection of numbers.
Description of Excel STDEVPA Function
Syntax :
=STDEVPA (number1, [number2], …)
Parameters :
- One or more numerical values, arrays of values, or pointers to cells holding numbers are used as number parameters.
Step By Step Guide of STDEVPA Function
Example :
In the spreadsheet above, the function in cell B2 includes the values in cells A4 and A6. In this case: The logical value TRUE in cell A5 is treated as the value 1; The text in cell A6 is treated as the value 0.
This is shown by the example in cell B3, in which cells A1 – A4 and the values 1 and 0 give the same result as the standard deviation calculation for cells A1 – A6.
Key Points
- Use STDEVPA only when evaluating logicals or text in the standard deviation computation.
- STDEVPA use the “n” technique to compute standard deviation.
- STDEVA considers data to be a whole population. When representing data as a sample, use STDEVA or STDEV.S.
- As arguments, numbers are provided. They can be provided as real numbers, ranges, arrays, or references containing numbers.
- STDEVPA will assess logical values and/or integers in references provided. STDEVP or STDEV.P can be used to disregard these values.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
