Saadeh_Chapter_1-8_BMI_Start

xlsx

School

University of Florida *

*We aren’t endorsed by this school

Course

104

Subject

Chemistry

Date

Feb 20, 2024

Type

xlsx

Pages

9

Uploaded by catwomen123

Report
BMI Project De In this proble Use a cell re Steps to P Step 1 2 3 4 5 6 7 8
escription: em, 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 eference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not recei Perform: Instructions Start Excel. Download and open the workbook named: Chapter_1-8_BMI_Start In cell F9, convert the height in C7:C8 to inches. 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 Save your file and submit for grading. 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 valu L36. Note: Be sure to use absolute, mixed, and relative cell references. 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:E 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 B axis and replace Axis Title with Height (in.) . Add the data labels and choose the Inside End option. 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 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 . Axis Title with Weight (lbs) . 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, c 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. Ad 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 BM
0 2 2 4 4 4 4 0 20 Points Possible
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
BMI Use a cell reference or a single formula where appropriate in order to receive full credit. Do not Input Height: Feet: 5 Inches: 2 a.) Convert Height to Inches: 62 Input Weight: Pounds: 145 b.) Compute Body Mass Index (BMI): 27.2 c.) Height (in) Weight (lbs) 105 110 115 120 125 130 135 60 21.0 22.0 23.0 24.0 25.0 26.0 27.0 61 20.3 21.3 22.3 23.2 24.2 25.2 26.1 62 19.7 20.6 21.5 22.5 23.4 24.3 25.3 63 19.0 20.0 20.9 21.8 22.7 23.6 24.5 64 18.5 19.3 20.2 21.1 22.0 22.9 23.7 65 17.9 18.7 19.6 20.4 21.3 22.2 23.0 66 17.4 18.2 19.0 19.8 20.7 21.5 22.3 67 16.8 17.6 18.4 19.2 20.0 20.9 21.7 68 16.3 17.1 17.9 18.7 19.5 20.2 21.0 69 15.9 16.6 17.4 18.1 18.9 19.7 20.4 d.) 1. Body Mass the square given below a.) Given a b.) Compu 69 17.4 BMI for 115 lbs
60 61 62 63 64 65 66 67 68 69 0.0 5.0 10.0 15.0 20.0 25.0 23.0 22.3 21.5 20.9 20.2 19.6 19.0 18.4 17.9 17.4 Height (in.)
t copy and paste values or type values, as you will not receive full credit for your answers. 140 145 150 28.0 29.0 30.0 27.1 28.1 29.0 26.2 27.2 28.1 25.4 26.3 27.2 24.6 25.5 26.4 23.9 24.7 25.6 23.1 24.0 24.8 22.5 23.3 24.1 21.8 22.6 23.4 21.2 21.9 22.7 d.) 2. s Index (BMI) is a function of a person’s height and weight, specifically the ratio of mass (kg) to e of height (m). The formula using a person’s weight in pounds and height in feet and inches is w with appropriate conversion factors. person’s height in feet and inches and weight in pounds, convert the height to just inches. d.) Create 3 graphs: 1. Bar chart showing BMI for 115 lbs as a function of Heig 2. Line chart showing BMI for 66 in. as a function of Weigh 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.) c.) Enter a formula in the 10 by 10 table that gives one hund BMI outputs for the ten Height inputs and ten Weight input Be sure to use proper absolute/mixed/relative cell reference ute the BMI using the formula: 30.0 BMI for 66 inches
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
105 110 115 120 125 130 135 140 145 150 0.0 5.0 10.0 15.0 20.0 25.0 Weight (lbs)
d.) 3. ght. ht. dred ts. es. BMI
60 61 62 63 64 65 66 67 68 69 0.0 5.0 10.0 15.0 20.0 25.0 30.0 105 115 125 135 145 105 110 115 120 125 130 135 140 145 150 Height (in.) BMI Weight (lbs)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help