1. The attached excel spreadsheet contains BMI data for five boys and five girls from age 5.5 years

to 9.5 years.

2. Calculate the average BMI for the girls, then for the boys, at each age of

measurement.

3. Using Excel or another graphing program, graph both the BMI over the

nine measurements for each of the five girls and the average for the girls.

Do the same for the boys.

Table 17.1Body Composition (BMI) in Childhood Participant :Age (yr): 5.5 6 6.5 7 7.5 8 8.5 9 9.5

Girl 1 14 14.9 15.2 15.8 15.4 16.5 16 16.7 16.8

Girl 2 14.9 18.1 20.4 21.4 19.7 20.5 21.1 22.9 22.8

Girl 3 14.3 13.8 13.8 14.3 14 14.2 14.2 13.8 14.4

Girl 4 14.6 14 14 14 13.5 14.3 14 13.8 14

Girl 5 14.9 14.6 15.5 16.4 16 15.6 16.8 * * Girls' avg.

Age (yr): 5.5 6 6.5 7 7.5 8 8.5 9 9.5

Boy 1 17.2 17.7 * 19.1 19.2 19.5 19.3 20 18.8

Boy 2 15.9 15.7 15.6 16.4 15.4 15.7 16.5 15.8 15.3

Boy 3 13 13.9 13.4 14 13 13.5 14 13.3 13.5

Boy 4 17.6 18.6 18.4 19 19 19.7 21.3 20.3 21

Boy 5 * 15.5 14.6 15.1 14 14.9 15 15.6 15.9 Boys' avg. *Student was not measured.