| 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. |