you will use an interactive database that provides national and state-level data about the health status and behaviors of Americans. You can access the Data, Trends, and Map database through the following CDC link: https://www.cdc.gov/nccdphp/dnpao/data-trends-maps/index.html
fruits and vegetables
Data can also be filtered by demographics such as gender and race/ethnicity.
Select any state for location (you will be comparing data from 2 different states).
Select one of the categories from the list above from the dropdown menu under “Explore by Indicator.” Select a subcategory such as “behavior” or “environmental/policy” if it applies.
Using the dropdown menu under “view by,” continue filtering your data by age, education, gender, income, or race (select only one of these subcategories).
Select the workbook icon in the upper right to see the data for your chosen state.
Record your data in an Excel sheet using columns for sample size and values (example shown below showing Excel calculations and graph for Fruits and Vegetables by Behavior and Education level). Your data should include two different states of your choosing for comparison.
Calculate the sum and average value for sample size and relevant categories (see Excel tutorial for guidance).
Create a graph that compares the value data from both states. See the video link below for guidance on creating a clustered column chart.
Clustered column charts in Excel. Youtube. Retrieved from https://www.youtube.com/watch?v=NiqwMM-80II
create a PowerPoint presentation that addresses the following:
Introduce the health status/behavior category you have chosen (obesity, breast feeding, fruits and vegetables, etc.).
Compare the data between the two states you have chosen (how do the values differ by category? How does the sample size influence the data for each state and category?)
Copy and paste your graph into your presentation, summarizing the data shown. How do the average values for each of your states compare to national data? How well do you think each state is performing compared to national levels?
Submit your Excel spreadsheet with graph as well as PowerPoint presentation.
This assignment includes two submissions – the Excel spreadsheet with data and graph plus a PowerPoint presentation. Your PowerPoint presentation should be approximately 3-4 slides, not including the Title and Reference slides.
We are a professional custom writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework.
Yes. We have posted over our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill our Order Form. Filling the order form correctly will assist our team in referencing, specifications and future communication.
1. Click on the “Place order tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
2. Fill in your paper’s requirements in the "PAPER INFORMATION" section and click “PRICE CALCULATION” at the bottom to calculate your order price.
3. Fill in your paper’s academic level, deadline and the required number of pages from the drop-down menus.
4. Click “FINAL STEP” to enter your registration details and get an account with us for record keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
Need this assignment or any other paper?
Click here and claim 25% off
Discount code SAVE25