What To Do
- Open Microsoft Excel, then press Alt+F11on keyboard, so VBE ( Visual Basic Editor) window is displayed.
- Open a module by selecting Module on Insert menu and write this script: Function BMI(weight, height) BMI = weight / (height / 100) ^ 2 End Function.
- Close the VBE window and back to Excel.
Similarly, you may ask, how do you create a BMI chart?
BMI Chart
- Find your height on the side (in metres on the left and in feet on the right) and draw a horizontal line across the chart.
- Find your weight (in kilograms across the bottom of in pounds across the top) and draw a vertical line across the chart.
- The shaded area where the 2 lines meet is your BMI.
Also, what is the correct BMI for my age? A BMI of less than 18.5 means that a person is underweight. A BMI of between 18.5 and 24.9 is ideal. A BMI of between 25 and 29.9 is overweight. A BMI over 30 indicates obesity.
People also ask, how do I calculate BMI in Excel 2007?
With the metric system, the formula for BMI is weight in kilograms divided by height in meters squared. Because height is commonly measured in centimeters, divide height in centimeters by 100 to obtain height in meters.
How do you calculate BMI in pounds?
Calculate BMI by dividing weight in pounds (lbs) by height in inches (in) squared and multiplying by a conversion factor of 703. To find your body mass index (BMI), multiply your weight in pounds by 705, then divide the result by your height in inches, then divide again by your height. The result is your BMI.
How do you calculate BMI with height and weight?
Body Mass Index is a simple calculation using a person's height and weight. The formula is BMI = kg/m2 where kg is a person's weight in kilograms and m2 is their height in metres squared. A BMI of 25.0 or more is overweight, while the healthy range is 18.5 to 24.9. BMI applies to most adults 18-65 years.What is the BMI chart?
BMI categories| BMI | Weight status |
|---|---|
| Below 18.5 | Underweight |
| 18.5–24.9 | Healthy |
| 25.0–29.9 | Overweight |
| 30.0 and above | Obese |
How can I measure my BMI at home?
To work out your BMI, you divide your weight in kilograms by your height in metres, then divide the answer by your height again. This figure can then be compared against a chart of healthy weights for each height: a normal BMI is between 18.5 and 25.What should a 59 woman weigh?
The average American woman 20 years old and up weighs 170.6 pounds and stands at 63.7 inches (almost 5 feet, 4 inches) tall.How much does the average American woman weigh?
| Age group (years) | Average weight (pounds) |
|---|---|
| 20-39 | 167.6 |
| 40-59 | 176.4 |
| 60 and older | 166.5 |
How much should a 5'2 female weigh?
Height and Weight Chart| Height | Weight | |
|---|---|---|
| 5' | 97 to 127 lbs. | 128 to 152 lbs. |
| 5' 1" | 100 to 131 lbs. | 132 to 157 lbs. |
| 5' 2" | 104 to 135 lbs. | 136 to 163 lbs. |
| 5' 3" | 107 to 140 lbs. | 141 to 168 lbs. |
What is the best BMI for a woman?
A BMI of less than 18.5 means that a person is underweight. A BMI of between 18.5 and 24.9 is ideal. A BMI of between 25 and 29.9 is overweight. A BMI over 30 indicates obesity.Does BMI actually matter?
BMI Not a Good Measure of Healthy Body Weight, Researchers Argue. BMI is based on weight and height, not on body fat. People with BMIs higher than 30 are at an increased risk of dying from heart disease, diabetes, cancer and other diseases, many studies have shown.What is the average BMI for a woman?
The BMI of the average woman in the U.S. is 29.6, which falls into the category of “overweight.”BMI.
| Underweight | Less than 18.5 |
|---|---|
| Normal weight | 18.5–24.9 |
| Overweight | 25–29.9 |
| Obesity | 30 or greater |
