5. The number of cans of soft drinks sold in a machine each week is recorded below: WEEKLY PERIOD 1 2 3 4 5 6 7 8 Soft drinks sold 122 85 92 98 110 108 115 102 WEEKLY PERIOD 9 10 11 12 13 14 15 16 Soft drinks sold 95 98 105 125 85 106 140 84 WEEKLY PERIOD 17 18 19 20 21 22 23 24 Soft drinks sold 92 85 78 105 E 111 152 140 108 a. Using Excel, develop forecasts for periods 1 to 24, using a trend line. b. Calculate the MSE and MAD for your model. c. Calculate an R statistic and interpret it.