|
|
|
Formulas for the Excel Lab Assignments MS Excel Lab I: BMI BMI = Weight (Kg) divided by Height (m) squared To automatically generate categories based on the BMI result you may try the following IF, AND conditions: =IF(D2>=24,"Overweight",IF(AND(D2>=22,D2<=23.9),"Healthy",IF(D2<=21.9,"Underweight"))) |
| Subject | WEIGHT | HEIGHT | BMI | Weight Category |
| SS #1 | 88 | 1.8 | 27.16049 | Overweight |
| SS #2 | 75 | 1.8 | 23.14815 | Healthy |
| SS #3 | 109 | 1.8 | 33.64198 | Overweight |
| SS #4 | 70 | 1.8 | 21.60494 | Underweight |
| SS #5 | 44 | 1.53 | 18.79619 | Underweight |
|
Body Density Formula |
|
Body Density = BW/[(BW - WW)/WD] - (RLV + 100 ml) BW = Body Weight WW = Water Weight WD = Water Density RLV = Residual Lung Volume Percent Fat = 495/Body Density - 450 Adapted from: Neiman, D. C. (1990). Fitness and sports medicine: An introduction. Palo Alto, CA: Bull (Chapter 5, pp. 123-129) For a very good discussion see McArdle, W. D., Katch, F. I., & Katch, V. L. (1991). Exercise physiology: Energy, nutrition, and human performance (3rd ed.). Philadelphia, MA: Lea & Febiger. (Chapter 27, pp. 599-633) |
Deriving the Predicted VO2max from One-Mile Walk Test Data VO2max = 132 - (0.0769 * Weight/lbs) - (0.3877 * Age) + (6.315 * Gender) Gender: Male=1; Female=0 Adapted from: Fahey, T. D., Insel P. M., & Roth, T. W. (2001). Fit and well: Core concepts and labs in physical fitness and wellness (4th ed.). Mountain View, CA: Mayfield. (Lab 3-1, pp. 61-62) |
| Copyright© 2002-03, Daniel Frankl, Ph.D. |
questions and/or comments;
thank you! |
|
|
HOME ||
Schedule ||
CSLA 2002-03 Events
|
Page updated: May 03, 2002