Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Zhiming Qi
 
Posts: n/a
Default How can I download and install ERROR FUNCTION in Excel 2003? ERF.

How can I download and install ERROR FUNCTION in Excel 2003? ERF() is not
available in my excel.
Thanks much!
  #2   Report Post  
Vasant Nanavati
 
Posts: n/a
Default

Do you have the Analysis Toolpak installed?

--

Vasant

"Zhiming Qi" <Zhiming wrote in message
...
How can I download and install ERROR FUNCTION in Excel 2003? ERF() is not
available in my excel.
Thanks much!



  #3   Report Post  
Jerry W. Lewis
 
Posts: n/a
Default

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!


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
where can I find a free excel download to use cwood Setting up and Configuration of Excel 6 July 29th 05 04:19 AM
How do I download install Excell 2000 Analysis Tool Pak? jamo Excel Worksheet Functions 1 April 4th 05 03:59 PM
How do I install Excel 2000 Analysis Tool Pak? jamo Excel Discussion (Misc queries) 1 April 4th 05 03:25 AM
Where can I download the "solver" add-in for Excel 2000? Mr. Bond Excel Discussion (Misc queries) 3 April 3rd 05 12:21 PM
Need Excel Analysis toolpak - don't have CD, where to download? mercerisle Excel Worksheet Functions 1 November 10th 04 06:15 AM


All times are GMT +1. The time now is 05:54 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"