Xref: utzoo comp.os.os2.apps:55 comp.os.msdos.apps:729 comp.windows.ms:7769
Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!usc!zaphod.mps.ohio-state.edu!van-bc!ubc-cs!alberta!herald.usask.ca!news
From: reeves@dvinci (Malcolm Reeves)
Newsgroups: comp.os.os2.apps,comp.os.msdos.apps,comp.windows.ms
Subject: Re: Excel:1. Regression? 2.Memory? 3. DesqView?
Message-ID: <1990Dec8.171008.5429@herald.usask.ca>
Date: 8 Dec 90 17:10:08 GMT
References: <7973.275c1a76@uwovax.uwo.ca>
Sender: news@herald.usask.ca (USENET News System)
Reply-To: reeves@dvinci
Organization: University of Saskatchewan
Lines: 21

From article <7973.275c1a76@uwovax.uwo.ca>, by jansson@uwovax.uwo.ca:
> I am trying to estimate a regression equation using Excel.  According to
> the manual I should use the function LINEST and given the data arrays
> Excel should compute the slopes and the intercept for me.  The problem is
> that the only output I get is one of the slopes.  I would like to get all
> the information for the equation.  How do I go about getting it?

You've just discovered the problems associated with using "canned" software.
It's easy to compute a least-squares regression using the arithmetic in a
spreadsheet (I don't know excel but I can do it in Lotus, Supercalc, Quattro
etc) then you can recover the full equation and standard errors of estimate
for the coefficients. Another problem is that spreadsheets do not check if
the data is suitable for linear least squares regression nor do they provide
other norms or non-parametric alternatives when the point distribution is
obviously not "normal".

This may not help much but the spreadsheet arithmetic for least-squares
regression is easy and you can have any information you need if you do it
yourself :-)