Normal Distribution


The Normal Distribution function calculates the standard normal distribution for an input data series.

Specifically, the function computes the relative likelihood that a continuous random variable would equal the input value if the series had a symmetrical "bell-curved" distribution.

Normal Distribution output shown on the Script Measure column
Normal Distribution output shown on the Script Measure column

The Normal Distribution Group function can be optionally used to calculate the standard normal distribution for each input data series grouped by the specified hierarchies.

1. Syntax

Normal Distribution:


Normal Distribution Group:


2. Input

The Normal Distribution functions require the following input series:

  • d0 - Input data values - The set of data values for which the Normal Distribution is calculated.

3. Parameters

The Normal Distribution functions accept the following parameters:

  • Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.
    • For NORMALDIST, specifying a hierarchy calculates standard normal distribution for the corresponding input values separately each time they occur: e.g., NORMALDIST($Measure$, $Month$) can calculate results based on monthly values grouped by another hierarchy such as Country.
    • For NORMALDISTGROUP, specify the hierarchies by which to group the input values and calculate the standard normal distribution within each group: e.g., NORMALDISTGROUP($Measure$, $Country$) will calculate results separately for the values within each country.

4. Output

The Normal Distribution functions generate the following outputs:

  • Normal Distribution - The Normal Distribution result set(s).

5. See also

Dundas Data Visualization, Inc.
400-15 Gervais Drive
Toronto, ON, Canada
M3C 1Y8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri