| Line 11: |
Line 11: |
| | *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: S.D= sqrt(summation(x-x(bar))^2/(n-1), where x(bar) 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 "n-1" method. | + | *It is calculated using <math> "n-1" </math> method. |
| | *This function is considering our given data is the sample of the population. | | *This function is considering our given data is the sample of the population. |
| − | *Suppose it should consider the data as the entire population, we can use the STDEVPA function. | + | *Suppose it should 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. | | *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 rference. | | *Also we can give the text representations of numbers or logical values , like TRUE or FALSE, in a rference. |
| Line 23: |
Line 23: |
| | 1. Any one of the argument is nonnumeric. | | 1. Any one of the argument is nonnumeric. |
| | 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== |
| | + | {| class="wikitable" |
| | + | |+Spreadsheet |
| | + | |- |
| | + | ! !! 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 |
| | + | |
| | + | |
| | + | |
| | + | |
| | | | |
| | | | |