Dundas Chart for SharePoint Send comments on this topic.
Variance Formula
See Also

Glossary Item Box

Overview

This formula returns the variance within a group of data.

Applying the Formula

All statistical formulas are calculated using the Statistics class, and the following table describes how to use its Variance method.

 

Value/Description Example
Formula Name: Statistics.Variance ("Series1", false);.
Parameters:
  1. inputSeriesName: The name of the Series object that stores the group of data.
  2. sampleVariance: true if the data is a sample of a population, false if it is the entire population.
Statistics.Variance("Series1", false);
Return: A double that represents the variance within the group of data.

-

 

Note
Make sure that all data points have their XValue property set, and that their series' XValueIndexed property has been set to false.
Statistical Interpretation

Variance is the square of the standard deviation for the given data.

Example

This sample gets the variance of the data points in a series named "Series1". Note that the Y1 value of the data points is used. We also assume that a sample from the entire population is not being used.

Visual Basic Copy Code
Dim result As Double = chartObj.DataManipulator.Statistics.Variance("Series1", false)
C# Copy Code
double result = chartObj.DataManipulator.Statistics.Variance("Series1", false);

See Also

Formulas
Formulas Overview

Statistical Formulas
Using Statistical Formulas