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 sample gets 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 |
---|---|
|
C# | Copy Code |
---|---|
|
Financial Formulas
Formulas Overview
Statistical Formulas
Using Statistical Formulas