NORM.INV
The inverse of the normal cumulative distribution for the specified mean and standard deviation.
Syntax
NORM.INV(Probability, Mean, Standard_dev)
Parameters
| Term | Definition |
|---|---|
| Probability | A probability corresponding to the normal distribution. |
| Mean | The arithmetic mean of the distribution. |
| Standard_dev | The standard deviation of the distribution. |
Return value
Returns the inverse of the normal cumulative distribution for the specified mean and standard deviation.
Remarks
This function is not supported for use in DirectQuery mode when used in calculated columns or row-level security (RLS) rules.
Example
EVALUATE { NORM.INV(0.908789, 40, 1.5) }
Returns
| [Value] |
|---|
| 42.00000200956628780274132 |
Related content
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for