Final Prob. 2) We are going to look at two measures of the human body, BMI and BMR. BMI (Body Mass Index) is intended to assess how much an individual's body weight deviates from 'normal'. BMI = ( weight in pounds)/(height in inches )^2 x 703 A. Create a calculator that permits weight (pounds), and height (inches.) in cell C2-C3, respectively. In cell C7 place the formula calculation for BMI. BMR (Basal Metabolic Rate) is the rate of energey exp[enditure per unit time by an individual at rest. One of the best known calculations of Basal Metabolic Rate is the original Harris-Benedict equations for men and women. According to Wikipedia... "Basal Metabolic Rate is the amount of energy expressed in calories that a person needs to keep the body functioning at rest. Some of those processes are breathing, blood circulation, controlling body temperature, cell growth, brain and nerve function, and contraction of muscles. Bosal metobolic rate (BMR) affects the rate that a person burns calories and ultimately whether you maintain, gain, or lose weight." Woman: BMR = 655 + (4.35 x weight in pounds ) + ( 4.7 x height in inches ) - (4.7 x age in years) Man: BMR = 66 + (6.23 x weight in pounds ) + ( 12.7 x height in inches ) - (6.8 x age in year) B. Create a calculator that permits data entry of gender (Woman or Man) and age (years) in cell C4-C5, respectively. In cell C8 place the formula calculation for BMRS. In cell As place a logical formula that results in either "Ms. your BMR is="if the calculation is for a woman or "Mr. your BMR is =" depending on the entry C4. C. Suppose you also ask if an individual has the body fat of an athlete. In Cell E2 insert the text: "Athlete's Body Fat?.-"Y" or "N". The answer is placed in G2--either "Y" or "N". If the answer is "Y", the formula in C should be multiplied by a factor of 1.25, otherwise it remains the same. The multiplication should occur due to a logic statement Restrict all entries to integer values:e g. 180 lbs., 68 inches, and 68 years. Use these in your model. Souren A 00 B D E Weight = Height = Gender = Age = 176 65 Man 67 BMI= Place welcome Place Logic to calculate BMR Here