Hi All,

My first post so please be gentle .

I am trying to calculate a multiple linear regression, without using the Excel functions I normally rely on (LINEST).

I have the math equation to calculate slope and intercept, so I can forecast for Y usingY=a+bx,where a is the intercept and b is the slope.

I would like to produce the same forecast of Y, but using two variables for x. I'm not sure how to change the equation to include another x.

Then I think I could use the output to calculate Y using both sets of X values like below?

Y = a + b1*X1 + b2*X2

......Ok, shoot me down now