Data Analysis and Business Intelligence

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

Standard Error

Percent

Standard Error

United States

2012

267,829

47,312

17.7

0.2

220,517

82.3

0.2

2011

267,320

47,923

17.9

0.1

219,397

82.1

0.1

2010 (10)

266,776

49,159

18.4

0.2

217,617

81.6

0.2

Table 1: Number of People Covered and Not Covered by Health Insurance

Dashboard

The dashboard reveals the dataset of the health insurance coverage for people aged 65 and below. 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, however, the number increases to 82.3% in 2012.

Graphical features used

The figure 1 reveals the number of people aged 65 and below in the United States. The graph reveals that number of people in this age category increase between 2010 and 2012. As being revealed in Figure 2, the number of people not covered by the health insurance decreases between 2010 and 2012. However, Figure 3 reveals, the number of insured people in this age category increases between 2010 and 2012. Also, Figure 3 reveals, the number of insured people in this age category compares the number of uninsured people in this age category.

Figure 1: All people aged 65 years and Below

Figure 2: People aged 65 and below vs. number of uninsured

Figure 3: People aged 65 and below vs. number of insured

Figure 3: Insured vs. uninsured

Additionally, the rates of insured and uninsured vary among states. As being revealed in the Map 1, twenty-five states recorded an uninsured increase for people between in 2012, and the rest recorded a decline in the number of uninsured in the age category.

Map 1: 2012 health Insurance Coverage by States

Descriptive and predictive analytics used

Descriptive analytics is about to know what is happening in the organization and understand some underlying trends and causes of such occurrences. Predictive analytics aims to determine what is likely to happen in the future. This analysis is based on historical data to predict the trend in the future. This paper uses the linear trend line model for the predictive analysis. Using the linear trend line for the forecast in Fig 4, the insured people will increase from 2013 and will reach 221.6 Million by 2015. However, the forecast reveals that the uninsured people of 65 years and below will decline from 2013 and 2015. By 2013, the uninsured people will be 46.7 Million and will decline by 45.4 Million by 2015.

The following formula provides the strategy to arrive at the forecast between 2013 and 2015:

Y = ax + b (x means year)

Insured 2012= a*2012+b = 219,957

Insured 2011= a*2011+b = 219,397

a = Insured 2012- Insured 2011 = 560

b= 219,397 - (560)*2011= -906,763

So Insured people formula: y = 560x -- 906,763

According to the same calculation, uninsured people formula: y = -611a + 1,276,644

The overall forecasts for the insured and uninsured are revealed in the Table 3.

Uninsured

Insured

2010

49,159

217,617

2011

47,923

219,397

2012

47,312

219,957

Forecast

2013

46,701

220,517

2014

46,090

221,077

2015

45,479

221,637

Table 3: Forecasts for the Insured and Uninsured

Fig 4: Predictive Analysis for Insured and Uninsured

Year

All People

Number of Uninsured

SE

Percentage

SE

Number of People Insured

SE

Percentage

SE

United States

2012

267,829

47,312

17.7

0.2

220,517

82.3

0.2

2011

267,320

47,923

17.9

0.1

219,397

82.1

0.1

2010 (10)

266,776

49,159

18.4

0.2

217,617

81.6

0.2

Descriptive Statistics

Sum

801,926

144,394

1,230

54

0

657,532

1,253

0

Mean

267,309

48,131

18

0

219,177

82

0

Median

267,320

47,923

18

0

219,397

82

0

Table 4: Descriptive Statistics

Note: SE means standard error

Conclusion

The report provides evaluation of the health insurance coverage for people 65 years and below. The report collects the data of the health insurance coverage that covers the data between 2010 and 2012 using different statistical tools such as descriptive statistics, and linear trendline model for the predictive statistics. The findings reveal that uninsured people in this age category decline, while insured increases between 2010 and 2012 Moreover, the report predicts that insured will increase between 2013 and 2015, while the uninsured will decline between 2013 and 2015. The findings of this report will enhance a greater understanding of the policy makers about the health insurance coverage for people below 65 years of aged.