I realized that to understand police shootings, we need more than just one year of data. So I went to the Washington post and downloaded data from 2015 to 2023.
After getting enough data. I reviewed how 2023 is performing compared to last year data and I found out that till now there have been 708 police killing while 2022 being the highest with total of 1096.
Which state has higher diabetes percentage and what is physical inactivity and obesity of this state. Also which county among this states has a significant trend of diabetes and why is that?
The results of 2018, and 2016,2014,2010 Diabetes are as follows
Some of the top states are South Dakota and South Carolina
2018 Oglala Lakota County South Dakota 17.9% Williamsburg County South Carolina 17.2% Todd County South Dakota 15.9%
2016 Dillon County South Carolina 17.7% Williamsburg County South Carolina 17.0 % Oglala Lakota County South Dakota 16.6%
2014 Todd County South Dakota 16.9 Oglala Lakota County South Dakota 15.9 Ziebach County South Dakota 15.8 Allendale County South Carolina 15.3
2010 Orangeburg County South Carolina 13.7 Hampton County South Carolina 13.3
one thing to notice in 2010 South Dakota was not on the list. How come it became top in just 4 years? What happened?
One of the top counties was Todd County which topped among the list of diabetes.
2010 Todd County South Dakota 10.0 2012 Todd County South Dakota 15.0 2013 Todd County South Dakota 16.7 2014 Todd County South Dakota 16.9
Whereas physical inactivity data of Todd County has been decreased remarkably
2008 Todd County South Dakota 31.7 2009 Todd County South Dakota 28.1 2010 Todd County South Dakota 26.5 2011 Todd County South Dakota 26.4
Also, there has been a steep increase in obesity in Todd County since 2010
2010 Tood County South Dakota 27.0 2011 Todd County South Dakota 29.6 2012 Tood County South Dakota 34.3
Which state and county has lowest diabetes rate and why is that?How this county has performed on the basis of physical inactivity and diabetes?
Lowest-> The lowest county is Teton County Wyoming and Routt County Colorado and Wyoming County Utah every year analysis is below->
2010 2010 Teton County Wyoming 3.8 2010 Routt County Colorado 4.0 2010 Summit County Utah 4.0
2014 2014 Teton County Wyoming 4.2 2014 Boulder County Colorado 4.3 2014 Summit County Utah 4.0
2016 2016 Teton County Wyoming 3.8 2016 Boulder County Colorado 4.4 2016 Eagle County Colorado 4.4 2016 Douglas County Colorado 4.7 2016 Summit County Utah 4.1
2018 2018 Teton County Wyoming 3.8 2018 Summit County Utah 4.8
Outliers
Found outliers in all the data and removed them
Later got to know that outliers are not required to be removed. These are the measures of diabetes percentage in a country and there shouldn’t be any country with abnormal results.
So will have to look other metrices
A couple of things performed
