Difference between revisions of "Manuals/calci/DEVSQ"

From ZCubes Wiki
Jump to navigation Jump to search
Line 1: Line 1:
<div style="font-size:30px">'''DEVSQ(n1,n2...)'''</div><br/>
+
<div style="font-size:30px">'''DEVSQ()'''</div><br/>
*<math>n_1,n_2..</math> are any real numbers.
+
*Parameters are any set of real numbers.
  
 
==Description==
 
==Description==
Line 17: Line 17:
 
==ZOS==
 
==ZOS==
  
*The syntax is to calculate DEVSQ in ZOS is <math>DEVSQ(n_1,n_2,....)</math>.
+
*The syntax is to calculate DEVSQ in ZOS is <math>DEVSQ()</math>.
**where <math>n_1,n_2..</math> are any real numbers.
+
**Parameters are any set of real numbers.
 
*For e.g.,DEVSQ(1.5..7.5..0.3)
 
*For e.g.,DEVSQ(1.5..7.5..0.3)
 
{{#ev:youtube|wsr8HO-ByJk|280|center|Average}}
 
{{#ev:youtube|wsr8HO-ByJk|280|center|Average}}

Revision as of 13:03, 6 June 2018

DEVSQ()


  • Parameters are any set of real numbers.

Description

  • This function gives the sum of Squares of Deviation of a given set of numbers.
  • The steps to calculate:
  1. Find the mean.
  2. Find the deviation of each value. For that, subtract all numbers with its mean value.
  3. Square each Deviation Values and find its sum.
where is the every observation and is the Arithmetic Mean.
  • Here we have to give more than one arguments and arguments can be either numbers,names,logical values,

arrays or cell references that contain numbers.

  • Also cells with the value of '0' are considered and the arguments contains text, logical values or empty cells are ignored.
This function will give the result as error, when the text couldn't be converted to numbers.

ZOS

  • The syntax is to calculate DEVSQ in ZOS is .
    • Parameters are any set of real numbers.
  • For e.g.,DEVSQ(1.5..7.5..0.3)
Average

Examples

  • DEVSQ(50,52, 54, 56, 58, 60)

Steps

  1. Mean =
  2. Deviation =
  3. Squares of Deviation =
  • DEVSQ(5,-10,13,-7,9) = 404
  • DEVSQ(1.2,6.4,8.3,5.7,10) = 44.068

Related Videos

Sum of Squared Deviation

See Also

References

Squared Deviations