[R] Computational differences in R vs Excel
Carl Witthoft
carl at witthoft.com
Tue Nov 19 13:19:35 CET 2013
There are several problems here. The first is that it's rather unlikely you
really need 10-place accuracy to fit your data. This suggests you may be
doing something inappropriate such as fitting the wrong function or trying
to extrapolate. Since you haven't explained what "process" you have that
isn't "converging," since clearly the fitting algorithms themselves have
converged.
Next, you need to understand that both Excel and R have default convergence
tolerances which may not be identical (as well as default iteration limits).
And finally, of course, there's the question of machine precision limits,
although that is less likely to be a culprit in this instance.
Soham wrote
> Hello,
> I am working on fitting a non-linear time series. The results which I
> found using R and Excel are not quite same up to 10-12 places after
> decimal (i require high precision because otherwise the process might not
> converge)
> For example, i am performing this simple arithmetic:
> 23-(1.346493052*16)+(.663965156*11)+(.008569426*5)-15.23480728
>
> R gives the result --> -6.432232271
> Excel gives the result ---> -6.432232266
>
> The difference is negligible for all practical purposes but it leads to
> entirely different outcomes for me. I read some of the materials available
> online but none were of any help. What is the difference which prompts
> such different results? Is there anything that can be used to solve this
> problem ?
>
> Please give suggestion if you can. Thanks
--
View this message in context: http://r.789695.n4.nabble.com/Computational-differences-in-R-vs-Excel-tp4680726p4680730.html
Sent from the R help mailing list archive at Nabble.com.
More information about the R-help
mailing list