Question: 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

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

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

Year Population1960 92.501961 94.941962 95.831963 96.811964 97.831965 98.881966 99.791967 100.731968 101.061969 103.171970104.351971 105.701972 107.191973 108.081974 110.161975 111.941976 112.771977 113.861978 114.901979 115.871980 116.781981 117.651982

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!