Economics Homework Help
Economics Homework Help. DVU Moving Averages Exponential Smoothing & Regression Analysis Excel Worksheet
Requirements:
- 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).
- 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 |
"Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET15 to claim 15% Discount This Month!!"
