Multiple Regression - How to

  • Thread starter Thread starter WA
  • Start date Start date
W

WA

Hello,

I would like to perform a multiple regression using 2 independent variables.
How do I go about doing so if I am using Excel 2003?

Thanks for your assistance,

WA
 
The LINEST function only gives me an output of one number. If I want all of
the stats, shouldn't I use Tools>Data Analysis>Regression?
 
LINEST must be array entered into a range of cells. Select a range of
cells large enough to contain all the values returned by LINEST, type
the formula, and press CTRL SHIFT ENTER rather than just ENTER.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Ok got it - Thanks for your help.

Chip Pearson said:
LINEST must be array entered into a range of cells. Select a range of
cells large enough to contain all the values returned by LINEST, type
the formula, and press CTRL SHIFT ENTER rather than just ENTER.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
Click to expand...
 
Back
Top