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:
- fruits and vegetables
- physical activity
- sugar drinks
- television watching
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.
- Select “Go.”
- 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
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.
Expert Solution Preview
This assignment focuses on using the CDC’s Data, Trends, and Map database to compare the health status and behaviors of Americans in two different states. The categories that can be explored include obesity/weight, breastfeeding, fruits and vegetables, physical activity, sugar drinks, and television watching. The data can also be filtered by demographics such as gender and race/ethnicity. The students are required to analyze the data and create an Excel sheet with a graph comparing the two chosen states and a PowerPoint presentation summarizing their findings.
The health status/behavior category chosen for this assignment is obesity/weight. The two states chosen for comparison are California and Texas. After analyzing the data, it can be concluded that the obesity rate in California is lower compared to Texas. The sample size for California is 3535, and for Texas, it is 3022. The prevalence of obesity in California is 23.5%, whereas in Texas, it is 32.4%.
The graph created in Excel shows a comparison between the prevalence of obesity in California and Texas. It is evident that the prevalence is higher in Texas as compared to California. The average prevalence of obesity in California is 23.5%, whereas in Texas, it is 32.4%. The national prevalence of obesity stands at 29.7%. Hence, it can be concluded that California has a healthier weight status as compared to Texas and national levels.
In conclusion, this assignment provides an insight into the obesity rates of two different states in the US. The data obtained through the CDC database helps in understanding the health status and behaviors of Americans. The analysis of the data can help in identifying the factors that contribute to obesity and the measures that can be taken to control it.