Homework answers / question archive / Moving Averages

Moving Averages

Economics

Share With

1. Moving Averages. Use the below actual sales to calculate a three-year average which will be used as the forecast for next periods (chapter 14, text).
2. Exponential Smoothing. Use the same data to forecast sales for the next periods with α=.40 (chapter 15, text).
3. Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 16, text).