Applying basic Excel functions to a spreadsheet generated by the the CDC on Nutrition, Physical Activity, and Obesity.

yrfun_0201
timer Asked: Apr 6th, 2018

Question Description

This assignments consist of three parts, sort the data to a spreadsheet for the following questions

1. Which state had the highest percent of low -income children aged 2 to less than 5years who are obese(MBI for age and sex> 95th percentile on CED growth chart)? What is the percent value?

2. Which state had the highest sample size?

3. What percent of the total sample size was represented by tribes in the United States?

Save each sort and submit it as a worksheet in your Excel workbook. Label each worksheet.

Part II

Use the linked map generated by this data to set to answer the following questions

1. What regional trends in this data are illustrated on this map?

2. Which states showed the highest obesity rates? Which showed the lowest?

Part III

1. Use the CDC site Nutrition, Physical, Activity, and Obesity Data Trends and Maps to generate your own label and map by selecting your own criteria. You will need to select a location, an indicator Category, and then an indicator from the drop-down menus provided. Once your map and label is generated, scroll to the line bottom of the page to locate the citation information you will need for your references section.

2. Copy and paste the data label you generated into an Excel spreadsheet. Manipulate the columns and cells to display the data accurately, and the report the regions with highest and lowest trends by sorting data.

3. Insert your sorted spreadsheet as a table and your map as an image on powerpoint slides include a Title

slide and reference slide. Describe the trends for each table and image in the Notes section of the respective slide.


User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

This question has not been answered.

Create a free account to get help with this and any other question!

Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors