Excel 's precision problem

Now I found Excel' precision is not very hign !
May be there is some problem in some Excel funcion's
implemention.ex:
in Excel :gammaln(4)=1.79175946908210000
but it is 1.791759469228055 in MATLAB and Mathematica !!
Same problem in function erf(),and so on!


Some one who know the detail??


Thank you !

"chenj" <anonymous@discussions.microsoft.com> wrote in message
news:0c7b01c3a9c7$2103d070$a101280a@phx.gbl...
>
> Now I found Excel' precision is not very hign !
> May be there is some problem in some Excel funcion's
> implemention.ex:
> in Excel :gammaln(4)=1.79175946908210000
> but it is 1.791759469228055 in MATLAB and Mathematica !!
> Same problem in function erf(),and so on!
>

According to my version of excel (2000) it evaluates to:

1.7917594690821

Numerically equal to your quoted value of 1.79175946908210000 but
without the implicit level of precision that your trailing zeros might
carry.

I guess that you have to accept that it is only correct to 9 d.p.or 10
s.f. If you need more precision that that, you probably need to stick
to dedicated apps.

Alan.

>-----Original Message-----
>
>"chenj" <anonymous@discussions.microsoft.com> wrote in
message
>news:0c7b01c3a9c7$2103d070$a101280a@phx.gbl...
>>
>> Now I found Excel' precision is not very hign !
>> May be there is some problem in some Excel funcion's
>> implemention.ex:
>> in Excel :gammaln(4)=1.79175946908210000
>> but it is 1.791759469228055 in MATLAB and Mathematica !!
>> Same problem in function erf(),and so on!
>>
>

hi
I don't know what you said.
would you told me more!

Thank you !
>According to my version of excel (2000) it evaluates to:
>
>1.7917594690821
>
>Numerically equal to your quoted value of
1.79175946908210000 but
>without the implicit level of precision that your
trailing zeros might
>carry.
>
>I guess that you have to accept that it is only correct
to 9 d.p.or 10
>s.f. If you need more precision that that, you probably
need to stick
>to dedicated apps.
>
>Alan.
>
>
>.
>

>-----Original Message-----
>
>"chenj" <anonymous@discussions.microsoft.com> wrote in
message
>news:0c7b01c3a9c7$2103d070$a101280a@phx.gbl...
>>
>> Now I found Excel' precision is not very hign !
>> May be there is some problem in some Excel funcion's
>> implemention.ex:
>> in Excel :gammaln(4)=1.79175946908210000
>> but it is 1.791759469228055 in MATLAB and Mathematica !!
>> Same problem in function erf(),and so on!
>>
>

hi
I don't know what you said.
would you told me more!

Thank you !
>According to my version of excel (2000) it evaluates to:
>
>1.7917594690821
>
>Numerically equal to your quoted value of
1.79175946908210000 but
>without the implicit level of precision that your
trailing zeros might
>carry.
>
>I guess that you have to accept that it is only correct
to 9 d.p.or 10
>s.f. If you need more precision that that, you probably
need to stick
>to dedicated apps.
>
>Alan.
>
>
>.
>

>-----Original Message-----
>
>"chenj" <anonymous@discussions.microsoft.com> wrote in
message
>news:0c7b01c3a9c7$2103d070$a101280a@phx.gbl...
>>
>> Now I found Excel' precision is not very hign !
>> May be there is some problem in some Excel funcion's
>> implemention.ex:
>> in Excel :gammaln(4)=1.79175946908210000
>> but it is 1.791759469228055 in MATLAB and Mathematica !!
>> Same problem in function erf(),and so on!
>>
>

hi
I don't know what you said.
would you told me more!

Thank you !
>According to my version of excel (2000) it evaluates to:
>
>1.7917594690821
>
>Numerically equal to your quoted value of
1.79175946908210000 but
>without the implicit level of precision that your
trailing zeros might
>carry.
>
>I guess that you have to accept that it is only correct
to 9 d.p.or 10
>s.f. If you need more precision that that, you probably
need to stick
>to dedicated apps.
>
>Alan.
>
>
>.
>

Hi Chenj / Chengj

"chengj" <anonymous@discussions.microsoft.com> wrote in message
news:0aa301c3a9cd$39b63c60$a401280a@phx.gbl...
>
> hi
> I don't know what you said.
> would you told me more!
>
> Thank you !
>

Which part did you not understand?

Essentially, I am saying that excel is not a high precision
mathematical application.

If you need that level of precision, I think you'll need to use a
different tool.

Other opinions are welcome!

Alan.