where 
is the mean of the 
`s.
Description Computes the square of the deviation of the numbers.
Syntax DEVSQ(number_list)
| Argument | Description |
|---|---|
| number_list | A list of up to 30 numbers separated by commas. The list may contain numeric values, cell references, range references, or array constants.Text and logical values in cell references and arrays are ignored. Text entered in the argument list will be evaluated as a number, if possible; otherwise it will cause a #VALUE! error. Logical values entered into the argument list are evaluated as numeric 1 if TRUE and numeric 0 if FALSE. |
Equation
where
is the mean of the
`s.
Examples This function returns 0.5:
See Also AVEDEV, AVERAGE, COUNT, SKEW, KURT
