Difference between revisions of "Manuals/calci/STDEVA"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''STDEVA(n1,n2,n3…)'''</div><br/> | <div style="font-size:30px">'''STDEVA(n1,n2,n3…)'''</div><br/> | ||
*<math>n1,n2,n3... </math> are numbers. | *<math>n1,n2,n3... </math> are numbers. | ||
| − | |||
==Description== | ==Description== | ||
| − | *This function gives the | + | *This function gives the Standard Deviation based on a given sample including the logical value and text. |
| − | *Standard | + | *Standard Deviation is a quantity expressing by how much the members of a group differ from the mean value for the group. |
*It is the used as a measure of the dispersion or variation in a distribution. | *It is the used as a measure of the dispersion or variation in a distribution. | ||
*It is calculated as the square root of variance. | *It is calculated as the square root of variance. | ||
| − | *In <math>STDEVA(n1,n2,n3...), n1,n2,n3...</math>, are numbers to find the standard deviation. | + | *In <math>STDEVA(n1,n2,n3...)</math>, <math>n1,n2,n3...</math>, are numbers to find the standard deviation. *Here <math> n1 ,</math> is required. <math> n2,n3,..</math> are optional. |
| − | *Here <math> n1 ,</math> is required. <math> n2,n3,..</math> are optional. | ||
*Instead of numbers we can use the single array or a reference of a array. | *Instead of numbers we can use the single array or a reference of a array. | ||
| − | *<math> STDEVA </math> is defined by the formula:<math>S.D= \sqrt \frac {\sum(x-\bar{x})^2}{(n-1)} </math> where <math> \bar{x} </math> is the sample mean of x and n is the total numbers in the given data. | + | *<math> STDEVA </math> is defined by the formula: |
| + | <math>S.D= \sqrt \frac {\sum(x-\bar{x})^2}{(n-1)} </math> | ||
| + | where <math> \bar{x} </math> is the sample mean of x and n is the total numbers in the given data. | ||
*It is calculated using <math> "n-1" </math> method. | *It is calculated using <math> "n-1" </math> method. | ||
| − | *This function | + | *This function consider our given data as the sample population. |
| − | *Suppose it | + | *Suppose it consider the data as the entire population, we can use the [[Manuals/calci/STDEVPA | STDEVPA ]] function. |
*The arguments can be be either numbers or names, array,constants or references that contain numbers. | *The arguments can be be either numbers or names, array,constants or references that contain numbers. | ||
| − | *Also we can give the text representations of numbers or logical values , like TRUE or FALSE, in a | + | *Also we can give the text representations of numbers or logical values , like TRUE or FALSE, in a reference. |
| − | *Suppose the arguments containing TRUE which is | + | *Suppose the arguments containing TRUE which is evaluate as 1, and the arguments containing FALSE which is evaluate as 0. |
*Suppose the array contains the empty cells and text values like that values are not considered. | *Suppose the array contains the empty cells and text values like that values are not considered. | ||
| − | *Suppose the function don't want to consider the logical values and text representations of numbers in a reference , we can use the [[Manuals/calci/STDEV | STDEV ]] function. | + | *Suppose the function don't want to consider the logical values and text representations of numbers in a reference, we can use the [[Manuals/calci/STDEV | STDEV ]] function. |
*This function will return the result as error when | *This function will return the result as error when | ||
| − | 1. Any one of the argument is | + | 1. Any one of the argument is non-numeric. |
2. The arguments containing the error values or text that cannot be translated in to numbers. | 2. The arguments containing the error values or text that cannot be translated in to numbers. | ||
| − | |||
==Examples== | ==Examples== | ||
| Line 42: | Line 41: | ||
#STDEVA(4,8,TRUE) = 3.51188458428 | #STDEVA(4,8,TRUE) = 3.51188458428 | ||
#STDEVA(12,18,27,32,false)= 8.958236433584458 | #STDEVA(12,18,27,32,false)= 8.958236433584458 | ||
| − | |||
==See Also== | ==See Also== | ||
| Line 49: | Line 47: | ||
*[[Manuals/calci/STDEVP | STDEVP ]] | *[[Manuals/calci/STDEVP | STDEVP ]] | ||
*[[Manuals/calci/STDEV | STDEV ]] | *[[Manuals/calci/STDEV | STDEV ]] | ||
| − | |||
| − | |||
==References== | ==References== | ||
Revision as of 04:10, 30 January 2014
STDEVA(n1,n2,n3…)
- are numbers.
are numbers.Description
- This function gives the Standard Deviation based on a given sample including the logical value and text.
- Standard Deviation is a quantity expressing by how much the members of a group differ from the mean value for the group.
- It is the used as a measure of the dispersion or variation in a distribution.
- It is calculated as the square root of variance.
- In , , are numbers to find the standard deviation. *Here is required. are optional.
- Instead of numbers we can use the single array or a reference of a array.
- is defined by the formula:
, 
is required. 
are optional.
is defined by the formula:where is the sample mean of x and n is the total numbers in the given data.
where 
is the sample mean of x and n is the total numbers in the given data.
- It is calculated using Failed to parse (syntax error): {\displaystyle "n-1" } method.
- This function consider our given data as the sample population.
- Suppose it consider the data as the entire population, we can use the STDEVPA function.
- The arguments can be be either numbers or names, array,constants or references that contain numbers.
- Also we can give the text representations of numbers or logical values , like TRUE or FALSE, in a reference.
- Suppose the arguments containing TRUE which is evaluate as 1, and the arguments containing FALSE which is evaluate as 0.
- Suppose the array contains the empty cells and text values like that values are not considered.
- Suppose the function don't want to consider the logical values and text representations of numbers in a reference, we can use the STDEV function.
- This function will return the result as error when
1. Any one of the argument is non-numeric. 2. The arguments containing the error values or text that cannot be translated in to numbers.
Examples
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | 208 | 428 | 511 | 634 | 116 | 589 | 907 |
| 2 | 18 | 25 | 76 | 91 | 107 |
- STDEVA(A2:E2)=39.8660256358
- STDEVA(A1:G1)=267.0566196431
- STDEVA(4,8,TRUE) = 3.51188458428
- STDEVA(12,18,27,32,false)= 8.958236433584458