### 10.1 Health & Fitness

<
>
• Math Help

To make a spreadsheet similar to the one in Example 2, use the steps below.

1. Enter the title "Factor" into cell C1.
2. In column A starting with cell A2, enter the titles "Weight," "Wrist," "Waist," "Hips," and "Forearm."
3. Enter 145 into cell B2, 6.5 into cell B3, 28 into cell B4, 36 into cell B5, and 10 into cell B6.
4. Enter the formula =(B2*0.732)+8.987 into cell C2.
5. Enter the formula =B3/3.140 into cell C3.
6. Enter the formula =B4*0.157 into cell C4.
7. Enter the formula =B5*0.249 into cell C5.
8. Enter the formula =B6*0.434 into cell C6.
9. In column A starting with cell A8, enter the titles "Lean body mass," "Body fat weight," and "Body fat percentage."
10. Enter the formula =C2+C3-C4-C5+C6 into cell C8.
11. Enter the formula =B2-C8 into cell C9.
12. Enter the formula =C9/B2 into cell C10.

To format the cells, use the steps below.

1. Select cells C2 through C9.
2. From the Format menu, choose Cells....
3. In the Format Cells dialog, select the Number tab.
4. From the Category: list, select Number.
5. For Decimal places:, enter 2. Then click OK.
6. Select cell C10.
7. From the Format menu, choose Cells....
8. In the Format Cells dialog, select the Number tab.
9. From the Category: list, select Percentage.
10. For Decimal places:, enter 1. Then click OK.
• Consumer Suggestion

If you've calculated your body fat percent, you may be wondering what the healthy ranges are. To find out how your body fat percent compares, or to view the various body fat ranges, visit Body Spex.

• Checkpoint Solution

Body Mass Index of Woman:

In the formula for body mass index, substitute the body fat percentage that you calculated in Example 2 for BF, the woman's age for age, and 0 for gender because she is female.

The woman has a body mass index of about 21.0.

Body Mass Index of Man:

Part 1: Calculate Body Fat Percentage

First, calculate the man's body fat percentage.

The man's body fat percentage is about 18.0%.

Part 2: Calculate Body Mass Index

In the formula for body mass index, substitute the man's body fat percentage for BF, the man's age for age, and 1 for gender because he is male.

The man has a body mass index of about 23.5.

These comments are not screened before publication. Constructive debate about the information on this page is welcome, but personal attacks are not. Please do not post comments that are commercial in nature or that violate copyright. Comments that we regard as obscene, defamatory, or intended to incite violence will be removed. If you find a comment offensive, you may flag it.
```           __   __     _____    ______   _____