### Title

Normal Distribution Function in FMP

### Post

Hello-

Does anyone know how to find normal distribution results in FMP? I found the StDev function, but don't see a NormDist.

Thoughts?

Thanks.

Normal Distribution Function in FMP

Hello-

Does anyone know how to find normal distribution results in FMP? I found the StDev function, but don't see a NormDist.

Thoughts?

Thanks.

mrbill wrote:…Little manual math.

Hi Mr. Bill,

You can use 2 summary fields to automatically calculate the average (approximation of mean) and standard deviation.

That leaves a calculation field for the normal distribution.

Try:

( 1 / Sqrt ( 2 * Pi * standard_deviation^2 )) * Exp ( - ( x - average )^2 / ( 2 * standard_deviation^2 ) )

OK…this is well into my category: quit while you're ahead.:smileywink:

I found an approximation of the cumulative form using standard functions but have no means of verifying the results.

Try:

Let(z=(x-Average)/(Standard_deviation*Sqrt(2)) ; 0.5*(1+(z/Abs(z))*Sqrt(1 - Exp(-(z^2)*((4/Pi)+0.140012*z^2)/(1+0.140012*z^2)))))

If this does not work, perhaps someone else can help.

WOW! I think my head just exploded :smileytongue:

It looks like its doing what I want it to do... Basically, give a score based on the inputs. So this way, the highest input (number) is given the highest score (say 5 is .5) and lowest is given the lowest (say 1 is .1).

It appears to be doing this. Example:

The newnorm is the column with the updates formula you gave me and its matching excel to the decimal. Nice work.

Many thanks for staying with this. Now I actually have to build what I want, but at least I know it can be done.

Thanks again!

Hi Chris

"a" is a constant and an approximation of: (8*(Pi - 3)) / (3*Pi*(4 - Pi)). Using this value, the largest error in the fit of the distribution is about 0.00012. The formula above using standard FMP functions is only an approximation of an integral equation.

See the definition of the Error Function "Approximation with elementary functions" for more details.

Hope this helps a bit…

P.S. This also may be of interest: Normal Cumulative Distribution "Standard deviation and confidence intervals"

If you can calculate the mean (μ) and standard deviation (σ) then you calculate the normal distribution (f(x)) for any data point (x) using FMP math functions (e.g. StDev, Sqrt, Exp):