Re: [idemallie] BASE 2000 Extrapolation
I haven't looked at the spreadsheet. I was just replying to your general statement about his process. That said, what you're describing is the gist of econometric work.
You basically come up with a polynomial function using the variables that you think are impacting the data points. The problem is, you don't know exactly how to weight each of the variables to best fit them to the trend line.
So you'd have something like this:
.25(A) + .25(B) + .25(C) + .25(D) = Y
Where A, B, C, and D all represent the relevant variables. Your weightings (in this case evenly weighted at .25 each) can be adjusted to best fit the data and, theoretically, create hypothetical data points which should fit the incoming future data.
That said, prognostication is a tough business and most of the time reality will deviate from our nice, clean, trend lines.
I wasn't trying to be sarcastic or shitty, for what it's worth. You seem to be a pretty bright kid. I was a young genius in college too once, ya know.
*Edited for grammar.