[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

*Subject*: Re: Equivalent of EXCEL LINEST function?*From*: Craig Markwardt <craigmnet(at)cow.physics.wisc.edu>*Date*: 23 Apr 2001 15:46:55 -0500*Newsgroups*: comp.lang.idl-pvwave*Organization*: U. Wisc. Madison Physics -- Compact Objects*References*: <3ADEF294.4DDF7DAF@bigelow.org> <3ADF3986.770EE726@indra.com> <3AE07A78.8C13480D@bigelow.org> <onsnj33xiq.fsf@cow.physics.wisc.edu> <3AE48C14.12F7A917@bigelow.org>*Reply-To*: craigmnet(at)cow.physics.wisc.edu*Xref*: news.doit.wisc.edu comp.lang.idl-pvwave:24657

Bruce Bowler <bbowler@bigelow.org> writes: > I wanted to regress 2 vectors so I go into the online help in 5.3 (which > is what I'm using) and type regress. Up pops the REGRESS function. No > where does the REGRESS help mention LINFIT or CORRELATE. I agree, I was a little surprised that the REGRESS docs didn't mention LINFIT, since LINFIT is the degenerate case of one dimension. > After "rolling my own", I find them and they do (almost) what I want. > They don't (like LINEST in excel, or "my own") provide standard errors > of the coefficents, the constant and Y estimate and a few other little > bits. Umm, here I think I have to disagree. The SIGMA keyword provides the errors of the coefficients, as my example showed. The R^2 constant is directly from CORRELATE, so I'm not sure your complaint here. And finally, YFIT = A*X + B Sometimes things are simple enough that having a canned procedure to do them is overkill. :-) Craig -- -------------------------------------------------------------------------- Craig B. Markwardt, Ph.D. EMAIL: craigmnet@cow.physics.wisc.edu Astrophysics, IDL, Finance, Derivatives | Remove "net" for better response --------------------------------------------------------------------------

**References**:**Equivalent of EXCEL LINEST function?***From:*Bruce Bowler

**Re: Equivalent of EXCEL LINEST function?***From:*Med Bennett

**Re: Equivalent of EXCEL LINEST function?***From:*Bruce Bowler

**Re: Equivalent of EXCEL LINEST function?***From:*Craig Markwardt

**Re: Equivalent of EXCEL LINEST function?***From:*Bruce Bowler

- Prev by Date:
**Re: Equivalent of EXCEL LINEST function?** - Next by Date:
**Re: fastest operations/fctns.** - Prev by thread:
**Re: Equivalent of EXCEL LINEST function?** - Next by thread:
**RE: 2D optimization for registration** - Index(es):