To discover why the rate of change in diabetes’ percentages was lower from 2010-2019, I am calculating the average rate of change for each individual year in this time frame. I will then plot these averages to see what years see peaks and what years see dips in the percentages.
Statistical Difference
The distributions for the rate of change for each 9-year period are close to normal. This allows for a t-test to be done to test for statistical difference between the two means. The t-test returned a p-value of 0.000237442. This means that there is a statistically significant difference between the average for 2001/2010 and 2010/2019.
Average Rate of Change
After finding the rate of change for each state, I calculated the average rate of change of all the states for each time period.
2001-2010: 0.214667
2010-2019: 0.153111
The heatmaps showed some states with a fluctuating rate of change, where they have a great increase over 9 years and then a decrease over another 9 years. I plan to key in on these states and perhaps what year sees the most change.
Heatmaps
I’ve created heatmaps for the rate of change in the percentage of diagnosed diabetes for 2001 to 2010, and 2010 to 2019.
Rate of Change Heatmaps
I have found the rate of change for the diabetes percentages for each state from 2001 to 2010, and then again from 2010 to 2019. I plan to plot these ratios to show which states show the greatest increase/decrease for these time spans.
More Data
The CDC has data from 2000 to 2020 on the percentage of adults diagnosed with diabetes by state as well as by county. I will be using this additional data in my analysis. The data can be found here: https://gis.cdc.gov/grasp/diabetes/diabetesatlas-surveillance.html#
New Dataset
For the second half of the semester, I will be studying the incidence of diagnosed Type II Diabetes found here: https://www.dropbox.com/s/c1frbp04bcrzhdv/DiabetesAtlas_CountyData.xlsx?dl=0