Manuals/calci/DEVSQ

DEVSQ (n1, n2…...)

Where n1, n2 ... are the arguments

This function calculates the sum of the squares of deviations of data points from their sample mean.

· Arguments can be numbers, names, arrays, or references.

· Logical values and text representations of numbers are calculated.

· When an array contains text, logical values, or empty cells, those values are ignored.

Formula:-

· The equation to calculate the sum of squared deviations is:

'

DEVSQ

Let’s see an example

DEVSQ (n1, n2…..)

B

5

7

6

9

10

2

=DEVSQ (B2:B7) is 41.5

Syntax

Remarks

Examples

Description