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 using Y=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