A stabistical pregram is recommended. Quarterly revenue (5 milions) fer a certain wobute for the fint quarter of 2012 through the first quarter of 2014 are shown below: (a) Construct a time series piot. What type of pattern evists in the data? The time serles plot shows a downward trend. The time series plot shows a horizontal pattem. The time series plot shows a cyclical pattern. The time series plot shows an upward trend. (b) Using excel, develop a linear trend equation for this time series to forecast revenue (in millions of dolars). (Round your numerical values to one decimal place.) rt= (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.) Tt= (d) Compare the MSE for esch model, (Round your answers to one decimal place.) Unear model MSE - Quadratic model MSE = Which model appears better according to MSE? According to MSE, the quadratic model is the better model. Actording to MSE, both models are just as good. According to MSE, the linear modet is the better model. (e) Use the models developed in parts (b) and (c) to forecast revenue (in milions of doliars) for the tenth quarter (Round your answers to the nearest mallion dollars.) Linear model is million Quadratic model 1 million