Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

With the instructions and data set please solve the problem The following data describes sales for AMAZON during 2017 - 2019: Your job is to

With the instructions and data set please solve the problem image text in transcribed
image text in transcribed
The following data describes sales for AMAZON during 2017 - 2019: Your job is to provide forecasts for 2020; The data Unit: SMillions Your answers should be to 3 decimal places; Take especial care in making sure you have entered the data correctly. Otherwise your results will be graded incorrectly. AMAZON Data set: SM Year Quarter Period AMAZON 2017 Q1 $ 132 2017 Q2 2 $ 12.8 2017 Q3 3 $ 13.8 2017 Q4 4 $ 212 2018 Q1 5 $ 16.0 2018 Q2 6 $ 15.7 2018 Q3 7 $ 17.0 2018 Q4 8 $ 25.6 2019 Q1 9 $ 197 2019 Q2 10 $ 19.3 2019 Q3 11 $ 20.5 2019 04 12 $ 29.3 01 02 03 Forecasting Method 4 point moving average Simple Exponential Smoothing (use alpha=0.1) Simple Linear Regression (Trend Projection) Trend and Seasonal Method Calculating Forecasting Errors MAD RSQ 4 pt MA Exp som Trend (Linear Regression) Trend and Seasonal 01 02 Q3 04 What is the Scaled Seasonal Index Find the optimal alpha value in the exp smoothing method The following data describes sales for AMAZON during 2017 - 2019: Your job is to provide forecasts for 2020; The data Unit: SMillions Your answers should be to 3 decimal places; Take especial care in making sure you have entered the data correctly. Otherwise your results will be graded incorrectly. AMAZON Data set: SM Year Quarter Period AMAZON 2017 Q1 $ 132 2017 Q2 2 $ 12.8 2017 Q3 3 $ 13.8 2017 Q4 4 $ 212 2018 Q1 5 $ 16.0 2018 Q2 6 $ 15.7 2018 Q3 7 $ 17.0 2018 Q4 8 $ 25.6 2019 Q1 9 $ 197 2019 Q2 10 $ 19.3 2019 Q3 11 $ 20.5 2019 04 12 $ 29.3 01 02 03 Forecasting Method 4 point moving average Simple Exponential Smoothing (use alpha=0.1) Simple Linear Regression (Trend Projection) Trend and Seasonal Method Calculating Forecasting Errors MAD RSQ 4 pt MA Exp som Trend (Linear Regression) Trend and Seasonal 01 02 Q3 04 What is the Scaled Seasonal Index Find the optimal alpha value in the exp smoothing method

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions