Phase 3 Statistical Analysis and Results

profileprtneesswdly
pervious_homework2.xlsx

Sheet1

1 the table below shows the data in % obesity prevealnce rates for the children aged between 6 and 11 years from 1971 to 2014
1 2 3 4 5 6 7 8 9 10
2014-2013 2012-2011 2010-2009 2008-2007 2006-2005 2004-2003 2002-2001 2000-1999 1988-1994 1976-80 1971-1974
girls 15.9 19.1 15.7 18 14.1 17.6 14.8 14.3 11 6.4 3.6
boys 18.8 16.4 20.1 21.2 16.2 19.9 17.5 15.8 11.6 6.6 4.3
the data above was colected from https://www.cdc.gov/nchs/data/hestat/obesity_child_13_14/obesity_child_13_14.htm
2. frequency distribution table
year boys girls average
2014-2013 18.8 15.9 17.35
2012-2011 16.4 19.1 17.75
2010-2009 20.1 15.7 17.9
2008-2007 21.1 18 19.55
2006-2005 16.2 14.1 15.15
2004-2003 19.9 17.6 18.75
2002-2001 17.5 14.8 16.15
2000-1999 15.8 14.3 15.05
1994-1988 11.6 11 11.3
1980-1976 6.6 6.4 6.5
1974-1971 4.3 3.6 3.95
the histogram are skewed to the right indicating that the obesity prevalence rates are on the increase for the children ages 6 to 11 years from 1971. there are more obese boys than girls over time.

combined obesity prevalence

boys 2014-2013 2012-2011 2010-2009 2008-2007 2006-2005 2004-2003 2002-2001 2000-1999 1994-1988 1980-1976 1974-1971 18.8 16.399999999999999 20.100000000000001 21.1 16.2 19.899999999999999 17.5 15.8 11.6 6.6 4.3 girls 2014-2013 2012-2011 2010-2009 2008-2007 2006-2005 2004-2003 2002-2001 2000-1999 1994-1988 1980-1976 1974-1971 15.9 19.100000000000001 15.7 18 14.1 17.600000000000001 14.8 14.3 11 6.4 3.6 average 2014-2013 2012-2011 2010-2009 2008-2007 2006-2005 2004-2003 2002-2001 2000-1999 1994-1988 1980-1976 1974-1971 17.350000000000001 17.75 17.899999999999999 19.55 15.149999999999999 18.75 16.149999999999999 15.05 11.3 6.5 3.95

boys 2014-2013 2012-2011 2010-2009 2008-2007 2006-2005 2004-2003 2002-2001 2000-1999 1994-1988 1980-1976 1974-1971 18.8 16.399999999999999 20.100000000000001 21.1 16.2 19.899999999999999 17.5 15.8 11.6 6.6 4.3

girls 2014-2013 2012-2011 2010-2009 2008-2007 2006-2005 2004-2003 2002-2001 2000-1999 1994-1988 1980-1976 1974-1971 15.9 19.100000000000001 15.7 18 14.1 17.600000000000001 14.8 14.3 11 6.4 3.6 boys 2014-2013 2012-2011 2010-2009 2008-2007 2006-2005 2004-2003 2002-2001 2000-1999 1994-1988 1980-1976 1974-1971 18.8 16.399999999999999 20.100000000000001 21.1 16.2 19.899999999999999 17.5 15.8 11.6 6.6 4.3

average 2014-2013 2012-2011 2010-2009 2008-2007 2006-2005 2004-2003 2002-2001 2000-1999 1994-1988 1980-1976 1974-1971 17.350000000000001 17.75 17.899999999999999 19.55 15.149999999999999 18.75 16.149999999999999 15.05 11.3 6.5 3.95 boys 2014-2013 2012-2011 2010-2009 2008-2007 2006-2005 2004-2003 2002-2001 2000-1999 1994-1988 1980-1976 1974-1971 18.8 16.399999999999999 20.100000000000001 21.1 16.2 19.899999999999999 17.5 15.8 11.6 6.6 4.3 girls 2014-2013 2012-2011 2010-2009 2008-2007 2006-2005 2004-2003 2002-2001 2000-1999 1994-1988 1980-1976 1974-1971 15.9 19.100000000000001 15.7 18 14.1 17.600000000000001 14.8 14.3 11 6.4 3.6