Run > 1 regression at once

[nwb]

Hi,

I'm interested in running more than one regression (note: NOT multiple regression analysis). For instance, I have 1,000 different SKUs that I want to regress against sales forecasts to find a regression equation for each SKU as well as keep some of the information that Excel provides (T stat, R2, etc.). Is there a way to do this in Excel?

 

[mirabeau]

Hi,

I'm interested in running more than one regression (note: NOT multiple regression analysis). For instance, I have 1,000 different SKUs that I want to regress against sales forecasts to find a regression equation for each SKU as well as keep some of the information that Excel provides (T stat, R2, etc.). Is there a way to do this in Excel?

Yes. You can do it in several ways in Excel.

Just how to proceed would depend on your data layout. Also on whether you want to look at each regression equation as an individual stand-alone entity, or use the Arnold Zellner approach http://en.wikipedia.org/wiki/Seemingly_unrelated_regressions of doing them (or any subgroup of them) jointly and thus obtaining improved values for the overall accuracy of the procedure.