Multiple Regression - How to


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
 
Ad

Advertisements

W

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

Chip Pearson

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)
 
Ad

Advertisements

W

WA

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top