Changes

Jump to navigation Jump to search
no edit summary
Line 14: Line 14:  
*It is calculated using <math> "n-1" </math> 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 [[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 rference.  
 
*Also we can give the text representations of numbers or logical values , like TRUE or FALSE, in a rference.  
 
*Suppose the arguments containing TRUE which is eveluate as 1, and the arguments containing FALSE which is evaluate as 0.
 
*Suppose the arguments containing TRUE which is eveluate 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 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 nonnumeric.  
 
     1. Any one of the argument is nonnumeric.  
writer
6,694

edits

Navigation menu