Changes

Jump to navigation Jump to search
386 bytes added ,  08:52, 25 January 2014
no edit summary
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
 +
 +
 +
 +
     
writer
6,694

edits

Navigation menu