Applying basic Excel functions to a spreadsheet generated by the the CDC on Nutrition, Physical Activity, and Obesity.
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.
This question has not been answered.
Create a free account to get help with this and any other question!
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