Name __________________________
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?
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.