NORMDIST (PQL - xl)
This function returns the normal cumulative distribution for the specified mean and standard deviation
- Library: PQL \ Spreadsheet \ Compatibility
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
NORMDIST(x, mean, standard dev, cumulative)
Function Arguments
Name | Description | Type | Optional |
x | Value for which to find the distribution | Number |
|
mean | Arithmetic mean of the distribution | Number |
|
standard dev | Standard deviation of the distribution Must be greater than zero | Number |
|
cumulative | Set to TRUE to return the cumulative distribution function. Set to FALSE to return the probability mass function | StringOrNumber |
|
Comments
This function is the same as the Microsoft Excel 'NORMDIST' function - using the same inputs, logic and outputs.