🚀 go-pugleaf

In article <3360@ariel.its.unimelb.EDU.AU> anne@ariel.its.unimelb.EDU.AU (Anne Williamson) writes:
>From: anne@ariel.its.unimelb.EDU.AU (Anne Williamson)
>Subject: Excel 4.0 features?
>Date: 14 Oct 92 02:45:05 GMT
>Do any of you know if MS Excel/Windows 4.0 does linear/non-linear 
>regression or curve fitting?  If it doesn't, do any of you know of a 
>package that does?
>
>Thanks for any light you may shed on the subject
>
>Anne
Excel 4.0 can do Linear regression, but it does not list non-linear 
regression or curve fitting in their list of Analysis Tools.  A package that 
you might want to try is Stanford Graphics v2.0 for Windows, made by
 3D Vision
 2780 Skypark Dr.
 Torrance, CA  90505
 800-729-4723; 310-325-1339
 FAX: 310-325-1505

This is a Data Analysis package and Presentation Manager for Windows that is 
packed with alot of functions including curve fitting across 2 and 3 
dimensions.  This also has alot of spreadsheet capabilities.  Excel 4.0 is a 
great package if you need to do alot of spreadsheet work, but I don't think 
all of the functions are there that you would need.  Hope this helps.

James King
Naval Research Lab
Washington DC

In article <james.8.719150890@library.nrl.navy.mil> james@library.nrl.navy.mil (James King) writes:
>In article <3360@ariel.its.unimelb.EDU.AU> anne@ariel.its.unimelb.EDU.AU (Anne Williamson) writes:
>>Do any of you know if MS Excel/Windows 4.0 does linear/non-linear 
>>regression or curve fitting?  If it doesn't, do any of you know of a 
>>package that does?
>
>Excel 4.0 can do Linear regression, but it does not list non-linear 
>regression or curve fitting in their list of Analysis Tools.  

Excel does offer exponential curve fitting using the LOGEST() function.
See the Excel function reference manual for details.  If you need
logarithmic or power curve fitting, then Excel can't help.

Another package that provides a full menu of curve fitting tools is
Harvard Graphics.  The curve fitting is, however, limited to  two
dimensions.


Tom McGuigan

 In <james.8.719150890@library.nrl.navy.mil> 
 james@library.nrl.navy.mil (James King) writes : 
]Excel 4.0 can do Linear regression, but it does not list non-linear 
]regression or curve fitting in their list of Analysis Tools.

     In addition to LINEST() function Excel has also a LOGEST() function,
     which will give regression values for an exponential function. That
     is at least some kind of a non-linear regeression.


-- 
(   Pekka Makinen, Dept. of Med. Chem., University of Helsinki, Finland   )
(pemakine@cc.helsinki.fi pemakine@plootu.helsinki.fi pemakine@finuh.bitnet)
(        No opinions - no disclaimer - no money - no fun. Fiat lux.       )

In article <1992Oct15.191726.22860@klaava.Helsinki.FI> pemakine@klaava.Helsinki.FI (Pekka Makinen) writes:
>     In addition to LINEST() function Excel has also a LOGEST() function,
>     which will give regression values for an exponential function. That
>     is at least some kind of a non-linear regeression.

Perhaps in one sense of the term "non-liner," however they certainly use
the same algorithm as for y=ax+b, except that they fit to 
ln(y) = ln(b) + x ln(a) which can be rewritten as y' = a'x + b'.  Therefore,
this is really just a special case of linear regression.

What I would consider non-linear regression would be something like fitting:

  y = a sin(b x + c)

I know of no way to linearize this.  This requires a different and more
complicated approach then linear regression.

Jess Holle