The inverse error function (erfinv)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top