Difference between revisions of "Variance"
| (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 11: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
