More actions
No edit summary |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
[[Category:Functions_Used_in_where_Expressions]] | [[Category:Functions_Used_in_where_Expressions]] | ||
| {{HelpFiles}} | ||
====variance==== | ====variance==== | ||
| Line 24: | Line 24: | ||
'''Example''' | '''Example''' | ||
variance(C1) where C2 == [1]; | ''number n = variance(C1) where C2 == [1]; '' | ||
''print(n); //return variance value '' | |||
'''Availability''' | '''Availability''' | ||
Latest revision as of 10:52, 20 December 2011
variance
Estimates variance based on a data cache column’s values.
Calculates
Where x is the sample mean average and n is the sample size.
Note that the variance is NOT calculated based on the categories, but using all data in the dcs. All empty values are ignored.
Syntax
variance(dcsColumn)
Arguments
dcsColumn: is a numeric dcs column (column whose data type is Number)
Example
number n = variance(C1) where C2 == [1];
print(n); //return variance value
Availability
Version 5.2