|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 14th, 2004, 04:47 PM
|
|||
|
|||
include inverse error function (erfinv and erfcinv) in Excel.
subject line says it all!
|
|
#2
September 14th, 2004, 05:30 PM
|
|||
|
|||
|
Yes, sure!
I assume that answers your question. -- Kind Regards, Niek Otten Microsoft MVP - Excel "fv" wrote in message ... subject line says it all!
|
|
#3
September 14th, 2004, 11:48 PM
|
|||
|
|||
|
No, but you can use the relationship between erf and statistical
distributions to fake it. erf(x) = GammaDist(x^2,0.5,1,True) so erfinv(p) = Sqrt(GammInv(p,0.5,1)) erfc(x) = ChiDist(2*x^2,1) so erfcinv(p) = Sqrt(ChiInv(p,1)/2) The ChiDist function is much more accurate for large x than the ATP erfc function. The Inv functions are useless for p's associated with x 3.5 in Excel versions prior to 2003. Jerry fv wrote: subject line says it all!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
