BMI Category BMI range Underweight <18.5 Normal 18.5 – 24.9 Overweight 25 - 29 Obese >29 Include totals for each category using COUNTIF.
BMI Category BMI range Underweight <18.5 Normal 18.5 – 24.9 Overweight 25 - 29 Obese >29 Include totals for each category using COUNTIF.
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
Explain formula used to calculate BMI and category column and also do all other steps given in picture.
![BMI Category
BMI range
Underweight
<18.5
Normal
18.5 – 24.9
Overweight
25 – 29
Obese
>29
7. Include totals for each category using COUNTIF.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc4436f5f-01e3-4d46-baa5-3f23cf388ae7%2F0e93c861-fac1-4720-9a71-3c1d5920f96b%2Fdubb71g_processed.png&w=3840&q=75)
Transcribed Image Text:BMI Category
BMI range
Underweight
<18.5
Normal
18.5 – 24.9
Overweight
25 – 29
Obese
>29
7. Include totals for each category using COUNTIF.
![Create a spreadsheet for the Height and Weight data given in below
Weight
Height
StulD
pounds (Ibs)
Feet
Inches
BMI
Category
10010
102
4
10
10020
135
5
4
10030
285
6
1
10040
194
6
10050
206
6
10060
190
10070
275
4
11
10080
175
4
5
10090
140
6
5
10100
150
5
10110
190
5
9.
10120
120
5
10130
185
5
8
10140
190
5
10150
165
5
11
10160
205
6
4
Under
Normal
Over
Obese
Totals
1. Use word wrap for headings
2. Use borderes and fills to create good visual effects
3. Place the title (BMI Claculations) in merged cells centered across the top of the table
4. Rename the tabe at the bottom of the sheet as BMI
5. Enter the formula for BMI, using 1 decimal place accurarcy for the results.
mass(lb)
BMI =
* 703
(height(in))
6. Use https://www.nhlbi.nih.gov/health/educational/lose_wt/BMI/bmicalc.htm to create a VLOOKUP
table. The given BMI categories are
ㅇ | 2](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2Fc4436f5f-01e3-4d46-baa5-3f23cf388ae7%2F0e93c861-fac1-4720-9a71-3c1d5920f96b%2Fn1z45ma_processed.png&w=3840&q=75)
Transcribed Image Text:Create a spreadsheet for the Height and Weight data given in below
Weight
Height
StulD
pounds (Ibs)
Feet
Inches
BMI
Category
10010
102
4
10
10020
135
5
4
10030
285
6
1
10040
194
6
10050
206
6
10060
190
10070
275
4
11
10080
175
4
5
10090
140
6
5
10100
150
5
10110
190
5
9.
10120
120
5
10130
185
5
8
10140
190
5
10150
165
5
11
10160
205
6
4
Under
Normal
Over
Obese
Totals
1. Use word wrap for headings
2. Use borderes and fills to create good visual effects
3. Place the title (BMI Claculations) in merged cells centered across the top of the table
4. Rename the tabe at the bottom of the sheet as BMI
5. Enter the formula for BMI, using 1 decimal place accurarcy for the results.
mass(lb)
BMI =
* 703
(height(in))
6. Use https://www.nhlbi.nih.gov/health/educational/lose_wt/BMI/bmicalc.htm to create a VLOOKUP
table. The given BMI categories are
ㅇ | 2
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY