Re: Fit in Excel Mathlink
- To: mathgroup at smc.vnet.net
- Subject: [mg4992] Re: Fit in Excel Mathlink
- From: Harald Berndt <haraldb at nature.berkeley.edu>
- Date: Thu, 17 Oct 1996 00:41:06 -0400
- Organization: University of California, Berkeley
- Sender: owner-wri-mathgroup at wolfram.com
Mark Dowell wrote:
>
> Dear All,
>
> Can anyone hellp I'm trying to fit some data under Excel with the Mathlink
> addon the fitting equation is
>
> y=a(0)*Exp(-a(1)*(x-400))+a(2)
>
> I just need value for best fit in a(0),a(1),a(2). for a given range in Excel
> cells can anyone help with the syntax
Well, the Standard Package "NonlinearFit" is supposed to do it, but I
had very little luck with problems similar to yours. Maybe things will
improve in Version 3.0
Good luck,
--
______________________________________________________________________
Harald Berndt, Ph.D. Research Specialist,
Consultant
Phone: 510-652-5974 FAX: 510-215-4299
______________________________________________________________________
"I am what I am".................................. .Popeye the Sailor
(KRYTEN:.............Are you sure? I always thought it was Descartes!)
(LISTER:.So did I, man! It's so easy to get those two dudes mixed up!)