Health insurance coverage for people under 65 by state, 2010-2012
✍️ How to write this paper — guide & tools ▾
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
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.
The report uses the Tableau 3.2 software for both descriptive analysis and predictive analysis. Overview of the Tableau shows that it is very effective in presenting the data analysis and as well as doing forecast. Typically, the Tableau delivers a clean visual presentation of the charts and graphs as being revealed in Fig 2, Fig 3 and Fig, 4. Comparative analysis of the Tableau such as Excel shows that the Tableau delivers better charts for the predictive analysis chart. However, the Tableau can still be improved to support expanded analysis such as Box Plot, tree map, Profile chart, 3D- and Scatter plot.
Reference
Census (2014). State & County QuickFacts. United States Census Bureau.
Census (2014). Health Insurance Historical Tables - HIB Series. United States Census Bureau.
Appendices
Appendix A: Population of Insured and Uninsured People aged 65 and Below
Not Covered
Covered by the Government or Private Health Insurance
Year
All People
Number
SE
Percentage
SE
Number
SE
Percetage
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
Alabama
2012
4,163
48
17.1
1.1
3,453
59
82.9
1.1
2011
4,138
57
14.8
1.4
3,527
90
85.2
1.4
2010 (10)
4,064
60
17.5
1.6
3,352
82.5
1.6
Alaska
2012
10
20.7
1.5
10
79.3
1.5
2011
10
19.6
1.6
12
80.4
1.6
2010 (10)
8
19.4
1.2
10
80.6
1.2
Arizona
2012
5,671
1,172
81
20.7
1.4
4,499
99
79.3
1.4
2011
5,708
1,108
77
19.4
1.3
4,599
89
80.6
1.3
2010 (10)
5,656
1,206
81
21.3
1.4
4,450
94
78.7
1.4
Arkansas
2012
2,455
41
21.4
1.6
1,930
43
78.6
1.6
2011
2,447
36
20.2
1.4
1,952
44
79.8
1.4
2010 (10)
2,445
43
21.0
1.8
1,931
55
79.0
1.8
California
2012
33,501
6,695
20.0
0.5
26,806
80.0
0.5
2011
33,278
7,290
21.9
0.5
25,988
78.1
0.5
2010 (10)
32,966
7,070
21.4
0.5
25,896
78.6
0.5
Colorado
2012
4,532
40
15.4
0.9
3,836
58
84.6
0.9
2011
4,415
49
17.6
1.1
3,637
61
82.4
1.1
2010 (10)
4,453
39
14.4
0.9
3,810
57
85.6
0.9
Connecticut
2012
3,008
25
9.2
0.8
2,732
36
90.8
0.8
2011
3,014
24
9.8
0.8
2,719
37
90.2
0.8
2010 (10)
3,076
27
12.6
0.9
2,690
38
87.4
0.9
Delaware
2012
96
8
12.7
1.1
12
87.3
1.1
2011
90
7
11.6
0.9
10
88.4
0.9
2010 (10)
98
8
12.8
1.0
11
87.2
1.0
District of Columbia
2012
49
5
8.8
0.8
7
91.2
0.8
2011
51
5
9.3
0.9
7
90.7
0.9
2010 (10)
75
7
14.2
1.3
8
85.8
1.3
Florida
2012
15,773
4,045
25.6
0.8
11,728
74.4
0.8
2011
15,603
3,689
23.6
0.7
11,914
76.4
0.7
2010 (10)
15,519
3,812
24.6
0.9
11,707
75.4
0.9
Georgia
2012
8,504
1,845
21.7
1.2
6,660
96
78.3
1.2
2011
8,692
1,855
89
21.3
1.0
6,838
78.7
1.0
2010 (10)
8,727
1,857
21.3
1.3
6,870
78.7
1.3
Hawaii
2012
1,141
9
9.1
0.8
1,037
13
90.9
0.8
2011
1,146
9
8.8
0.8
1,044
14
91.2
0.8
2010 (10)
1,117
98
10
8.8
0.9
1,019
16
91.2
0.9
Idaho
2012
1,347
30
18.7
2.3
1,095
39
81.3
2.3
2011
1,355
25
19.5
1.8
1,090
31
80.5
1.8
2010 (10)
1,353
23
21.7
1.7
1,060
29
78.3
1.7
Illinois
2012
10,945
1,700
86
15.5
0.7
9,245
97
84.5
0.7
2011
11,025
1,845
83
16.7
0.7
9,180
83.3
0.7
2010 (10)
11,211
1,868
16.7
1.0
9,342
83.3
1.0
Indiana
2012
5,411
59
15.6
1.1
4,567
93
84.4
1.1
2011
5,444
63
13.9
1.1
4,685
93
86.1
1.1
2010 (10)
5,539
66
15.2
1.2
4,697
92
84.8
1.2
Iowa
2012
2,588
17
11.7
0.6
2,285
24
88.3
0.6
2011
2,631
22
11.4
0.8
2,331
31
88.6
0.8
2010 (10)
2,619
34
13.7
1.3
2,260
42
86.3
1.3
Kansas
2012
2,414
28
14.8
1.2
2,058
44
85.2
1.2
2011
2,408
24
15.8
1.0
2,028
43
84.2
1.0
2010 (10)
2,391
29
14.6
1.3
2,042
45
85.4
1.3
Kentucky
2012
3,779
44
18.0
1.2
3,101
65
82.0
1.2
2011
3,734
46
16.5
1.2
3,118
62
83.5
1.2
2010 (10)
3,732
51
16.9
1.4
3,100
74
83.1
1.4
Louisiana
2012
3,865
53
20.8
1.2
3,059
55
79.2
1.2
2011
3,884
49
23.9
1.2
2,956
58
76.1
1.2
2010 (10)
3,879
48
22.3
1.3
3,014
72
77.7
1.3
Maine
2012
1,120
11
11.2
1.0
17
88.8
1.0
2011
1,126
13
11.8
1.1
16
88.2
1.1
2010 (10)
1,083
9
11.1
0.9
15
88.9
0.9
Maryland
2012
5,124
53
14.1
1.0
4,404
70
85.9
1.0
2011
5,065
48
15.6
0.9
4,274
63
84.4
0.9
2010 (10)
5,087
48
14.3
1.0
4,361
68
85.7
1.0
Massachusetts
2012
5,584
33
4.8
0.6
5,313
70
95.2
0.6
2011
5,587
29
3.8
0.5
5,372
67
96.2
0.5
2010 (10)
5,595
39
6.2
0.7
5,248
67
93.8
0.7
Michigan
2012
8,198
1,045
71
12.7
0.9
7,153
87.3
0.9
2011
8,319
1,176
70
14.1
0.9
7,144
85.9
0.9
2010 (10)
8,402
1,251
69
14.9
0.8
7,151
85.1
0.8
Minnesota
2012
4,626
49
9.6
1.0
4,183
62
90.4
1.0
2011
4,571
35
10.6
0.8
4,088
65
89.4
0.8
2010 (10)
4,528
29
11.1
0.6
4,025
49
88.9
0.6
Mississippi
2012
2,472
41
17.8
1.6
2,031
50
82.2
1.6
2011
2,553
44
18.3
1.7
2,087
46
81.7
1.7
2010 (10)
2,534
39
24.1
1.4
1,924
38
75.9
1.4
Missouri
2012
5,066
76
15.6
1.5
4,274
91
84.4
1.5
2011
5,062
86
17.3
1.7
4,186
91
82.7
1.7
2010 (10)
5,128
64
16.1
1.3
4,302
90
83.9
1.3
Montana
2012
18
21.8
2.2
21
78.2
2.2
2011
12
22.0
1.5
15
78.0
1.5
2010 (10)
12
21.4
1.5
21
78.6
1.5
Nebraska
2012
1,594
20
15.3
1.3
1,350
27
84.7
1.3
2011
1,586
16
14.1
1.0
1,363
25
85.9
1.0
2010 (10)
1,581
14
14.9
0.9
1,345
22
85.1
0.9
Nevada
2012
2,369
37
26.9
1.6
1,732
46
73.1
1.6
2011
2,330
32
25.9
1.4
1,726
42
74.1
1.4
2010 (10)
2,381
36
24.0
1.5
1,809
43
76.0
1.5
New Hamsphere
2012
1,123
10
13.8
0.9
14
86.2
0.9
2011
1,118
11
14.5
1.0
16
85.5
1.0
2010 (10)
1,122
10
11.7
0.9
15
88.3
0.9
New Jersey
2012
7,451
1,189
73
16.0
1.0
6,263
84.0
1.0
2011
7,439
1,313
76
17.6
1.0
6,126
82.4
1.0
2010 (10)
7,608
1,340
94
17.6
1.2
6,268
82.4
1.2
New Mexico
2012
1,764
37
25.5
2.1
1,314
42
74.5
2.1
2011
1,719
39
22.9
2.3
1,326
50
77.1
2.3
2010 (10)
1,746
33
24.6
1.8
1,317
33
75.4
1.8
New York
2012
16,512
2,137
12.9
0.6
14,374
87.1
0.6
2011
16,706
2,304
13.8
0.6
14,402
86.2
0.6
2010 (10)
16,637
2,812
16.9
0.8
13,825
83.1
0.8
North Carolina
2012
8,144
1,647
94
20.2
1.1
6,497
79.8
1.1
2011
8,197
1,540
94
18.8
1.1
6,657
81.2
1.1
2010 (10)
8,198
1,592
92
19.4
1.1
6,606
80.6
1.1
North Dakota
2012
79
10
12.9
1.5
11
87.1
1.5
2011
61
9
10.5
1.6
12
89.5
1.6
2010 (10)
87
6
15.5
1.1
9
84.5
1.1
Ohio
2012
9,622
1,388
74
14.4
0.8
8,235
85.6
0.8
2011
9,650
1,534
87
15.9
0.9
8,116
90
84.1
0.9
2010 (10)
9,840
1,521
89
15.5
0.9
8,320
99
84.5
0.9
Oklahoma
2012
3,208
42
19.8
1.4
2,573
70
80.2
1.4
2011
3,225
37
19.6
1.2
2,594
50
80.4
1.2
2010 (10)
3,187
50
20.1
1.5
2,548
53
79.9
1.5
Oregon
2012
3,329
46
17.7
1.4
2,739
60
82.3
1.4
2011
3,294
37
16.0
1.1
2,766
50
84.0
1.1
2010 (10)
3,249
42
18.6
1.3
2,646
51
81.4
1.3
Pennsylavania
2012
10,832
1,493
13.8
1.0
9,339
86.2
1.0
2011
10,696
1,361
87
12.7
0.8
9,335
87.3
0.8
2010 (10)
10,512
1,357
90
12.9
0.9
9,156
87.1
0.9
Rhode Island
2012
8
14.5
1.0
12
85.5
1.0
2011
9
14.0
1.1
14
86.0
1.1
2010 (10)
9
13.2
1.0
14
86.8
1.0
South Carolina
2012
4,002
52
16.4
1.3
3,348
79
83.6
1.3
2011
3,971
72
22.1
1.9
3,095
99
77.9
1.9
2010 (10)
3,906
51
23.7
1.3
2,980
56
76.3
1.3
South Dakota
2012
8
16.7
1.2
12
83.3
1.2
2011
8
15.0
1.2
12
85.0
1.2
2010 (10)
7
15.1
1.0
11
84.9
1.0
Tennessee
2012
5,430
70
16.1
1.3
4,556
90
83.9
1.3
2011
5,485
55
15.0
1.0
4,660
71
85.0
1.0
2010 (10)
5,525
68
16.5
1.2
4,611
89
83.5
1.2
Texas
2012
23,302
6,335
27.2
0.8
16,968
72.8
0.8
2011
22,878
5,998
26.2
0.7
16,880
73.8
0.7
2010 (10)
22,644
6,107
27.0
0.9
16,536
73.0
0.9
Utah
2012
2,580
35
15.8
1.5
2,173
57
84.2
1.5
2011
2,541
30
16.0
1.2
2,135
41
84.0
1.2
2010 (10)
2,477
29
15.3
1.2
2,097
40
84.7
1.2
Vermont
2012
43
4
8.4
0.8
8
91.6
0.8
2011
53
5
10.1
0.9
7
89.9
0.9
2010 (10)
58
5
10.6
0.9
8
89.4
0.9
Virginia
2012
6,942
65
14.2
1.0
5,958
96
85.8
1.0
2011
6,914
1,057
58
15.3
0.8
5,856
84
84.7
0.8
2010 (10)
6,934
1,089
64
15.7
0.9
5,845
90
84.3
0.9
Washington
2012
5,991
61
15.5
1.0
5,065
81
84.5
1.0
2011
5,952
72
16.3
1.1
4,983
65
83.7
1.1
2010 (10)
5,845
66
15.8
1.1
4,919
71
84.2
1.1
West Virginia
2012
1,507
22
17.5
1.4
1,244
22
82.5
1.4
2011
1,578
17
17.1
1.1
1,308
39
82.9
1.1
2010 (10)
1,567
26
15.4
1.7
1,326
35
84.6
1.7
Wisconsin
2012
4,866
50
11.2
1.0
4,320
73
88.8
1.0
2011
4,880
55
12.0
1.1
4,293
68
88.0
1.1
2010 (10)
4,785
44
10.9
0.9
4,264
64
89.1
0.9
Wyoming
2012
87
7
17.6
1.3
8
82.4
1.3
2011
8
20.1
1.4
7
79.9
1.4
2010 (10)
Create your account
Always verify citation format against your institution’s current style guide requirements.