Menu
EXCEL STDEVP FUNCTION
Excel STDEVP Function Introduction
The STDEVP function in Excel computes the standard deviation of a given collection of numbers.
Description of Excel STDEVP Function
Syntax :
=STDEVP( number1, [number2], … )
Parameters :
- The parameters, number1, [number2], and so forth, are one or more numeric values, arrays of values, or pointers to cells with values.
Step By Step Guide of STDEVP Function
Example :
The Stdevp function’s parameters are three cell ranges. You can, however, enter figures directly as individual integers or number arrays. For example, if the sales statistics for January and February 2010 are 13,000 and 14,500, respectively, you might enter these straight into the aforementioned code as follows: =STDEVP, or as separate numbers: =STDEVP, =STDEVP, =STDEVP, =ST ( B3:B14, D3:D14, F3:F14, 13000, 14500 ) Alternatively, as a number array: =STDEVP(B3:B14, D3:D14, F3:F14, 13000, 14500) This results in an adjusted standard deviation of 2,435.35.
Key Points
- #DIV/0! – Occurs when none of the values sent to the function are numeric. (It should be noted that text representations of numbers submitted as part of an array are not recognised as numeric values by the Stdevp function.)
- #VALUE! – Occurs if any values supplied directly to the Stdevp function are text values that cannot be read as numbers.
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
