Reference no: EM131599450

Part 1, Chart 1:

1. Enter the following information about overweight adolescents in 1999-2000 into Excel: Children less than 2 years old were 11.6 % overweight while children 2-5 years old were 10.4 % overweight, children 6-11 years old were 15.3 % overweight, and children 12-19 years old were 15.5 % overweight.
2. Create appropriate column and row labels. Values should be formatted to the appropriate data format.
3. Create a chart based on the information above. The chart should have a title, a primary horizontal and vertical axis title and legend if you are creating a column chart.
4. The chart should have a title, data labels and legend if you are creating a pie chart.

Part 2, Chart 2:

In a survey of several hundred children the following number of boys and girls were found to be overweight in 1980 and 2004. Enter the following information into Excel:

1. In a recent survey, 88 girls aged 6-11 and 70 boys aged 6-11 were overweight. Also, in the same survey, 118 girls aged 12-19 and 98 boys aged 12-19 were overweight.

Complete the following in Excel:

1. Create appropriate columns and row labels.
2. Add the Total and find the Average of overweight girls.
3. Add the Total and find the Average of overweight boys.
4. Add the Total and find the Average of 6-11 year old children who are overweight. 
5. Add the Total and find the Average of 12-19 year old children who are overweight.
6. Figure out of all the children who are overweight, what percentage are girls and what percentage are boys?
7. Figure out of all the children who are overweight, what percentage are in the 6-11 age group and what percentage are in the 12-19 age group?
8. Values should be formatted to the appropriate data format.
9. Create an appropriate chart based on the information above.
10. The chart should have a title, a primary horizontal and vertical axis title and legend if you are creating a column chart.
11. The chart should have a title, data labels and legend if you are creating a pie chart.

Source info for the charts:

Authors: Cynthia L. Ogden, PhD; Katherine M. Flegal, PhD; Margaret D. Carroll, MS; Clifford L. Johnson, MSPH

Article Title: Prevalence and Trends in Overweight Among US Children and Adolescents, 1999-2000

Website title: JAMA Network

Original Contribution: October 9, 2002