Median

Syntax

Median(Inputs: Array)

Parameters

Inputs. Variable.

Description

It returns median for the specified variable.

Comments

If more than one variable is specified in Inputs, then median for corresponding variable values will be calculated. For example, median for points from 2018 by all variables.

The variables in Inputs must be specified via comma.

It is available to set up calculation period for function. To do it, use the SetPeriod function by specifying it at any place of input array.

To calculate function without taking into account empty values, use the IgnoreMissing parameter by specifying it at any place of input array. Available parameter values:

True. Default value. Calculation does not take into account empty values.
False. Calculation takes into account empty values.

Example

Formula	Result	Application
= Median({Brazil\|BCA},{Peru\|BCA}, False, SetPeriod(2000,2010))	Median of corresponding observations of the Brazil\|BCA and Peru\|BCA series taking into account empty values for the period from 2000 to 2010.	It can be used in formulas of calculated series of time series database and in formulas of attribute-based models of modeling container.
= Median(X1, SetPeriod(2000,2010))	The X1 factor median for the period from 2000 to 2010.	It can be used in model variable-based formulas of modeling container.
= Median(1, 2, 3, 4)	2.5	it can be used in any expressions.