How do you do multiple regression in excel without using additional tool pack and get value of r square, a & b

Question

I need to know how to do multiple regression using three independent variable , and calculate the value of r square , a, b1, b1, b3 without using data analysis tools , I know how to do it in excel using tools-> data analysis-> regression, however if I do not want to follow this method, how do I go about doing it ?

Answer 1

Get a good book on Statistical Analysis and read the part about multiple regression analysis. Then just start writing equations into the appropriate cells.

You might also want to think about getting some professional help for that masochistic streak in your personality


Doug

Answer 2

Unless you know matrix algebra and even if you do, this is an extremely cumbersome process with more than 2 predictors.