BUSN 278 Week 1 Assignment Help | Devry University
- Devry University / BUSN 278
- 10 Mar 2021
- Price: $8
- Accounting & Economics Assignment Help / Finance
BUSN 278 Week 1 Assignment Help | Devry University
Week 1: Lab Assignment
Requirements:
1.
Moving Averages. Use the below actual
sales to calculate a three-month moving average which will be
used as the forecast for next periods (chapter 14, text). Your moving average
will begin with month 4 and should demonstrate a forecast for month 13. Watch
the tutorials indented beneath this lab assignment for guidance. Also note that
there is a spreadsheet as well that you can use if it helps. It is the same
spreadsheet used in the tutorials.
2.
Exponential Smoothing. Use the same
data to forecast sales for the next periods with α=.40 (chapter 15, text).
Watch the tutorial indented beneath this lab assignment for guidance.
3.
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 |
USA 
India