Menu
EXCEL DEVSQ FUNCTION
Excel DEVSQ Function Introduction
The DEVSQ function in Excel calculates the total of the squared deviations from the sample mean for a given collection of data.
Description of Excel DEVSQ Function
Syntax :
=DEVSQ(number1, [number2],…)
Parameters :
- where the number parameters are one or more numeric values (or arrays of numeric values) for which the sum of squared deviations is required.
- You can pass up to 255 number parameters to the function if you’re using a current version of Excel (Excel 2007 or later). However, the Devsq function in Excel 2003 can only receive up to 30 number inputs.
Step By Step Guide of DEVSQ Function
Example :
The spreadsheet on the right displays the Excel Devsq function, which was used to determine the sum of squared deviations of the data in cells A1 – A6. Cell B1 of the spreadsheet calculates the total of the squared variances. The formula for this is: =DEVSQ, as stated in the formula bar ( A1:A6 ) The total of squared deviations of the values in cells A1 – A6 is determined as 47.5, as shown in cell B1.
Key Points
- #NUM! – This error occurs when none of the values sent to the Devsq function are numeric.
(It should be noted that text representations of numbers provided as part of an array are not understood as numeric values by the Devsq function.) - #VALUE! – This error occurs if any of the number parameters passed straight to the Devsq function are text strings 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
