calculation of beta's of a multiple regression (rolling window)

Hi everybody,

I have to calculate the intercept and beta's of a multipe regression.
The problem is that it should be in this way that e.g. intercept is in 1 particular cel, beta 1 in another particular cel, ect.
The reason that it should be in this way is because I work with a rolling window method, so every month I should estimate the intercept and beta's.
With the help of a small excel-file it will certainly become clear what I mean. Hopefully it is possible to do so.

Many thanks for your help,
Mathieu

Multiple regression.xlsx

If something is not clear feel free to message me back

Originally Posted by Charles

mathieuv,

Welcome to the forum. Please read the Forum Rules about cross posting.
http://www.excelkey.com/forum/viewtopic.php?f=2&t=757

http://www.mrexcel.com/forum/showthread.php?t=622170

Sorry for this. I will let you know for sure if the problem is solved on another forum.

many thanks for your help