[R] R nls results different from those of Excel ??

Hans W Borchers hwborchers at googlemail.com
Tue Feb 19 15:27:58 CET 2013

Jeff Newmiller <jdnewmil <at> dcn.davis.ca.us> writes:
> Excel definitely does not use nonlinear least squares fitting for power
> curve fitting. It uses linear LS fitting of the logs of x and y. There
> should be no surprise in the OP's observation.

May I be allowed to say that the general comments on MS Excel may be alright,
in this special case they are not.  The Excel Solver -- which is made by an
external company, not MS -- has a good reputation for being fast and accurate.
And it indeed solves least-squares and nonlinear problems better than some of
the solvers available in R.
There is a professional version of this solver, not available from Microsoft,
that could be called excellent. We, and this includes me, should not be too 
arrogant towards the outside, non-R world, the 'barbarians' as the ancient 
Greeks called it.

Hans Werner

> ---------------------------------------------------------------------------
> Jeff Newmiller                        The     .....       .....  Go Live...
> DCN:<jdnewmil <at> dcn.davis.ca.us>   Basics: ##.#.       ##.#.  Live Go...
>                                       Live:   OO#.. Dead: OO#..  Playing
> Research Engineer (Solar/Batteries            O.O#.       #.O#.  with
> /Software/Embedded Controllers)               .OO#.       .OO#.  rocks...1k
> --------------------------------------------------------------------------- 
> Sent from my phone. Please excuse my brevity.

More information about the R-help mailing list