Regression Analysis

[LCC]

Hello! Friends

Can the worksheet functions SLOPE & INTERCEPT be used on
MULTIPLE Regression?

If so, how to obtain the slopes for the multi x-variables?
I used CTRL-SHIFT-ENTER, it doesn't work?

Thanks.

LCC

 

[Bernard Liengme]

Use the LINEST function
If you want to do a polynomial fit see www.stfx.ca/people/blienge/ExcelTips

best wishes