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

---

	Column1	Column2	Column3	Column4
Row1	5	41.5
Row2	7
Row3	6
Row4	9
Row5	10
Row6	2
Row7

File:Calci1.gif

---