Forecasting

**froggeja** · 03-19-2009, 05:15 PM

I'm trying to forecast values for B48:B56. Charted the data and a polynomial 6th order fits best. Known values in B2:B47.

Can anyone suggest the right approach / formula to accurately project forward?

Thanks
Jason

**shg** · 03-19-2009, 05:24 PM

First, there's no polynomial fit to the data in the workbook you posted.

Second, what makes you think a polynomial fit is appropriate?

**froggeja** · 03-19-2009, 05:30 PM

Thanks for your speedy help!

I didn't post the full spreadsheet due to file size. Here's the chart - not a great R2 value - but the best I could get....

Your guidance would be invaluable. Thanks

Jason

**shg** · 03-19-2009, 06:18 PM

Anything to do with dollars (prices, sales, ...) should almost always have an exponential fit. The attachment shows extrapolations using both polynomial and exponential fits.

**froggeja** · 03-19-2009, 06:26 PM

Hey - thanks. This is great - much appreciated.

**shg** · 03-19-2009, 06:36 PM

You’re welcome. Would you please mark the thread as Solved?

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes