Simple moving averages are easily implemented in Excel. Figure 5 shows the Format Trendline dialog box in which you can insert a moving average forecast and include more periods if necessary.
Your client, Dave’s BBQ, a local independent restaurant, is interested in determining the effect on sales revenue of certain advertising strategies. Dave has weekly data on advertising dollars spent ...