Tuesday, March 7, 2017

DEVSQ function

DEVSQ function

Returns the sum of squares of deviations of data points from their sample mean.

Syntax

DEVSQ(number1,number2,...)

Number1,number2, ...     are 1 to 30 arguments for which you want to calculate the sum of squared deviations.

Remarks

  • The arguments must be numbers or column references that contain numbers.

  • If argument contains text, logical values, or is empty, those values are ignored; however, arguments with the value zero are included.

  • The equation for the sum of squared deviations is:

    equation

Example

Col1

Col2

Col3

Col4

Col5

Col6

Col7

Formula

Description (Result)

4

5

8

7

11

4

3

=DEVSQ([Col1],[Col2],[Col3],[Col4],[Col5],[Col6],[Col7])

Sum of squares of deviations of data from their sample mean (48)

No comments:

Post a Comment