NormCumDensityArray (Function)

$image\trumpet2.gif$ Disclaimer

The NormCumDensityArray function calculates the normal cumulative density (also called distribution) for an array of values, based on the array-based mean and standard deviation calculations.

Syntax

NormalCumDensityArray(PriceArray, Size)

Returns (Double)

A numeric value containing the normal cumulative density (also called distribution) for an array of values.

Parameters

Name	Type	Description
PriceArray	Numeric Array	Specifies the name of a numeric array containing values upon which the normal cumulative density is calculated.
Size	Numeric	Sets the number of data elements (size) in the array to evaluate.

Remarks

This function has a very wide range of applications in statistics, including hypothesis testing.

The value for the Size input parameter should always be a whole number greater than 0 and is typically equal to the number of data elements in the array.

The NormCumDensityArray function only works with one-dimensional arrays. All array-based referencing begins with array element 1.

Example

Assigns to Value1 the 10 bar normal cumulative density for a specified array.

Array: myArray[10](0);

{… (assign values to array) }

Value1 = NormCumDensityArray(myArray, 10);