Answered step by step
Verified Expert Solution
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 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
With the instructions and data set please solve the problem
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started