Time series (Australian Population 1960-2017) found on the page 1- For two different parameter sets {(alpha1,beta1),(alpha2,beta2)}, decompose by applying Holt exponential smoothing method. 2- Determine which of the two solutions is the best using MAPE. 3- Make a prediction for the population of 2018-2025 (2018,2019,2020,......,2025) in the best model.
homework will be done in excel format 
A B D E F G H 1 K M N o P Q R S T U v w Y Z AA solution 2 Lt years Lt Tt It Yt_sapka Tt It Yt_sapka solution 1 Yt 1960 10,27648 1961 10,48300 3raphic representation of Yt_hat (for Solution 1 and Solution 2) with Original Series will be given here on one graph LO TO 10,0541 0,2225 alpha1 betal 0,99990 0,32670 alpha2 beta2 0,14159 0,92653 A 1 2 3 4 5 6 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 years 1960 1961 1962 1963 1954 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 22 24 25 26 27 28 29 30 31 32 population 10.27548 10,48300 10,74200 10.95000 11 16700 11 BRDO 11,65100 11,79900 12.00900 12, 26300 12,50700 12.93700 13, 17700 13, 38000 13,72300 13,89300 14,03300 14, 19200 14,35800 14,51400 14, 69200 14,92700 15,17800 15 35900 15 54400 15,75800 16.01840 16,26390 16,51220 16,81440 17,06510 17,28400 17,49500 17,66700 17.85500 18,07200 1831100 18,51700 18,71100 18,92600 19,15300 19,41300 19,65140 19.89540 20, 12740 20.39480 20,69790 20,82760 2124920 21,69170 22,03175 22,34002 22,74248 23,14590 23,50414 23,85078 24,21081 24,59893 33 34 35 36 37 1994 38 40 42 43 44 45 46 47 48 49 SO 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 51 52 53 54 SS S6 57 58 59 60 A B D E F G H 1 K M N o P Q R S T U v w Y Z AA solution 2 Lt years Lt Tt It Yt_sapka Tt It Yt_sapka solution 1 Yt 1960 10,27648 1961 10,48300 3raphic representation of Yt_hat (for Solution 1 and Solution 2) with Original Series will be given here on one graph LO TO 10,0541 0,2225 alpha1 betal 0,99990 0,32670 alpha2 beta2 0,14159 0,92653 A 1 2 3 4 5 6 7 8 10 11 12 13 14 15 16 17 18 19 20 21 22 years 1960 1961 1962 1963 1954 1965 1966 1967 1968 1969 1970 1971 1972 1973 1974 1975 1976 1977 1978 1979 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 22 24 25 26 27 28 29 30 31 32 population 10.27548 10,48300 10,74200 10.95000 11 16700 11 BRDO 11,65100 11,79900 12.00900 12, 26300 12,50700 12.93700 13, 17700 13, 38000 13,72300 13,89300 14,03300 14, 19200 14,35800 14,51400 14, 69200 14,92700 15,17800 15 35900 15 54400 15,75800 16.01840 16,26390 16,51220 16,81440 17,06510 17,28400 17,49500 17,66700 17.85500 18,07200 1831100 18,51700 18,71100 18,92600 19,15300 19,41300 19,65140 19.89540 20, 12740 20.39480 20,69790 20,82760 2124920 21,69170 22,03175 22,34002 22,74248 23,14590 23,50414 23,85078 24,21081 24,59893 33 34 35 36 37 1994 38 40 42 43 44 45 46 47 48 49 SO 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 51 52 53 54 SS S6 57 58 59 60
