Purchase Solution

BMI worksheet

Not what you're looking for?

Ask Custom Question

In this problem, you will calculate Body Mass Index given the inputs of Height and Weight. You will also provide the results as bar, line, and column charts.
Use a cell reference or a single formula where appropriate.

2 In cell F9, convert the height in C7:C8 to inches.
3 In cell F12, use the appropriate formula to calculate Body Mass Index if Height is equal to the value in cell F9 and Weight is equal to the value in cell C11.
4 In cell C27, use the appropriate formula to calculate Body Mass Index if Height is equal to the value in cell B27 and Weight is equal to the value in cell C26. Fill cell C27 down and across to cell L36.
Note: Be sure to use absolute, mixed, and relative cell references
5 In cells B41:I57, insert a Clustered Bar Chart to show Body Mass Index for 115 lbs as a function of Height. Select ranges B27:B36 and E27:E36. On the Insert tab, click Recommended Charts, and then click Clustered Bar. Apply Style 4 on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with BMI for 115 lbs. Add an axis title for the horizontal axis and replace Axis Title with Height (in.). Add the data labels and choose the Inside End option.
6 In cells K41:R57, insert a Line Chart to show Body Mass Index for 66 in. as a function of Weight. Select ranges C26:L26 and C33:L33. On the Insert tab, click Recommended Charts, and then click Line. Apply Style 5 on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with BMI for 66 inches. Add an axis title for the horizontal axis and replace Axis Title with Weight (lbs).
7 In cells T41:Y57, insert a 3-D Column Chart to show Body Mass Index for each Height and Weight. Select range B26:L36. On the Insert tab, click Recommended Charts, then open the All Charts tab, and then choose 3-D Column with the height on the horizontal axis and the BMIs on the vertical axis. Apply Style 1 on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with BMI. Add axis titles. Replace Axis Title for the horizontal axis with Height (in.), Axis Title for the vertical axis with BMI, and Axis Title for the depth with Weight (lbs).

Body Mass Index (BMI) is a function of a person's height and weight, specifically the ratio of mass (kg) to the square of height (m). The formula using a person's weight in pounds and height in feet and inches is given below with appropriate conversion factors.

a.) Given a person's height in feet and inches and weight in pounds, convert the height to just inches.
b.) Compute the BMI using the formula:
c.) Enter a formula in the 10 by 10 table that gives one hundred BMI outputs for the ten Height inputs and ten Weight inputs. Be sure to use proper absolute/mixed/relative cell references.
d.) Create 3 graphs:
1. Bar chart showing BMI for 115 lbs as a function of Height.
2. Line chart showing BMI for 66 in. as a function of Weight.
3. 3-D column chart showing the entire table.
Axis labels and titles from the list:
a. BMI for 66 inches
b. BMI
c. Weight (lbs)
d. BMI for 115 lbs
e. Height (in.)

Purchase this Solution

Solution Summary

The Excel file contains all formulas, computations and solutions for the problem.

Solution provided by:
Education
  • MSc, California State Polytechnic University, Pomona
  • MBA, University of California, Riverside
  • BSc, California State Polytechnic University, Pomona
  • BSc, California State Polytechnic University, Pomona
Recent Feedback
  • "Excellent work. Well explained."
  • "Can you kindly take a look at 647530 and 647531. Thanks"
  • "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
  • "GREAT JOB!!!"
  • "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution


Free BrainMass Quizzes
Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.

Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Probability Quiz

Some questions on probability