Xref: utzoo comp.os.os2.apps:68 comp.os.msdos.apps:760 comp.windows.ms:7950
Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!world!boris
From: boris@world.std.com (Boris Levitin)
Newsgroups: comp.os.os2.apps,comp.os.msdos.apps,comp.windows.ms
Subject: Re: Excel:1. Regression? 2.Memory? 3. DesqView?
Message-ID: <1990Dec16.084609.18842@world.std.com>
Date: 16 Dec 90 08:46:09 GMT
References: <7973.275c1a76@uwovax.uwo.ca>
Organization: The World @ Software Tool & Die
Lines: 12

jansson@uwovax.uwo.ca writes:

>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?

LINEST returns a horizontal array of two parameters, the first of which
is the slope and the second - the intercept.  You may access each by
using the INDEX function, so that the slope becomes =INDEX(LINEST(range),1)
and the intercept =INDEX(LINEST(range),2).