NORM.INV
The value whose cumulative probability, in the normal distribution of a mean and standard deviation, is the one given.
Group: Statistics. Compatible with DAX.
Syntax
NORM.INV ( <Probability>, <Mean>, <Standard_dev> )| Parameter | Type | Description |
|---|---|---|
Probability | Number | The cumulative probability wanted, strictly between 0 and 1. |
Mean | Number | The centre of the normal curve. |
Standard_dev | Number | Its spread, above 0. |
Returns
Number. The value below which the given share of the normal distribution lies.
Remarks
- It is the mean plus the standard deviation times
NORM.S.INV( probability ). - A probability of 0 or 1 or beyond, or a standard deviation of 0 or less, is an error.
Examples
The 90th percentile and the median
EVALUATE
ROW ( "90th", NORM.INV ( 0.9, 40, 1.5 ), "Median", NORM.INV ( 0.5, 40, 1.5 ) )| 90th | Median |
|---|---|
| 41.9223273483169 | 40 |
Liters to have ready in 19 months of 20
The 95th percentile of a normal curve with the months' mean and spread.
EVALUATE
VAR Monthly = ADDCOLUMNS ( VALUES ( Sales[Month] ), "Liters", [Liters sold] )
RETURN
ROW (
"Enough in 95 % of months",
NORM.INV ( 0.95, AVERAGEX ( Monthly, [Liters] ), STDEVX.S ( Monthly, [Liters] ) )
)| Enough in 95 % of months |
|---|
| 61514.7033688965 |