| Line 18: |
Line 18: |
| | *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 [[Manuals/calci/VARP | VARP ]] function. | | *Suppose it should consider the data as the entire population, we can use the [[Manuals/calci/VARP | VARP ]] function. |
| − | *The arguments can be be either numbers or names, array,constants or references that contain numbers. | + | *The array values can be be either numbers or names, array,constants or references that contain numbers. |
| | *Suppose the array contains text,logical values or empty cells, like that values are not considered. | | *Suppose the array contains text,logical values or empty cells, like that values are not considered. |
| | *When we are entering logical values and text representations of numbers as directly, then the arguments are counted. | | *When we are entering logical values and text representations of numbers as directly, then the arguments are counted. |
| | *Suppose the function have to consider the logical values and text representations of numbers in a reference , we can use the [[Manuals/calci/VARA | VARA ]] function. | | *Suppose the function have to consider the logical values and text representations of numbers in a reference , we can use the [[Manuals/calci/VARA | VARA ]] 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 array value 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== |
| | + | #VARIF([2,7,19,20,43,65,77,81],">10") = 764.1666666666666 |
| | + | #VARIF([2,7,19,20,43,65,77,81],"<10") = 12.5 |
| | + | #VARIF([10,25,18,FALSE],"<23") = 32 |
| | + | |
| | + | ==See Also== |
| | + | *[[Manuals/calci/VAR | VAR]] |
| | + | *[[Manuals/calci/VARP | VARP ]] |
| | + | *[[Manuals/calci/VARA | VARA ]] |
| | + | |
| | + | ==References== |
| | + | *[http://en.wikipedia.org/wiki/Variance Variance] |
| | + | |
| | + | *[[Z_API_Functions | List of Main Z Functions]] |
| | + | *[[ Z3 | Z3 home ]] |