Business Intelligence and Data Analysis Tableau Project

Dashboard

Health insurance coverage for people below 65 among states

Graphical features used

Descriptive and predictive analytics used

Population of Insured and Uninsured People aged 65 and below

The project evaluates the rates of insurance coverage for people aged 65 and below between 2010 and 2012 in all states in the United States. The report analyzes the data using several statistical tools such as descriptive statistics, predictive statistics, and linear treadline . The report identifies that the number of uninsured in this age category declines between 2010 and 2012. However, the number of insured in this age category increases between 2010 and 2012. Additionally, the rates of insured and uninsured vary between states. The twenty-five states recorded an increase in the number of uninsured between 2010 and 2012, and the rest recorded a decline in the number of uninsured.

Executive summary

Objective of this project is to evaluate the health insurance coverage for people less than 65 years between 2010 and 2012. Starting from 2008, ability of people to have access to private insurance is limited because of the economic downturn during the period. In essence, health insurance coverage was limited for people under 65 years of age because many people lost their jobs during the period. This report collects data of health insurance coverage between 2010 and 2012 for people below 65 years in all states in the United States. The data collected reveals the level of health insurance problem in the United States. The paper uses the two different websites to complete the study. They are:

http://www.census.gov/hhes/www/hlthins/data/index.html

http://www.tableausoftware.com/

The report chooses the age category of people under 65 years because these categories of people represent largest number of population in the United States. Based on the U.S. population estimates in 2013, people less than 65 years of age represent 85.5% of the total population. The table 1 reveals the total population of people in this age group and the number of people covered and not covered by the health insurance (Census. 2014).

Year

All People (Thousand)

Not Covered (Thousand)

Covered by Private or Government Health Insurance (Thousand)

Number

Standard Error

Percent

Standard Error

Number

The data reveal that people 65 years and above increase between 2010 and 2012, and population people aged 65 years and below are 266.7 million in 2010 and increase to 267.8 million in 2012. The dashboard also reveals number of insured and uninsured group in this age category. The data reveal that the number of uninsured decrease between 2010 and 2012. In 2010, the number of uninsured people are 49.1 Million and decrease to 47.3 Million in 2012. However, the number of insured people increase between 2010 and 2012. In 2010, the insured people were 217.6. Million in 2010 and increased to 220.5 Million in 2012. In essence, the chart reveals that uninsured decrease between 2010 and 2012, however, insured people increase between 2010 and 2012.
Based on the data from the Census (2014), the total number of the U.S. population is approximately 316 million where the population of people 65 years or below in 2010 are approximately 266.8 Million. The data in the dashboard shows that 49.15 million people in this age group are not covered by the health insurance in 2010, which is approximately 18.4% of people not covered by the health insurance. In 2011, population of people below 65 years increases to 267.3 Million. However, the number of people not covered by the health insurance is 47.9 Million. It decreases to 47.3 Million in 2012. Although, the number of people not covered by the health insurance decline between 2010 and 2012, however, there is no significant difference in the number of uninsured people. As being revealed in the Table 1, number of people not covered by the health insurance declines from 49.15% in 2010 to 47.3% in 2012. Similarly, the number of people covered by the private and government health insurance increases between 2010 and 2012. In 2010, 81.6% of people aged 65 or below are insured,…