Quarterly revenue ($ millions) for Twitter for the first quarter of 2012 through the first quarter of 2014 are shown bel
Posted: Wed May 11, 2022 2:39 pm
Quarterly revenue ($ millions) for Twitter for the first quarter
of 2012 through the first quarter of 2014 are shown below
(adexchange.com, April, 2015):
a. Which of the following is a time series
plot?
Quarter Revenue ($ millions) 1 vouw 54 68 82 112 114 139 169 243 250
time series plot #b- What type of pattern exists in the data? Upward b. Using Minitab or Excel, develop a linear trend equation for this time series (to 3 decimals if necessary). y = 25.167 X + 10.944 c. Using Minitab or Excel, develop a quadratic trend equation for this time series (to 4 decimals if necessary). y = 2.3095 x²+ 2.0714 X + 53.286 d. Compare the MSE for each model (to 3 decimals). Linear model 317.765 Quadratic model 135.228 Which model appears better according to MSE? Quadratic model 4 e. Use the models developed in parts (b) and (c) to forecast revenue for the tenth quarter (to 3 decimals). Linear model $ 262.614 million Quadratic model $ 304.869 million f. Which of the two forecasts in part (e) would you use? Explain. The input in the box below will not be graded, but may be reviewed and considered by your instructor. quadratic model because error is less.
of 2012 through the first quarter of 2014 are shown below
(adexchange.com, April, 2015):
- Quarterly Revenue Millions For Twitter For The First Quarter Of 2012 Through The First Quarter Of 2014 Are Shown Bel 1 (49.54 KiB) Viewed 26 times
plot?
- Quarterly Revenue Millions For Twitter For The First Quarter Of 2012 Through The First Quarter Of 2014 Are Shown Bel 2 (218.03 KiB) Viewed 26 times
time series plot #b- What type of pattern exists in the data? Upward b. Using Minitab or Excel, develop a linear trend equation for this time series (to 3 decimals if necessary). y = 25.167 X + 10.944 c. Using Minitab or Excel, develop a quadratic trend equation for this time series (to 4 decimals if necessary). y = 2.3095 x²+ 2.0714 X + 53.286 d. Compare the MSE for each model (to 3 decimals). Linear model 317.765 Quadratic model 135.228 Which model appears better according to MSE? Quadratic model 4 e. Use the models developed in parts (b) and (c) to forecast revenue for the tenth quarter (to 3 decimals). Linear model $ 262.614 million Quadratic model $ 304.869 million f. Which of the two forecasts in part (e) would you use? Explain. The input in the box below will not be graded, but may be reviewed and considered by your instructor. quadratic model because error is less.