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

Glossary Item Box

Overview

This formula returns the median for data stored in a data series.

Applying the Formula

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

 

Value/Description Example
Formula Name: Median Statistics.Median ("Series1")
Parameters:

inputSeriesName: The names of one or more Series objects that store the data points for which the median is required.

Statistics.Median("Series1")
Return: A double that represents the median for all the data points in the given series.

-

 

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

The median of a sample set is that value for which half of the members are greater in size and half the members are lesser in size.

Please note that it is the first Y value (Y1) of all data points that are used to calculate the median.

 

Figure 1: A line type chart, with a Strip Line on the Y-axis representing the Median.

 

Example

This example demonstrates how to get the median of the data points in a series named "Series1". Note that the Y1 value of the data points is used.

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

See Also

Formulas
Formulas Overview

Statistical Formulas
Using Statistical Formulas