According to a recent article, "More singles, fewer babies, slowest decade of population growth since 1965: 5 highlights of population census", in The Straits Times, compared with 10 years ago, more Singaporeans remain single, and young Singaporeans are more likely to remain single. Knowing that you have learned the knowledge related to making forecasts, your friends ask for your opinion on the following questions. Please use relevant data in the Excel workbook Q2_input_file.xlsx to answer the following questions. (b) Use a suitable method to forecast the proportion of singles among residents aged 20 to 29 years for the years 2021 and 2022. Please limit the answer to within two pages. (20 marks)

Image of the excel file as below

Variables 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 Total Aged 20-29 Years 511,500 515,800 503,400 505,700 472,100 464,900 479,900 455,400 460,200 458,000 450,700 443,500 442,400 449,700 455,200 454,600 453,200 456,900 477,400 Single 357,900 363,600 364,400 358,200 337,100 324,800 340,800 325,800 321,900 313,200 318,400 327,900 324,700 340,800 334,900 351,100 350,000 356,200 379,700 Married 151,300 149,700 136,300 144,700 132,200 138,200 137,000 127,500 136,200 140,000 129,900 113,400 114,300 105,800 116,600 100,100 100,000 97,100 94,000 Widowed 200 300 200 200 200 100 100 300 300 1,700 100 10 100 200 100 100 100 100 10 Divorced/Separated 2,100 2,100 2,500 2,600 2,600 1,800 2,000 1,800 1,900 3,200 2,300 2,100 3,300 3,000 3,600 3,300 3,100 3,400 3,600 Males Aged 20-29 Years 259,700 258,200 257,300 252,900 239,400 225,600 238,100 223,700 224,200 224,700 221,500 217,700 215,900 222,800 226,600 223,900 222,900 227,200 240,800 Single 208,100 207,600 210,500 204,900 195,000 181,900 193,200 184,400 180,900 175,900 179,600 181,700 179,700 189,900 187,900 192,700 191,700 195,500 209,900 Married 51,000 50,100 45,900 47,300 43,600 43,200 44,100 38,600 42,600 46,300 41,200 35,200 35,300 32,100 37,600 30,400 30,500 31,000 30,000 Widowed 0 100 100 0 0 100 200 1,500 10O C 0 0 C 0 0 0 Divorced/Separated 600 500 700 700 800 600 700 600 500 1,000 700 80 900 800 1,100 800 800 600 900 Females Aged 20-29 Years 251,800 257,500 246,100 252,800 232,700 239,300 241,800 231,700 236,000 233,300 229,100 225,800 226,500 226,900 228,600 230,700 230,300 229,700 236,600 Single 149,800 156,000 153,900 153,300 142,100 142,900 147,500 141,400 140,900 137,200 138,800 146,200 145,000 150,900 147,000 158,400 158,300 160,700 169,800 Married 100,200 99,600 90,400 97,400 88,600 95,000 92,900 88,900 93,600 93,700 88,700 78,200 78,900 73,700 79,000 69,800 69,500 66,100 64,000 Widowed 200 200 10 200 200 100 100 100 100 200 100 10 100 200 100 100 100 100 100 Divorced/Separated 1,500 1,700 1,700 1,900 1,900 1,300 1,300 1,200 1,400 2,200 1,600 1,300 2,500 2,100 2,500 2,500 2,400 2,800 2,600Variables 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 Total Aged 20-29 Years 503,800 498,400 504,100 491,700 505,500 501,100 525,800 500,600 509,700 509,500 527,900 Single 397,100 409,200 425,200 415,400 436,500 424,200 441,200 420,500 431,200 433,100 450,000 Married 102,400 85,200 75,900 73,400 67,000 73,700 81,900 77,800 76,100 74,100 74,900 Widowed 200 100 100 100 200 100 100 100 100 Divorced/Separated 4,100 3,900 3,000 2,800 1,900 3,000 2,500 2,200 2,300 2,300 3,000 Males Aged 20-29 Years 251,000 249,000 256,300 248,400 255,600 252,000 266,400 256,000 258,000 264,000 265,700 Single 216,000 220,200 232,400 224,300 232,700 226,700 236,100 227,300 230,000 235,100 237,600 Married 33,900 27,800 23,000 23,400 22,300 24,500 29,300 28,100 27,200 28,100 27,300 Widowed 0 0 O 0 0 0 0 100 0 0 Divorced/Separated 1,100 1,100 800 800 600 800 1,100 700 800 800 800 Females Aged 20-29 Years 252,800 249,400 247,800 243,200 249,900 249,100 259,400 244,600 251,600 245,500 262,200 Single 181,100 189,100 192,800 191,100 203,800 197,500 205,200 193,200 201,200 198,000 212,400 Married 68,500 57,500 52,800 50,000 44,800 49,300 52,600 49,700 48,900 46,000 47,600 Widowed 100 100 100 0 100 0 200 100 100 100 0 Divorced/Separated 3,000 2,800 2,200 2,100 1,200 2,200 1,500 1,600 1,500 1,500 2,200