In a survey of several hundred children the following number of boys a

In a survey of several hundred children the following number of boys a

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: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:Create appropriate columns and row labels.Add the Total and find the Average of overweight girls.Add the Total and find the Average of overweight boys.Add the Total and find the Average of 6-11 year old children who are overweight.Add the Total and find the Average of 12-19 year old children who are overweight.Figure out of all the children who are overweight, what percentage are girls and what percentage are boys?Figureout 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?Values should be formatted to the appropriate data format.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.The chart should have a title, data labels and legend if you are creating a pie chart