Standard Error of Coefficients in Multiple Regression

#1
Hi,

I have built a model in Excel to do Multiple Regression. I am able to correctly calculate the intercept and the regression coefficients but I am having trouble calculating the standard error of the intercept and regression coefficients.

I calculated the intercept and the coefficients by setting up a simultaneous system of linear equations and then used matrix algebra in Excel to solve for the regression coefficients, but I can’t seem to get to the standard errors. I thought the solution would fall out in the matrix solution – am I just not seeing something? I can easily make these calculations for a simple regression with only one independent variable. I also have no problem with the standard error of the estimate for the multiple regression.

Any guidance would be greatly appreciated.

Best regards,

Joe