As an alternative to installing the Analysis ToolPak, you could use
Erf(x) = GammaDist(x^2,0.5,1,TRUE)
ErfC(x) = ChiDist(2*x^2,1) = 2*NormSDist(-x*Sqrt(2))
ChiDist is more accurate than ErfC in all Excel versions. In Excel
2003, NormSDist is more accurate that either ErfC or ChiDist.
Jerry
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.