Difference between revisions of "Variance"
| Line 1: | Line 1: | ||
[[Category:Functions_Used_in_where_Expressions]] | [[Category:Functions_Used_in_where_Expressions]] | ||
| − | | + | {{HelpFiles}} |
====variance==== | ====variance==== | ||
Revision as of 09:13, 12 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
variance(C1) where C2 == [1];
Availability
Version 5.2
