QuartileArray (Function)

The quartile of a data set stored in an array.

All array-based function calculations begin with array element 1.

Function

QuartileArray(QRank, PriceArray, Size)

Parameters

Name	Type	Description
QRank	Numeric	A numeric expression that determines which "QRank" is being referenced. This Input can exclusively be an integer from 0 to 4.
PriceArray	NumericArray	A numeric array upon which the Quartile calculation is performed.
Size	Numeric	A numeric expression representing the number of elements in the original array that have been used.

Returns

A numeric value containing the quartile of a data set. If the QRank Input is less than 0 or the QRank Input is greater than 4, the function returns a -1. Also, the Function will return a -1 if the Size is greater than the referenced array.

Usage

QuartileArray is a measure of "non-central" location used to split ordered data into four quarters.

The four quartiles can be defined as follow:

Q1: a value such that 25% of the observations are smaller, and 75% of the observations are larger.

Q2: a value such that 50% of the observations are smaller, and 50% of the observations are larger.

Q3: a value such that 75% of the observations are smaller, and 25% of the observations are larger.

Q4: a value such that 100% of the observations are smaller, and none of the observations are larger.