How can I download and install ERROR FUNCTION in Excel 2003? ERF() is not
available in my excel.
Thanks much!
How can I download and install ERROR FUNCTION in Excel 2003? ERF() is not
available in my excel.
Thanks much!
Do you have the Analysis Toolpak installed?
--
Vasant
"Zhiming Qi" <Zhiming Qi@discussions.microsoft.com> wrote in message
news:3BE5B65A-A342-4D69-BDB8-AF2D04231F0A@microsoft.com...
> How can I download and install ERROR FUNCTION in Excel 2003? ERF() is not
> available in my excel.
> Thanks much!
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
Zhiming Qi wrote:
> How can I download and install ERROR FUNCTION in Excel 2003? ERF() is not
> available in my excel.
> Thanks much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks