extrapolate a data series (2000 SR1)

Topic

New Reply

I’d like to know how to extrapolate a data series. E.g., given a column of weekly POS sales over the past 52 weeks, what are the projected weekly sales for the next 13 weeks.

Reply | Quote

Replies

This depends on the pattern of the data series. If the sales are seasonal or not, or if other factors affect sales.

If sales are roughly the same week on week, then you can average out the calculation, say (sum([sales])/52) * 13 = that expected for next 13 weeks.

If the pattern of sales varies week on week then you will need to work out what the pattern of sales is.

Easiest way to spot a pattern is to do a graph showing week on week sales.

Reply | Quote

Thanks! I’ll let my customer know.

Reply | Quote

Bill,

This thread might be interesting for you. It explains how you can use the forecasting tool in Excel, once you’ve built a model.

Reply | Quote