@VARIANCEP

The @VARIANCEP() function calculates the statistical variance of the specified data set (expList). The calculation is based upon the entire population. Variance is a measure of the dispersion of a set of data points around their mean (average) value.

Syntax

@VARIANCEP (SKIPNONE | SKIPMISSING | SKIPZERO | SKIPBOTH, expList)

SKIPNONE Includes all cells specified in expList, regardless of their content, during calculation of the variance.
SKIPMISSING Excludes all #MISSING values from expList during calculation of the variance.
SKIPZERO Excludes all zero (0) values from expList during calculation of the variance.
SKIPBOTH Excludes all zero (0) values and #MISSING values from expList during calculation of the variance.
expList Comma-delimited list of member specifications, variable names, functions, or numeric expressions. expList provides a list of numeric values across which the variance is calculated.

Notes

Example

The following example is based on the Sample Basic database. Assume that the Measures dimension contains an additional member, Sales Var. This example uses the @RANGE function to generate expList and calculates the variance of the sales values for a product family.

FIX (Product)
"Sales Var" = @VARIANCEP(SKIPBOTH,@RANGE(Sales,@CHILDREN(Product)));
ENDFIX

This example produces the following report:

	                             Jan      New York
	                           Actual        Budget
	                           ======        ======
	Sales       Colas            678           640
	           Root Beer        551           530
	           Cream Soda       663           510
	           Fruit Soda       587           620
	           Diet Drinks      #MI           #MI
	            Product        2479          2300
	
	Sales Var   Product         2765.69       3125
	

See Also

@VARIANCE

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com