# Thread: Help calculating standard error of intercept

1. ## Help calculating standard error of intercept

Hi all,
I'm running an equally weighted moving average multiple regression with 10 explanatory variables, and I'm looking at the change in alpha (intercept) and betas over time, including change in statistical significance. Since I need to run many regressions (1000+), i'm using Excel and the Linest function. This gives me the alpha and betas, and I've calculated the standard error of the betas, and thus the confidence intervals. However, I cannot find a formula for calculating the standard error of the intercept in a multiple regression.

I've been told there is a way to find SE(intercept) using the other standard errors that I already have. I've been trying to expand the simple regression formula (image attached) for SE(intercept), but I can't get it quite right (close, but no cigar). Can anyone help me figure this out?

This is the last piece of my model, so all help is greatly appreciated!

2. ## Re: Help calculating standard error of intercept

The standard error for the intercept can be computed as follows:

where the term to the left of the square root sign is the standard error of the regression model.

3. ## Re: Help calculating standard error of intercept

Thank you for replying,
That formula works with only one x in the model. In a model with X1 and X2 in the regression it does not work. Perhaps it is possible to extended it to include X2, however, I've failed in my attempts.

I've attached an attempt to extend the formula to include X2, and a .xlsx with a regression and comparison of the results. The solution may well be easy, however, I can't see it.

4. ## Re: Help calculating standard error of intercept

Okay, I thought that you were working with just one X - based on your original formula you posted with just XBar in it. Anyway, for more than one X it's best to use a Matrix Algebra approach. See the link below that I posted previously (April, 2009) on this topic.

http://www.talkstats.com/showthread....ror+regression

5. ## The Following User Says Thank You to Dragan For This Useful Post:

xepre81 (04-20-2015)

6. ## Re: Help calculating standard error of intercept

The matrix approach seems to be the best approach to this problem. However, I have no experience working with a matrix in Excel. And since I already have the SSR, all the standard errors of the coefficients, and the SSx, is there not a way to use these to find the standard error of the intercept (avoiding the matrix approach)?

I'm hoping there exists a relationship between all the different standard errors.

7. ## Re: Help calculating standard error of intercept

Ok, using the matrix approach in Excel was really easy, and your link made it quite clear. It leaves me with a problem in Excel: I want to repeat the function for 220 rows but the matrix uses 11 rows (and not just one). However, this is a problem for another forum.

Thank you so much for your help

 Tweet

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts