Name __________________________

Part I: Body Fat Composition

1. Create a table of the following data for body fat for women at the Palikir campus of COM-FSM.

Category    Number
Fit         19
Acceptable  24
Obese       18

2. Create a pie chart of the above data with labels and percentages. Do not display the legend.

3. Create a table of the following data for body fat for men at the Palikir campus of COM-FSM.

Category    Number 
Fit         16
Acceptable   8
Obese       17

4. Create a second pie chart of the above data with labels and percentages. Do not display the legend.

5. Which group has a higher percentage obese, the women or the men?

Part II: Nahnpohnmal Run

1. Make an Excel spreadsheet using the following data. The data is for a runner running from the College of Micronesia-FSM in Palikir to the Pohnpei State Track in Kolonia. The time is in minutes, the distance is in kilometers.


Location           Time  Distance
College               0     0
Dolon Pass           20   3.3
Nahnpohnmal Turnoff  25   4.5
The Beast            33   5.7
Track                55   9.7

2. Create an XY scatter plot of the data.

3. Use Excel to find the best fit linear equation to the data.

4. Use the best fit equation to calculate the predicted distance if the runner runs for 40 minutes. Write your answer on this paper.

5. What is the predicted 5 kilometer time for the runner? Write your answer on this paper.