The situation that will be evaluated in this analysis will be; is there a region of the United States in which childhood obesity tends to be more prominent? This will be done to show areas in which the Government, insurance companies and healthcare institutions should focus campaigns for healthy living to reduce future healthcare cost. The data that will be utilized to answer this business question will be the percent of children ages ten to seventeen that are overweight or obese in each of the fifty states.
The states will then be categorized into their respective regions of East, South, Midwest, and West. It is important to look into the regions to see if there is a trend of obesity within a region, as this region should be the focal point of Government, insurance companies, and healthcare institutions to launch a healthy living campaign. Conducting such campaigns in a region of most need will in the long run, reduce healthcare cost because children will mature into health conscious individual with less preventable diseases.
Bal. Summary of Data Again the data that will be used in this analysis is the percentage of children ten to seventeen of which are overweight of obese in each of the fifty States ND the District of Columbia. The States will then be put into regions to identify a region that shows more overweight or obese children. The data for this analysis will come from “The Henry J. Kaiser Family Foundation (Henry J. Kaiser Family Foundation, 2015). “Len order to compare information their must be baseline in which to compare the date to.
For this analysis the base line will be the average percentage of children overweight or obese for the entire united State; the average is 31. 3 percent. Anything over this average can be attributed with raising the average and therefore in need of correction. For this analysis however the States will be put into regions and the regions will be compared to locate a trend of obesity by region of the county to implement campaigns of healthy living in those areas.
When the states are listed in way of highest percentage to lowest, at first glance can be seen that there are many of the Southern States in the top ten, to include Louisiana, Mississippi, and South Carolina being the top three, respectively. Outside of this it is difficult to locate another trend just by looking at a chart from lowest to highest percent, which is why a Cluster Analysis will be conducted to further investigate any trends, which will be discussed later in the report. Another piece of important information to take from the chart is that the highest percentage is 39. Percent (Louisiana) and the lowest being 22. 1 percent (Utah), which is a substantial difference that will hopefully be sorted out through the Cluster analysis. 82. Graphical Display Location percent Of Overweight or Obese Children 1. Louisiana 39. 8% 2. Mississippi 39. 7% 3. South Carolina 39. 2% 4. Arizona 36. 7% 5. Texas 36. 6% 6. North Dakota 35. 8% 7. Kentucky 35. 7% 8. Alabama 35. 0% 8. District of Columbia 8. Georgia 11. Tennessee 4. 1% 12. Arkansas 33. 9% 12. Oklahoma 14. Illinois 33. 6% 14. West Virginia 16. Nevada 33. 2% 17. New Mexico 32. % 18. Michigan 32. 6% 19. New York 32. 4% 20. Delaware 32. 0% 21. Maryland 31. 6% 22. Indiana 31. 5% 23. North Carolina 31. 4% United States 31. 3% 24. Ohio 30. 8% 25. Massachusetts 30. 5% 26. California 30. 4% 27. Kansas 30. 2% 28. Alaska 29. 9% 29. Virginia 29. 8% 30. Connecticut 29. 7% 31. Maine 29. 5% 32. Montana 29. 0% 33. Nebraska 28. 9% 34. Wisconsin 28. 8% 35. Missouri 28. 4% 36. Iowa 28. 3% 36. Rhode Island 38. Idaho 27. 8% 39. Florida 27. 5% 40. Hawaii 27. 4% 41. Minnesota 27. 2% 2. Wyoming 26. 7% 43. Pennsylvania 26. 5% 43. South Dakota 45.
Oregon 26. 4% 46. Washington 26. 2% 47. New Hampshire 26. 0% 48. New Jersey 24. 7% 49. Vermont 24. 5% 50. Colorado 23. 1% 51. Utah 22. 1% (Henry J. Kaiser Family Foundation, 2015) The chart that IS presented above is the data that was gathered for this analysis. It is listed from highest percentage of obese children to the lowest percentage. This information was gathered from the Kaiser Family Foundation to be the data the help answer they presented question (Henry J. Kaiser Family Foundation, 2015). 83. Advantages and Disadvantages of the
Data Gathering Methodology When gathering data there is inevitably advantages and disadvantages to the data that is collected. That statement hold true in this instance as well. One advantage of the methodology for collecting this data was how user friendly the information is. The table that is above is provided along with several other ways to view the data. For instance, the data can be looked at high to low as presented in this report, but also low to high. The table can also be looked at alphabetically for ease in being able to locate a certain State. These features are both an advantage to he gathering of this data.
Looking at them in high to low ascending order as presented allows hypotheses to be made about the information before formally utilizing the Cluster analysis. Also since this information is not about individual state but is however about regions of the Country, having the states in alphabetical order was advantages to completion of the analysis. One disadvantage for the methodology of gathering this data is its simplicity, meaning it is a hard percentage of overweight of obese children by state. It does not take into account socioeconomic standing of individuals, the means to live healthy, or the lifestyles of the individuals.
All of which can affect the overweight and obesity of the ten to seventeen year old children that exist in those systems. This information is however a great place to Start to see if a region does in fact tend to be more obese, or if it simply a County wide pandemic. If a region is found to be more obese more data gathering could then be conducted to answer such questions. Therefore as shown for this given data analysis the data gathering methodology is advantageous because of its ease of use and presentation, and also has a disadvantage of eyeing to broad. CLC .
Description of Analysis Technique The analysis technique that will be utilized to answer the question, Is there a trend of childhood (ten to seventeen years old) obesity regionally in the united States? Will be the Cluster analysis. The reason for choosing the Cluster analysis is used to group people or things together into meaningful clusters, in which these clusters share similar characteristics and differ from the other clusters in which they are being compared to. The similar characteristics in this analysis will be where they are regionally in the United States.
By putting each state into a cluster of other states within their respective regions it will become evident if there is in fact a correlation between obesity and region in the Country. If this analysis shows a relationship between children being overweight and obese in a certain region the Government, Insurance Companies, and Healthcare Systems can then implement healthy living campaigns focused in on the given region to improve childhood health and as they mature to be adults they can resume these habits as well as pass them on to their children, which will in the cut healthcare cost in the future.
Another reason of why the Cluster Analysis will be appropriate for this analysis will be that the information can be held on to and compared to future data that will show if the techniques are working or not, and if they are then the next at risk region can be approached with the same campaign approach as they will have been proven to work. CA. Output and Calculations The output for the cluster analysis was simply putting the raw data in order according to regions as described.
Then once that information was in the appropriate order it was simply a matter of putting the data into a simple “XX” rape and evaluating the clusters, looking for trends. Below is the way in which the states were grouped together in their similar respective regions. East South Midwest West Maine West Virginia 33. 60% Ohio 30. 80% Montana 29. 00% New Hampshire 26. 00% Virginia 29. 80% Michigan 32. 60% Wyoming 26. 70% Vermont 24. 50% Tennessee 34. 10% Illinois Colorado 23. 10% Massachusetts 30. 50% North Carolina 31 . 40% Indiana 31 . 50% New Mexico 32. 80% New York 32. 40% Kentucky 35. 70% owe 28. 30% Alaska 29. 0% Rhode Island Florida 27. 50% Incision 28. 80% Hawaii 27. 40% Connecticut 29. 70% Georgia 3500% Minnesota 2720% Idaho 27. 0% New Jersey 24. 70% South Carolina 39. 20% South Dakota 26. 50% Arizona 36. 70% Delaware 32. 00% Alabama 35. 00% North Dakota 35. 80% Utah 22. 10% Maryland 31. 60% Mississippi 39. 70% Nebraska 28. 90% Washington 26. 20% Pennsylvania Louisiana 39. 80% Kansas 30. 20% Oregon 26. 40% District Of Columbia Arkansas 33. 90% Missouri 28. 40% California 30. 40% Oklahoma Nevada 33. 20% Texas 36. 60% This information, as stated was then converted to a cluster analysis chart which can be seen in section ODL . CA.
Justification of Analysis Technique The justification for using the cluster analysis for this report was because of he large quantity of information. This large amount of information can, with this analysis technique be put into groups of similarity, which is this case is the location regionally to be compared to the other groups, in order to determine if there is a trend of a certain regions children being more predominantly obese than the others. The second reason the cluster analysis was utilized was to help with the follow-up action that would be taken if childhood obesity were discovered to be more severe in a given region.
Meaning that; in this case the south region was shown to have more obese children. The government, insurance companies, and healthcare institutions now have a target audience, being the southern region of the United States, in which to project their healthy life style campaign. By focusing efforts in a group which is similar will allow for greater success in accomplishing the goal, which in this case is to promote healthy living in children, leading to lower future healthcare cost and concerns. CA.
Advantages and disadvantages of the Analysis Technique NO analysis technique is perfect and will fully answer every question and concern that is presented. This statement is true in this case as well, as the luster analysis has both advantages and disadvantages. The advantage obtained by utilizing the cluster analysis is that large amounts of information can be placed into sub groups of which they share similarities. By do this a decision maker can look at large amounts of information and see how it all correlates by analyzing the cluster chart. This was most certainly the case in this particular report.
Fifty-one pieces of data were converted into four groups in which it became clear that the southern states as whole were in most need of intervention, as it pertains to childhood obesity. The fact that he south region is the most obese is made perfectly clear when looking at the chart. This was not the case when one looks at the graph of data; when doing this one sees that yes, the southern region has some high percentages, but that is true in all of the regions. However in looking at the graph the southern regions clearly outnumber the reset as a whole.
This is another advantage of the cluster analysis; it can make information evident that may not have been so previously. The disadvantage of the cluster analysis is that it only gives you an idea of what to further investigate. It is east to see that the out region has an issue with childhood obesity, the question now is why is this? Further more specific information must be determined in Order for one to bring about change. Another disadvantage of a cluster analysis is that there is no “rules” in reading or creating one.
They are mostly done by way of teaching ones ways to the next utilizing rule of thumb type approach. This can lead to the same information being presented differently depending on the techniques used, which can lead to inconsistency. D 1. Data Analysis Results When looking at the cluster analysis above it is made evident that the Southern Region of the Ignited States shows a tendency to be of greater percentage of children overweight or obese. Most all of the other regions seem to be relatively in the same area, with a few outliers which are the extremes and can be disregarded.
It is clear that there are more States in the Southern Region that have high percentages of children that are overweight, and therefore should be the focal point for healthy life style campaigns, the lead to a reduction in future healthcare cost. DO. Data Analysis Limitations When conducting an analysis that is driven by data it is important to insider the limitations that are present with the data. It is impossible fully answer every question in an analysis and recognizing the short comings of the data will allow for further investigation and lead to accuracy. The data utilized for this analysis is not an exception to this concept.
A limitation in this data is that the percentages presented are a whole states average. However this would be of great usefulness to investigate the state in different regions, as certain regions can be the contributors as where the other regions have minimal obese children. In all states there are areas of poverty, and areas of lath, this data does not show this type Of information, however this could be a contributing factor to the childhood and adolescent obesity of the state. The second limitation of this data that will be discussed is this data is for one year.
As one can see by the given data analysis results the Southern Region of the Ignited States is shown to be of greater childhood obesity that the other three regions. However if there was data from previous years it may show a trend in which although the Southern Region is highest it may be decreasing steadily. Also the data of past percentages may show that another egging is actually increasing dramatically and perhaps that region requires the attention of the campaign. The last limitation that will be discussed in this report is that the percentages do not take into account population of the regions.
Even though the Southern Region has the highest percentage, it may only have half the number of children of which are obese or overweight compared to a higher populated area of a lower percentage. This should be considered because it could be more advantageous to present healthier life styles to the overall greater number of people in a region instead of the area of fewer individuals tit a higher percentage. There are more limitations that present themselves in the data that was collected for this analysis; however the above discussed limitations present the most substantial shortcomings.
It is important to remember that limitations do not mean that the data is useless, because this data could present a trend that could then be further investigated addressing the limitations, allowing for a more complete picture of the question to be answered, and saving money by finding a large scale trend then narrowing it in from that point. DO. Recommended Course of Action The question this analysis set out to answer was, is there a region of the United States that has a higher percentage of children whom are obese?
The answer to this question, given the result of the analysis, is the Southern Region shows a higher trend, in percentage of children ten to seventeen of whom are overweight or obese. For this reason the Southern Region should be the focal point for the Government, insurance companies, and healthcare institutions to launch a healthy living campaign. Generally it has been accepted that childhood obesity leads to increased heath concerns, and Hereford healthcare cost of those children when they mature.
However according to a study conducted by Oxford University; results have shown that overweight and obese children, when compared to normal weight children may be worst than originally believed. The obese children tend to have significantly higher blood pressure and cholesterol levels.