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.)

(a-2)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.)

(c-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 to 4 decimal places.)

(c-2)Use the regression equation to make a prediction for each quarter in 2020.(Enter your answers in millions rounded to 3 decimal places.)