The inverse error function (erfinv)

[Morten]

H

I need to use the inverse error function

erf(x)=0.8 <=> x=inverf(0.8) <=> x=0,90469

Currently i am using the goal seeker, but i know that matlab has a erfinv function - does excell have one? if not - does anybody know about som java-coding that can do it

Best regard

morten

 

[Jerry W. Lewis]

inverf(p) = SQRT(GAMMAINV(p,0.5,1))
inverfc(p) = -NormSInv(p/2)/Sqrt(2)

Mathemetically exact, but not necessarily numerically good in versions
prior to 2003.

Jerry

 

[Morten]

Thats works perfect... Thank you for solving my problem

Best regard

Morten, Denmark

 

[Jerry W. Lewis]

Glad it helped

Jerry