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.

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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!