NORMINV (PQL - xl)
This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation
- Library: PQL \ Spreadsheet \ Compatibility
- Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module
Syntax
NORMINV(probability, mean, standard dev)
Function Arguments
Name | Description | Type | Optional |
probability | Probability of the normal distribution | Number |
|
mean | Arithmetic mean of the distribution | Number |
|
standard dev | Standard deviation of the distribution Must be greater than zero | Number |
|
Comments
This function is the same as the Microsoft Excel 'NORMINV' function - using the same inputs, logic and outputs.