WEEK 1: LAB ASSIGNMENT:
Requirements:
- Moving Averages.Use the below actual sales to calculate a three-month average which will be used as the forecast for next periods (chapter 14, text).
- Exponential Smoothing.Use the same data to forecast sales for the next periods with α=.40 (chapter 15, text).
- Regression Analysis on Excel. Draw a scatter graph from Insert/Graph/Scatter graph selections in Excel (chapter 16, text).
| Month | Actual Sales |
| 1 | 3050 |
| 2 | 2980 |
| 3 | 3670 |
| 4 | 2910 |
| 5 | 3340 |
| 6 | 4060 |
| 7 | 4750 |
| 8 | 5510 |
| 9 | 5280 |
| 10 | 5504 |
| 11 | 5810 |
| 12 | 6100 |
RUBRIC
Some Rubric
| Some Rubric | ||||||
| Criteria | Ratings | Pts | ||||
| This criterion is linked to a Learning Outcome. Accurately demonstrates how to calculate a moving average |
|
10.0 pts | ||||
| This criterion is linked to a Learning Outcome. Accurately demonstrates how to calculate exponential smoothing |
|
10.0 pts | ||||
| This criterion is linked to a Learning Outcome. Accurately demonstrates how to calculate and graph a regression in Excel |
|
10.0 pts | ||||
| Total Points: 30.0 | ||||||
Top of Form
