Please copy and paste into excel. Thank you for your help!

Year Population

1960 92.50

1961 94.94

1962 95.83

1963 96.81

1964 97.83

1965 98.88

1966 99.79

1967 100.73

1968 101.06

1969 103.17

1970 104.35

1971 105.70

1972 107.19

1973 108.08

1974 110.16

1975 111.94

1976 112.77

1977 113.86

1978 114.90

1979 115.87

1980 116.78

1981 117.65

1982 118.45

1983 119.26

1984 120.02

1985 120.75

1986 121.49

1987 122.09

1988 122.61

1989 123.12

1990 123.54

1991 123.92

1992 124.23

1993 124.54

1994 124.96

1995 125.44

1996 125.76

1997 126.06

1998 126.40

1999 126.63

2000 126.84

2001 127.15

2002 127.45

2003 127.72

2004 127.76

2005 127.77

2006 127.85

2007 128.00

2008 128.06

2009 128.05

2010 128.07

2011 127.83

2012 127.63

2013 127.45

2014 127.28

2015 127.14

2016 126.99

2017 126.79

5 Home - SRL X Mail - Rabs( X B Chapter 12 X Question 5 X Chapter 12 X G Exercise 12- X C The Owner X C The Accomp X + X C ^ ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddle.. Apps M Gmail YouTube S Home - SRU @ Data Mining Flashc... @ Bus Anl 2- Final Exa... Reading list Chapter 12 Assignment i Saved Help Save & Exit Submit You received partial credit in the previous attempt. View previous attempt 5 Exercise 12-35 Static (Using Analytic Solver) The accompanying data file contains annual population data (in millions) for Japan from 1960 to 2017. For cross-validation, let the training and the validation sets comprise the periods from 1960 to 2005 and 2006 to 2017, respectively. points ExpictureClick here for the Excel Data File a. Use the training set to implement the Holt exponential smoothing method with user-supplied (a = 0.20 and B = 0.15), as well as the computer-generated, smoothing parameters, and compute the resulting performance measures for the validation set. (Round final Book answers to 2 decimal places.) Parameters MSE MAD MAPE (%) Print User-supplied 1.37 1.01 0.86 Computer-generated 7.01 2.35 1.85 References b-1. Determine the preferred smoothing parameters for making the forecast? Computer-generated because of the smallest 13 out of 3 performance measures. MC Type here to search Omg 5:03 PM 80OF 7/19/2021 FE5 Home - SRL X Mail - Rabs( X B Chapter 12 X Question 5 X Chapter 12 X G Exercise 12- X C The Owner X C The Accomp X + X C ^ ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252FIms.mheducation.com%252Fmghmiddle. Apps M Gmail YouTube Home - SRU @ Data Mining Flashc... @ Bus Anl 2- Final Exa... Reading list Chapter 12 Assignment i Saved Help Save & Exit Submit You received partial credit in the previous attempt. View previous attempt 5 Computer-generated because of the smallest 3 out of 3 performance measures. 1 points Book Print n References b-2. Reestimate the preferred model with the entire data set to forecast the population in Japan for 2018 (in millions). (Round final answers to 2 decimal places.) Population in Japan for 2018 128.66 MC Type here to search Omg 5:04 PM 80OF 7/19/2021 FE