Difference between revisions of "Manuals/calci/DEVSQ"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> <font size="3"><font face="Times New Roman">'''DEVSQ''' (n1, n2…...)</font></font> <font size="3"><font face="Ti...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''DEVSQ(n1,n2)'''</div><br/> |
| + | *where n1,n2..are any real numbers. | ||
| + | ==Description== | ||
| + | *This function gives the sum of squares of deviation of a given set of numbers. | ||
| + | *This function will calculate the with following steps : | ||
| + | 1. we have to find the mean . | ||
| + | 2. To find the deviation of each value we have to subtracting all numbers with its mean value. | ||
| + | 3.Then it is squaring each deviation values and finally it is summing up. | ||
| + | *DEVSQ=summation (xi-x(bar))^2 where xi is the every observation and x(bar) 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 refercences 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 convert in to numbers. | ||
| + | ==Examples== | ||
| − | + | *ABS(8)=8 | |
| + | *ABS(-5)=5 | ||
| + | *ABS(1/2)=0.5 | ||
| + | *ABS(-1/4)=0.25 | ||
| − | + | ==See Also== | |
| + | *[[Manuals/calci/IMABS | IMABS ]] | ||
| − | + | ==References== | |
| − | + | [http://en.wikipedia.org/wiki/Absolute_value| Absolute_value] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 03:40, 21 November 2013
DEVSQ(n1,n2)
- where n1,n2..are any real numbers.
Description
- This function gives the sum of squares of deviation of a given set of numbers.
- This function will calculate the with following steps :
1. we have to find the mean . 2. To find the deviation of each value we have to subtracting all numbers with its mean value. 3.Then it is squaring each deviation values and finally it is summing up.
- DEVSQ=summation (xi-x(bar))^2 where xi is the every observation and x(bar) 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 refercences 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 convert in to numbers.
Examples
- ABS(8)=8
- ABS(-5)=5
- ABS(1/2)=0.5
- ABS(-1/4)=0.25