DS412 MSE Forecasting Paper

User Generated

Ivnartnepvn

Other

DS412

Description

Part A: Calculate the following for the two forecasts:

The MSE for both forecasts. • The MAD for both forecasts. • The MAPE for both forecasts.

Part B: Conduct the following forecasts for periods 2 through 12 as possible:

Naïve • 4-period Moving Average • 3-period Weighted Moving Average where the most recent weight is 0.6 and 2nd most recent is 0.3. • Exponential Smoothing (alpha=0.3)


Unformatted Attachment Preview

DS412 Final Assessment Take-Home (Spring 2019) Instructions (20-points) As you did with the take-home portion of the midterm, you may complete this alone or with members of your team. Whether you work individually or with your group, you will not be graded any differently. This portion is due on the day of the final assessment. If you work with a team, you will only need to turn in one copy. Make sure to list all team members in alphabetic order. Late take-homes will not be accepted. DATASET Period Sales Forecast 1 Forecast 2 1 840 805 805 2 830 815 800 3 815 845 800 4 855 800 835 5 795 780 810 6 845 770 801 7 765 765 780 8 830 785 835 9 820 795 830 10 845 850 855 (10 points) Part A: Calculate the following for the two forecasts above: • • • The MSE for both forecasts. The MAD for both forecasts. The MAPE for both forecasts. (10 points) Part B: Conduct the following forecasts for periods 2 through 12 as possible: • Naïve • 4-period Moving Average • 3-period Weighted Moving Average where the most recent weight is 0.6 and 2nd most recent is 0.3. • Exponential Smoothing (alpha=0.3)
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

The solution is attached.Please, give me feedback.

Period
1
2
3
4
5
6
7
8
9
10

Dataset
Forecast 1
805
815
845
800
780
770
765
785
795
850

Forecast 2
805
800
800
835
810
801
780
835
830
855

Forecast 1
MSE
1,390.00
MAD
30.00
MAPE
3.77%

Forecast 2
536.10
19.90
2.46%

Sales
840
830...


Anonymous
Very useful material for studying!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags