Hello, how in Excel can I calculate the regression coefficients and the overall correlation for 1 time series against 2 independent time series? I am not looking for a ready add-in, but for the formulae so that I can code it up myself. Many thanks.
2007-02-18 19:06:08 · 2 answers · asked by Anonymous in Science & Mathematics ➔ Engineering
The multiple regression code is many times more complex than the simple linear regression code. Microsoft Excel already has multiple regression built into it. Check out the first link.
If you really want to do it yourself if Microsoft Excel VBA, then check out the second link.
2007-02-18 19:20:53 · answer #1 · answered by Skeptic 7 · 0⤊ 0⤋
Not sure how to do it in excel, but matlab (or the free Octave) can do it trivially using the '\' operator, e.g. if A = B * M, then M = B\A, where A is your time series, B is a matrix consisting of your 2 independent time series, and M is the coefficients.
Hope this helps.
2007-02-18 19:14:26 · answer #2 · answered by Anonymous · 0⤊ 0⤋