IUBio

EXCEL - 2nd order fit question

wgschech at med.uni-tuebingen.de wgschech at med.uni-tuebingen.de
Wed Jun 3 06:49:38 EST 1998


hi all,

when calculating regressions with excel, I sometimes use a polynomic
fit. It's easy to display the corresponding function in the graph
window using the TrendLine option. But then I have to read the
coefficients and type them in manually.

Is there a function for directly making a second order fit or getting
access to the coefficients? RGP doesn't work since it makes only
linear regressions.

I want to avoid programming my own viasual basic routines for that
purpose.

Any ideas?

All input is welcome.
Wolfgang

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/   Now offering spam-free web-based newsreading




More information about the Bio-soft mailing list

Send comments to us at biosci-help [At] net.bio.net