Vanguard Software
Forecasting & Planning Solutions

contents.gifindex.gifprev1.gifnext1.gif

variance

Format: variance( list )
variance(
x1, x2, ... )

Arguments: [num] list Input list (must contain at least two elements)

(num) x1, x2, ... Input values

Returns: (num) The variance of all elements in list if only one argument is supplied or the variance of all arguments if more than one argument is supplied

Description: The N-1 (unbiased) method is used to calculate the variance with the following formula:

  dph00495.gif

Examples: variance([1,2,3,4,5]) = 2.5

variance(1,2,3,4,5) = 2.5

See Also: std, count, sum, prod, avg, max, min, med, correlation

  Forecasting Software  |  Strategic Planning Software  |  Decision Support Software
Decision Tree Software  |  Monte Carlo Simulation Software  |  Risk Analysis Software
Portfolio Analysis Software  |  Expert System Software  |  Website Surveys

Contact Us  |  Terms of Use  |  Privacy Policy  |  Site Map
Vanguard Software
© 2010 Vanguard Software Corporation
Home Products Solutions Services Customers Partners Company
Vanguard
Applying science to business management
Vanguard
Print this page   Email this page to a friend