Difference between revisions of "Manuals/calci/DEVSQ"
Jump to navigation
Jump to search
| Line 8: | Line 8: | ||
#Find the deviation of each value. For that, subtract all numbers with its mean value. | #Find the deviation of each value. For that, subtract all numbers with its mean value. | ||
#Square each Deviation Values and find its sum. | #Square each Deviation Values and find its sum. | ||
| − | + | :<math>DEVSQ=\sum(xi-\bar{x})^2</math> where <math>xi</math> is the every observation and <math>\bar{x}</math> is the Arithmetic Mean. | |
*Here we have to give more than one arguments and arguments can be either numbers,names,logical values, | *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. | arrays or cell references that contain numbers. | ||
Revision as of 01:33, 26 November 2013
DEVSQ(n1,n2...)
- where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 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 with following steps :
- Find the mean.
- Find the deviation of each value. For that, subtract all numbers with its mean value.
- Square each Deviation Values and find its sum.
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle DEVSQ=\sum(xi-\bar{x})^2} where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle xi} is the every observation and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \bar{x}} 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.
Examples
- DEVSQ(50,52, 54, 56, 58, 60)
Steps
Mean = (50+52+ 54+ 56+ 58+ 60)/6 = 330/6 = 55
Deviation = |50-55|,|52-55|,|54-55|,|56-55|,|58-55|,|60-55| = 5,3,1,1,3,5
Squares of Deviation = Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle 5^2,3^2,1^2,1^2,3^2,5^2}
= 25+9+1+1+9+25 = 70
- DEVSQ(5,-10,13,-7,9) = 404
- DEVSQ(1.2,6.4,8.3,5.7,10) = 44.068