Please assist with questions 14 & 15.

Here is the excel for # 14: https://docs.google.com/spreadsheets/d/1p8Hyo8lpVripy6raJHvqJ_k3WG56h7phHwhUtj6YG6g/edit?usp=sharing

14 Daily Spot Exchange Rate, U.S. Dollars per Pound Sterling Date Rate Date Rate Date Rate 1-Apr-04 1. 8584 13-Apr-04 1. 7860 23-Apr-04 1. 7874 2 2-Apr-04 1. 8363 14-Apr-04 1. 7752 26-Apr-04 1. 7857 5-Apr-04 1. 8140 15-Apr-04 1. 7785 27-Apr-04 1. 7925 points 6-Apr-04 1. 8474 16-Apr-04 1. 8104 28-Apr-04 1. 7720 7-Apr-04 1. 8410 19-Apr-04 1. 8255 29-Apr-04 1. 7656 8-Apr-04 1. 8525 20-Apr-04 1. 7816 30-Apr-04 1. 7744 9-Apr-04 1. 8422 21-Apr-04 1. 7620 3-May-04 1. 7720 12-Apr-04 1. 8558 22-Apr-04 1. 7794 4-May-04 1. 7507 5-May-04 1. 7732 13-May-04 1. 7754 21-May-04 1. 7880 6-May-04 1. 7641 14-May-04 1. 7692 24-May-04 1. 7808 7-May-04 1. 7942 17-May-04 1. 7595 25-May-04 1. 7535 10-May-04 1. 7693 18-May-04 1. 7695 26-May-04 1. 8542 11-May-04 1. 7644 19-May-04 1. 7727 27-May-04 1. 7769 12-May-04 1. 7743 20-May-04 1. 7610 28-May-04 1. 7730 Click here for the Excel Data File (b) Perform simple exponential smoothing (using Excel's Data Analysis or other software such as Minitab) using a = .05, .10, .20, and .50. The degree of smoothing |varies @ dramatically as a is increased. (c) Which value of a do you prefer? (Round your answers to 2 decimal places.) a =15 Coca-cola Revenues ($ millions ) , 2005-2010 Quarter 2005 2006 2007 2008 2009 2010 Qtr] 5, 206 5,226 6, 103 7,379 9 , 046 7, 169 7,525 Qtr2 6,310 6, 476 7,733 8, 267 8, 674 Qtr3 6, 037 6, 454 7, 690 8,393 8, 044 8, 426 2 Qtr4 5, 551 5,932 7,331 7, 126 7,510 10, 494 points Skipped Click here for the Excel Data File (a-1) Use MegaStat or Minitab to deseasonalize Coca-cola's quarterly data. (Round your answers to 3 decimal places.) 2 eBook 2005 2006 2007 References 2008 2009 2010 mean (a-2) State the adjusted four quarterly indexes. (Round your answers to 3 decimal places.) Q1 02 Q3 04 (a-3) What is the trend model for the deseasonalized time series? (Round your answers to 2 decimal places.) yt=* + + [ (b) 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.) yt = Q2+ Q3 (c) Use the regression equation to make a prediction for each quarter in 2011. (Enter your answers in millions rounded to 3 decimal places.) Quarter Predicted Q1 Q2 Q3 04