Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Functions / DEVSQ
In This Topic
    DEVSQ
    In This Topic

    Summary

    This function calculates the sum of the squares of deviations of data points (or of an array of data points) from their sample mean.

    Syntax

    DEVSQ(value1,value2, ...)

    DEVSQ(array)

    DEVSQ(array1,array2,...)

    Arguments

    Each argument can be a double-precision floating-point value, an integer value, or an array (cell range) of these. Up to 255 arguments may be included. You can use a single array (cell range) instead of a list of values. You can use multiple arrays (cell ranges) as well.

    Remarks

    This is a measure of the variability in a data set.

    The sum of squared deviations is calculated as follows, where n is the number of values.

    DEVSQ Equation

    If an array or cell reference argument contains text, logical values, or empty cells, the function ignores those values; however, the function includes in calculations cells with the value zero.

    Data Types

    Accepts numeric data for all arguments or array of numeric data. Returns numeric data.

    Examples

    DEVSQ(B3,B5,B9,B10)

    DEVSQ(B3:B14)

    DEVSQ(R3C2,R5C2,R9C2)

    DEVSQ(R3C2:R3C12)

    DEVSQ(35,31,47,51,37,31,58,39) gives the result 680.875

    See Also