Question

Homework: HW 14 - Chapter 14 Score: 0 of 1 pt 4.2.77 The following tables gives the population for a country, in milions of persons, for the years 1990-2009. Forecast the population in the years 2010 and 2011. Save 11 of 13 (10 complete) HW Score: 74.36%, 9.67 of 13 pts Question Help * Year 1990 1991 | 1992 | 1993 1994 |1995 | 1996 | 1997 1998 1999 Pop T 250 T 253 257T260 T 263 266 269 T 273 T 276 279- Year | 2000 2001 | 2002 | 2003 2004 |2005 |2006 |2007 2008 |2009 Pop 282285 288 290 293 296 299 302304 30 The forecast for 2010 is million people. (Round to one decimal places as needed.)

Answer 1

We use the Excel function " FORECAST()" to obtain the forecast values for years 2010 and 2011

Parameters for FORECAST() function :

x = Year for which the forecast is required ( In our case 2010 and 2011 )

known_ys = Array of population from year 1990 to 2009

known_xs = Array of years from 1990 to 2009

So, using this function we get the forecast for 2010 and 2011 as:

Year	Population
1990	250
1991	253
1992	257
1993	260
1994	263
1995	266
1996	269
1997	273
1998	276
1999	279
2000	282
2001	285
2002	288
2003	290
2004	293
2005	296
2006	299
2007	302
2008	304
2009	307
2010	311.1
2011	314.1

The forecast for 2010 is 311.1 million people.

The forecast for 2011 is 314.1 million people.