1 2 3 4 5 5 6 7 7 8 8 9 Country Year BMI GDP Life expectancy Population Belize 2015 59 5000 71 359288 Belize 2014 51 4852.22 70 351694 Belize 2013 49.3 4688.54 69.8 344181 Belize 2012 48.5 4673.64 69.4 33671 Belize 2011 47.8 4516.25 69.4 329192 Belize 2010 47 4344.15 69.5 32168 Belize 2009 46.3 4258.79 69.5 313929 Belize 2008 45.7 4324 69.6 36165 Belize 2007 45 4324.88 69.6 29847 Belize 2006 44.4 4187.38 69.4 29747 Belize 2005 43.8 3933.33 69 283277 Belize 2004 43.2 3831.54 68.7 27689 Belize 2003 42.6 3680 68.4 26913 Belize 2002 42 3556.56 68.5 26226 Belize 2001 41.4 3419.28 68.2 254984 Belize 2000 48 3364.42 68.3 247315 10 11 12 13 14 15 16 17 2. Assuming a Linear Relationship between the Year (independent variable) and Life expectancy (plot in Y), plot a scatter chart. 3. Display the line of Best Fit 4. By computing the Y Intercept, Slope provide the Regression Formula 5. From the Linear Model what would be the Life Expectancy in 2021? 1 2 3 4 5 5 6 7 7 8 8 9 Country Year BMI GDP Life expectancy Population Belize 2015 59 5000 71 359288 Belize 2014 51 4852.22 70 351694 Belize 2013 49.3 4688.54 69.8 344181 Belize 2012 48.5 4673.64 69.4 33671 Belize 2011 47.8 4516.25 69.4 329192 Belize 2010 47 4344.15 69.5 32168 Belize 2009 46.3 4258.79 69.5 313929 Belize 2008 45.7 4324 69.6 36165 Belize 2007 45 4324.88 69.6 29847 Belize 2006 44.4 4187.38 69.4 29747 Belize 2005 43.8 3933.33 69 283277 Belize 2004 43.2 3831.54 68.7 27689 Belize 2003 42.6 3680 68.4 26913 Belize 2002 42 3556.56 68.5 26226 Belize 2001 41.4 3419.28 68.2 254984 Belize 2000 48 3364.42 68.3 247315 10 11 12 13 14 15 16 17 2. Assuming a Linear Relationship between the Year (independent variable) and Life expectancy (plot in Y), plot a scatter chart. 3. Display the line of Best Fit 4. By computing the Y Intercept, Slope provide the Regression Formula 5. From the Linear Model what would be the Life Expectancy in 2021