NORM.DIST DAX Function (Statistical)
Returns the normal distribution for the specified mean and standard deviation.
Syntax
Parameter | Attributes | Description |
---|---|---|
X |
The value for which you want the distribution. |
|
Mean |
The arithmetic mean of the distribution. |
|
Standard_dev |
The standard deviation of the distribution. |
|
Cumulative |
A logical value that determines the form of the function. If cumulative is TRUE, NORM.DIST returns the cumulative distribution function; if FALSE, it returns the probability mass function. |
Return values
The normal distribution for the specified mean and standard deviation.
Examples
-- NORM.DIST returns the normal distribution for the -- specified mean and standard deviation -- -- NORM.DIST ( Value, Mean, StandardDev, Cumulative ) -- -- NORM.S.DIST returns the standard normal distribution -- (has a mean of zero and a standar 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 Vals = GENERATESERIES ( 0.0, 10, 0.5 ) VAR CumulativeTrue = TRUE -- Cumulative distribution function VAR CumulativeFalse = FALSE -- Probability density function EVALUATE ADDCOLUMNS ( Vals, "Normal Distr.", -- Probability density function FORMAT ( NORM.DIST ( [Value], Mean, StandardDev, CumulativeFalse ), "#,0.00000" ), "Normal Distr. Cumulative", -- Cumulative distribution function FORMAT ( NORM.DIST ( [Value], Mean, StandardDev, CumulativeTrue ), "#,0.00000" ), "Normal Std. Distr.", -- Cumulative distribution function FORMAT ( NORM.S.DIST ( [Value], CumulativeFalse ), "#,0.00000" ), "Normal Std. Distr. Cumulative", -- Cumulative distribution function FORMAT ( NORM.S.DIST ( [Value], CumulativeTrue ), "#,0.00000" ) )
Value | Normal Distr. | Normal Distr. Cumulative | Normal Std. Distr. | Normal Std. Distr. Cumulative |
---|---|---|---|---|
0.00 | 0.01212 | 0.00968 | 0.39894 | 0.50000 |
0.50 | 0.02037 | 0.01766 | 0.35207 | 0.69146 |
1.00 | 0.03242 | 0.03068 | 0.24197 | 0.84134 |
1.50 | 0.04886 | 0.05082 | 0.12952 | 0.93319 |
2.00 | 0.06972 | 0.08029 | 0.05399 | 0.97725 |
2.50 | 0.09419 | 0.12115 | 0.01753 | 0.99379 |
3.00 | 0.12047 | 0.17479 | 0.00443 | 0.99865 |
3.50 | 0.14588 | 0.24148 | 0.00087 | 0.99977 |
4.00 | 0.16726 | 0.32000 | 0.00013 | 0.99997 |
4.50 | 0.18156 | 0.40755 | 0.00002 | 1.00000 |
5.00 | 0.18659 | 0.50000 | 0.00000 | 1.00000 |
5.50 | 0.18156 | 0.59245 | 0.00000 | 1.00000 |
6.00 | 0.16726 | 0.68000 | 0.00000 | 1.00000 |
6.50 | 0.14588 | 0.75852 | 0.00000 | 1.00000 |
7.00 | 0.12047 | 0.82521 | 0.00000 | 1.00000 |
7.50 | 0.09419 | 0.87885 | 0.00000 | 1.00000 |
8.00 | 0.06972 | 0.91971 | 0.00000 | 1.00000 |
8.50 | 0.04886 | 0.94918 | 0.00000 | 1.00000 |
9.00 | 0.03242 | 0.96932 | 0.00000 | 1.00000 |
9.50 | 0.02037 | 0.98234 | 0.00000 | 1.00000 |
10.00 | 0.01212 | 0.99032 | 0.00000 | 1.00000 |
Related functions
Other related functions are:
Last update: Nov 14, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://docs.microsoft.com/en-us/dax/norm-dist-dax