emergency all one question!!! use excel!!! will rate thimbs up

Description Sales of Iphones at a Best Buy in 2014 are given below: 1 4363 2 3793 3 5208 7367 5 8737 6 8752 7 8398 8 14102 9 16240 10 18650 11 20340 12 17070 Sales of Iphones at a Best Buy for months 1-12 in 2014 are provided in the table below: 1 4363 N 2 3793 3 5208 4 7367 5 8737 6 8752 7 8398 8 14102 9 16240 10 18650 11 20340 12 17070 Use linear regression to obtain the equation whith which to forecast the sales for 2015: Use 2 decimal places. slope 1548.60 intercept 1019.09 R^2 0.90 Provide (round to the nearest whole number) the forecasts for the next four months: 2015 Month 1 2015 Month 2 2015 Month 3 2015 Month 4 Use exponential smoothing (alpha-0.1) to find the forecast (round to nearest whole number) of Iphones for January 2015? Calculate the MAD for the linear regression forecasts (2 decimal places) Calculate the MAD for the exponential smoothing forecast you found (2 decimal places). Which forecast do you prefer? O Exponential Smoothing O Linear Regression O The MAD method. O None of these methods. Why is the method you chose preferred? O Because the MAD is lower. O Because the forecast is better. O Because the MAD is highest. O Because the MAD is closer to zero and the R^2 is close to 1. What is the forecast for Period 25 (use whole numbers)? Description Sales of Iphones at a Best Buy in 2014 are given below: 1 4363 2 3793 3 5208 7367 5 8737 6 8752 7 8398 8 14102 9 16240 10 18650 11 20340 12 17070 Sales of Iphones at a Best Buy for months 1-12 in 2014 are provided in the table below: 1 4363 N 2 3793 3 5208 4 7367 5 8737 6 8752 7 8398 8 14102 9 16240 10 18650 11 20340 12 17070 Use linear regression to obtain the equation whith which to forecast the sales for 2015: Use 2 decimal places. slope 1548.60 intercept 1019.09 R^2 0.90 Provide (round to the nearest whole number) the forecasts for the next four months: 2015 Month 1 2015 Month 2 2015 Month 3 2015 Month 4 Use exponential smoothing (alpha-0.1) to find the forecast (round to nearest whole number) of Iphones for January 2015? Calculate the MAD for the linear regression forecasts (2 decimal places) Calculate the MAD for the exponential smoothing forecast you found (2 decimal places). Which forecast do you prefer? O Exponential Smoothing O Linear Regression O The MAD method. O None of these methods. Why is the method you chose preferred? O Because the MAD is lower. O Because the forecast is better. O Because the MAD is highest. O Because the MAD is closer to zero and the R^2 is close to 1. What is the forecast for Period 25 (use whole numbers)