S
Steve
Hi,
No one has answered my previous post so I am rephrasing in case I was unclear in my question.
i have 18 months of historical data (2003 and 2004) and I have a target for full-year 2004. The full-year target is an input.
Does anyone have a formula to fill in the remaining 6 months, so the 12 months of 2004 equal my target for 2004?
Another way to put my question: is there a way to use the trend function to look at the last 18 months of data and extrapolate the next six months, while equaling my full year target?
I came up with a solution (see link below), but I am hoping someone more familar with statistics could come up with a more elegant solution.
If I had to describe the historical data, it is seasonal, cyclical, and with slight growth.
http://groups.google.com/[email protected]&rnum=1
Thanks!
No one has answered my previous post so I am rephrasing in case I was unclear in my question.
i have 18 months of historical data (2003 and 2004) and I have a target for full-year 2004. The full-year target is an input.
Does anyone have a formula to fill in the remaining 6 months, so the 12 months of 2004 equal my target for 2004?
Another way to put my question: is there a way to use the trend function to look at the last 18 months of data and extrapolate the next six months, while equaling my full year target?
I came up with a solution (see link below), but I am hoping someone more familar with statistics could come up with a more elegant solution.
If I had to describe the historical data, it is seasonal, cyclical, and with slight growth.
http://groups.google.com/[email protected]&rnum=1
Thanks!