Coca-cola Revenues ($ millions ), 2014 to 2019 Quarter 2014 2015 2016 2017 2018 2019 Quarter1 10.58 10.71 10.28 9. 12 7.63 8. 02 Quarter2 12.57 12. 16 11. 54 9.70 9.42 10.00 Quarter3 11.98 11.43 10.63 9.08 8. 78 9.51 Quarter4 10.87 10.00 9.41 7.51 5.36 9. 07 Click here for the Excel Data File (a-1) Use MegaStat or Minitab or R to deseasonalize the quarterly data on Coca-Cola's revenues and calculate seasonal indexes. (Round your answers to 3 decimal places.) 2 3 4 2014 2015 2016 2017 2018 2019 meanla-Z} State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) [a-3} What is the trend model for the deseasonalized time series? [Round your answers to 2 decimal places.} lc-'IJ State the model found when performing a regression using seasonal binaries. [A negative value should be indicated by a minus ((-1) State the model found when performing a regression using seasonal binaries. (A negative value should be indicated by a minus sign. Round your answers 1.0 4 decimal places.) -----_____E [IE-2] Use the regression equation to make a prediction for each quarter in 2020. {Enter your answers in millions rounded to 3 decimal places.}