Xref: utzoo comp.os.os2.apps:52 comp.os.msdos.apps:709 comp.windows.ms:7709
Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!apple!portal!cup.portal.com!Patrick_Lynn2_McCurdy
From: Patrick_Lynn2_McCurdy@cup.portal.com
Newsgroups: comp.os.os2.apps,comp.os.msdos.apps,comp.windows.ms
Subject: Re: Excel:1. Regression?
Message-ID: <36580@cup.portal.com>
Date: 5 Dec 90 18:03:42 GMT
References: <7973.275c1a76@uwovax.uwo.ca>
Distribution: usa
Organization: The Portal System (TM)
Lines: 12


	I recently had the pleasure of trying to create a regression model
Excel.  I don't have the Excel manual, and was trying to figure it all out
from my Cybex book on Excel.

	LINEST and LOGEST were so confusing to me that I did this (I didn't
have that many data points):  I put all the data points into a statistical 
package and got the slope and intercept, I then created a formula in the 
second row of the array making it equal to (mX + b.  You can put in a bunch
of predictors into the first row of your array and then copy he formula 
across the second row.  You are then able to plot the info using file_new_
chart.