NormDensityArray (Function)

image\trumpet2.gif Disclaimer

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

Syntax

NormalDensityArray(PriceArray, Size)

Returns (Double)

A numeric value containing the normal 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 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 NormDensityArray function only works with one-dimensional arrays.  All array-based referencing begins with array element 1.

Example

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

Array: myArray[10](0);

{… (assign values to array) }

Value1 = NormDensityArray(myArray, 10);