Answered step by step
Verified Expert Solution
Question
1 Approved Answer
the following data show the number of Netflix subscribers worldwide for the years (period ) to (period ) (datawrapper website). The data are in the
the following data show the number of Netflix subscribers worldwide for the years (period ) to (period ) (datawrapper website). The data are in the file NetflixSubscribers. Click on the datafile logo to reference the data. Year Period Subscribers (millions) 2012 1 33.27 2013 2 44.35 2014 3 57.39 2015 4 74.76 2016 5 93.80 2017 6 117.58 a. Choose the correct time series plot. A. B. C. Graph C What type of pattern exists in the data? Upward b. Develop a linear trend equation for this time series (to decimals). 16.779 11.465 c. Develop a quadratic trend equation for this time series (to decimals). 1.5625 5.8416 26.0480 d. Compare the MSE for each model (to decimals). Linear model 22.95 Quadratic model 0.22 Which model appears better according to MSE? Quadratic model e. Use the models developed in parts (b) and (c) to forecast subscribers for (to decimal). Linear model $ 128.9 million Quadratic model $ 143.5 million f. Which of the two forecasts in part (e) would you use? Explain. For the forecast one period ahead, the quadratic model is likely slightly preferred because of its lower MSE
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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