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.
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:
NORMALDIST(d0,Alignments...)
Normal distribution group:
NORMALDISTGROUP(d0,Alignments...)
2. Input
The Normal Distribution function requires 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 function requires the following parameters:
- Alignments... (One or More, Optional) – Hierarchy placeholders to be used as the alignment axis.
4. Output
The Normal Distribution function generates the following outputs:
- Normal Distribution - The Normal Distribution result set.
The Normal Distribution Group function generates the following outputs:
- Normal Distribution Group - The Normal Distribution Group result set.