realtylerdurdon
New Member
- Joined
- Jan 20, 2004
- Messages
- 44
Hi Forum,
I have a long list of variables that looks like this one:
Year;IndustryCode;Sales;EBIT;...
...
...
...
I would like to do simple OLS regressions with LINEST() based on the combination of Year and IndustryCode. For each combination (e.g. Year 1999 and IndustryCode 23) I need a separate regression (all in all over 300 regressions). The number of records for these "blocks" varies and I need a trick to tell the LINEST() to choose the right arrays.
Any ideas?
Thanks a lot in advance!
Michael
I have a long list of variables that looks like this one:
Year;IndustryCode;Sales;EBIT;...
...
...
...
I would like to do simple OLS regressions with LINEST() based on the combination of Year and IndustryCode. For each combination (e.g. Year 1999 and IndustryCode 23) I need a separate regression (all in all over 300 regressions). The number of records for these "blocks" varies and I need a trick to tell the LINEST() to choose the right arrays.
Any ideas?
Thanks a lot in advance!
Michael