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
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