Question: Need help with this question. A statistical program is recommended. Quarterly revenue ($ millions) for a certain website for the first quarter of 2012 through
Need help with this question.


A statistical program is recommended. Quarterly revenue ($ millions) for a certain website for the first quarter of 2012 through the first quarter of 2014 are shown below. Quarter Revenue ($ millions) 53 2 68 3 81 4 113 5 115 6 140 7 170 8 242 9 251(b) Using Excel, develop a linear trend equation for this time series to forecast revenue (in millions of dollars). (Round your numerical values to one decimal place.) T. = 10.4 + 25.3t (c) Using Excel, develop a quadratic trend equation for this time series to forecast revenue (in millions of dollars). (Round your numerical values to one decimal place.) T. = 51.5 + 2.8t + 2.2+2 (d) Compare the MSE for each model. (Round your answers to one decimal place.) Linear model MSE = 382.3 Quadratic model MSE = 187.6 Which model appears better according to MSE? O According to MSE, both models are just as good. O According to MSE, the quadratic model is the better model. According to MSE, the linear model is the better model. (e) Use the models developed in parts (b) and (c) to forecast revenue (in millions of dollars) for the tenth quarter. (Round your answers to the nearest million dollars.) Linear model $ 263.4 million Quadratic model $ 304.7 million
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
