Difference between revisions of "Variance"
(jrfconvert import) |
|||
| Line 1: | Line 1: | ||
| − | [[Category: | + | [[Category:Functions_Used_in_where_Expressions]] |
| | ||
Revision as of 06:27, 28 March 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
