Question #2. Navigate to the sheet titled COCA COLA REVENUES. This data set shows this company's total revenues in a given quarter, between 2005 and 2010. The data set has 3 variables: YEAR = the year; QUARTER = the quarter; & REVENUE (S BILLIONS) = total revenue, in billions. (a) Estimate a seasonally-adjusted linear forecasting model for revenue. Use Q1 as the omitted category. Fill in the forecasting equation below. Round the coefficients to 3 decimal places. T + Q2 + Q3 + Q4 yt (b) Forecast revenue for all 4 quarters in 2011. Round the forecasts to 3 decimal places. Year Q1 Q2 Q3 Q4 2011 Quarter 1 2 3 4 w N 1 2 3 4 1 2 Year 2005 2005 2005 2005 2006 2006 2006 2006 2007 2007 2007 2007 2008 2008 2008 2008 2009 2009 2009 2009 2010 2010 3 4 Revenue ($ billions) 5.206 6.310 6.037 5.551 5.226 6.476 6.454 5.932 6.103 7.733 7.690 7.331 7.379 9.046 8.393 7.126 7.169 8.267 8.044 7.510 7.525 8.674 1 2 3 4 1 2 3 4 1 2 2010 3 8.426 10.494 2010 4