NORM.S.INV DAX Function (Statistical)
Returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
Syntax
Parameter | Attributes | Description |
---|---|---|
Probability |
A probability corresponding to the normal distribution. |
Return values
The inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.
Examples
-- NORM.INV returns the inverse of the normal distribution -- for the specified mean and standard deviation -- -- NORM.S.INV returns the inverse of the standard normal distribution -- (has a mean of zero and a standard deviation of one) -- -- https://en.wikipedia.org/wiki/Normal_distribution DEFINE TABLE SampleData = { 2, 4, 4, 4, 5, 5, 7, 9 } VAR Mean = AVERAGE ( SampleData[Value] ) VAR StandardDev = STDEV.S ( SampleData[Value] ) VAR Percs = GENERATESERIES ( 0.05, 0.99, 0.05 ) VAR CumulativeTrue = TRUE -- Cumulative distribution function VAR CumulativeFalse = FALSE -- Probability density function EVALUATE SELECTCOLUMNS ( Percs, "Probability %", [Value], "Inv. Normal Distr.", -- Probability density function FORMAT ( NORM.INV ( [Value], Mean, StandardDev ), "#,0.00000" ), "Inv. Standard Normal Distr.", -- Probability density function FORMAT ( NORM.S.INV ( [Value] ), "#,0.00000" ) )
Probability % | Inv. Normal Distr. | Inv. Standard Normal Distr. |
---|---|---|
5.00% | 1.48316 | -1.64485 |
10.00% | 2.25993 | -1.28155 |
15.00% | 2.78401 | -1.03643 |
20.00% | 3.20054 | -0.84162 |
25.00% | 3.55788 | -0.67449 |
30.00% | 3.87878 | -0.52440 |
35.00% | 4.17615 | -0.38532 |
40.00% | 4.45832 | -0.25335 |
45.00% | 4.73132 | -0.12566 |
50.00% | 5.00000 | 0.00000 |
55.00% | 5.26868 | 0.12566 |
60.00% | 5.54168 | 0.25335 |
65.00% | 5.82385 | 0.38532 |
70.00% | 6.12122 | 0.52440 |
75.00% | 6.44212 | 0.67449 |
80.00% | 6.79946 | 0.84162 |
85.00% | 7.21599 | 1.03643 |
90.00% | 7.74007 | 1.28155 |
95.00% | 8.51684 | 1.64485 |
Related functions
Other related functions are:
Last update: Dec 4, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo, Kenneth Barber
Microsoft documentation: https://docs.microsoft.com/en-us/dax/norm-s-inv-dax