I need Confidence of intervals using this data and how to implement it in excel!
ID: 3068585 • Letter: I
Question
I need Confidence of intervals using this data and how to implement it in excel!!!!
county state college income white black Crawford IN 5.7 23307 99.53601 0.090781 Orange IN 6 24813 98.9353 0.68988 Scott IN 6.6 25542 99.32829 0.076223 Starke IN 6 26525 98.67675 0.320921 Washington IN 6.8 26564 99.61209 0.096977 Daviess IN 7.6 27074 99.41525 0.359569 Owen IN 7.1 27207 99.34032 0.254615 Sullivan IN 10 27260 99.53667 0.078976 Greene IN 9.9 27426 99.46728 0.032884 Miami IN 9.7 27435 94.27325 3.021926 Switzerland IN 5.6 27608 99.4443 0.193849 Martin IN 8.6 27628 99.53708 0.11573 Jay IN 8.2 27720 99.07494 0.139457 Knox IN 11.1 27732 98.05185 1.218534 Wayne IN 11.3 27905 93.85832 5.274423 Pike IN 8.5 27927 99.68023 0.023983 Union IN 8.4 27975 99.12557 0.286697 Randolph IN 8.6 28551 99.25961 0.206277 Perry IN 6.8 28666 98.4927 1.099074 Clay IN 9.8 28727 99.25926 0.457397 Fountain IN 7.6 28770 99.53954 0.022462 Jennings IN 6.5 28787 98.67292 0.88331 Parke IN 10.1 28921 98.78001 0.765737 Vermillion IN 7.8 29100 99.50516 0.089429 Warren IN 9.4 29271 99.55968 0.012231 Rush IN 8.7 29395 98.74235 0.783275 Jefferson IN 13.3 29608 97.93268 1.218243 Lagrange IN 7.3 29843 98.91102 0.149269 Vigo IN 18.1 29871 92.74694 5.575504 Fulton IN 9.4 30000 98.48726 0.801486 Lawrence IN 9.4 30105 99.29965 0.254459 Blackford IN 8.9 30125 99.36732 0.049762 Jackson IN 8.7 30191 98.83117 0.365757 Pulaski IN 8.9 30276 98.94012 0.514118 Ohio IN 6 30279 98.87112 0.771402 White IN 10.7 30459 99.40684 0.008597 Fayette IN 8.1 30543 97.87431 1.672112 Henry IN 9.2 30579 98.56042 0.984649 Benton IN 9.2 30935 99.44921 0.063553 Wabash IN 11.7 31030 98.26913 0.39351 Cass IN 9 31049 98.31307 0.859084 Grant IN 11.2 31050 91.43578 6.80473 Clinton IN 11 31070 98.97656 0.116227 Harrison IN 8.4 31160 99.16695 0.414854 Ripley IN 9.8 31715 99.53282 0.064998 Delaware IN 16.5 31724 92.95749 5.98952 Franklin IN 8.2 31770 99.57099 0.051073 Marshall IN 12.3 31792 98.40216 0.180172 Putnam IN 11.3 31892 96.30876 2.724724 Gibson IN 9.1 32080 97.59659 1.867577 Clark IN 11.2 32172 93.7478 5.357895 Jasper IN 10.8 32288 98.79407 0.444712 Decatur IN 9.7 32312 99.14993 0.16494 Adams IN 10.7 32314 98.18299 0.115774 Brown IN 15.2 32405 99.20454 0.09233 Newton IN 8.1 32513 99.15135 0.066416 Vanderburgh IN 16 32558 91.61385 7.518569 Carroll IN 10 32816 99.52682 0.101015 Monroe IN 32.9 32859 94.28692 2.601443 Floyd IN 15.1 33085 95.35899 4.10223 La Porte IN 11.7 33198 89.93144 8.947752 Montgomery IN 12.8 33311 98.64967 0.583691 Madison IN 11.7 33332 91.63153 7.553437 Huntington IN 11.8 33402 98.82858 0.146781 Spencer IN 9.2 33618 98.99949 0.569523 Noble IN 8 33757 98.8885 0.153127 Steuben IN 12.5 33882 98.90694 0.185819 St. Joseph IN 19.2 34206 87.82928 9.791461 Shelby IN 9.9 34422 98.60074 0.818716 De Kalb IN 9.9 34853 99.10825 0.104745 Marion IN 21.4 35054 77.15387 21.28233 Elkhart IN 14.2 35152 93.79442 4.549354 Whitley IN 8.8 35457 99.35626 0.104879 Kosciusko IN 14.4 35548 98.10703 0.473244 Lake IN 12.8 35604 70.27065 24.53521 Dearborn IN 10.7 35711 98.98288 0.648899 Wells IN 12.1 36001 99.26777 0.038539 Tippecanoe IN 30.7 36073 93.42639 2.036785 Tipton IN 9.8 36127 99.1997 0.062039 Bartholomew IN 16.9 36195 97.04196 1.578774 Dubois IN 10.9 36293 99.59034 0.090125 Posey IN 11 36333 98.53666 1.089803 Morgan IN 10 36462 99.49034 0.016094 Howard IN 14.3 36902 93.3104 5.441251 Allen IN 19 37866 87.78404 10.07659 Warrick IN 16.2 38375 98.56189 0.825913 Johnson IN 16.7 39687 98.12278 0.959039 Boone IN 22.2 40485 99.12706 0.217579 Hancock IN 14.9 41887 99.22244 0.096646 Porter IN 18.5 41929 97.98111 0.352124 Hendricks IN 18.2 44257 98.41779 0.904685 Hamilton IN 36.2 51167 98.00617 0.620548Explanation / Answer
Minimum.
county
state
college
income
white
black
Crawford
IN
5.7
23307
99.53601
0.090781
Orange
IN
6
24813
98.9353
0.68988
Scott
IN
6.6
25542
99.32829
0.076223
Starke
IN
6
26525
98.67675
0.320921
Washington
IN
6.8
26564
99.61209
0.096977
Daviess
IN
7.6
27074
99.41525
0.359569
Owen
IN
7.1
27207
99.34032
0.254615
Sullivan
IN
10
27260
99.53667
0.078976
Greene
IN
9.9
27426
99.46728
0.032884
Miami
IN
9.7
27435
94.27325
3.021926
Switzerland
IN
5.6
27608
99.4443
0.193849
Martin
IN
8.6
27628
99.53708
0.11573
Jay
IN
8.2
27720
99.07494
0.139457
Knox
IN
11.1
27732
98.05185
1.218534
Wayne
IN
11.3
27905
93.85832
5.274423
Pike
IN
8.5
27927
99.68023
0.023983
Union
IN
8.4
27975
99.12557
0.286697
Randolph
IN
8.6
28551
99.25961
0.206277
Perry
IN
6.8
28666
98.4927
1.099074
Clay
IN
9.8
28727
99.25926
0.457397
Fountain
IN
7.6
28770
99.53954
0.022462
Jennings
IN
6.5
28787
98.67292
0.88331
Parke
IN
10.1
28921
98.78001
0.765737
Vermillion
IN
7.8
29100
99.50516
0.089429
Warren
IN
9.4
29271
99.55968
0.012231
Rush
IN
8.7
29395
98.74235
0.783275
Jefferson
IN
13.3
29608
97.93268
1.218243
Lagrange
IN
7.3
29843
98.91102
0.149269
Vigo
IN
18.1
29871
92.74694
5.575504
Fulton
IN
9.4
30000
98.48726
0.801486
Lawrence
IN
9.4
30105
99.29965
0.254459
Blackford
IN
8.9
30125
99.36732
0.049762
Jackson
IN
8.7
30191
98.83117
0.365757
Pulaski
IN
8.9
30276
98.94012
0.514118
Ohio
IN
6
30279
98.87112
0.771402
White
IN
10.7
30459
99.40684
0.008597
Fayette
IN
8.1
30543
97.87431
1.672112
Henry
IN
9.2
30579
98.56042
0.984649
Benton
IN
9.2
30935
99.44921
0.063553
Wabash
IN
11.7
31030
98.26913
0.39351
Cass
IN
9
31049
98.31307
0.859084
Grant
IN
11.2
31050
91.43578
6.80473
Clinton
IN
11
31070
98.97656
0.116227
Harrison
IN
8.4
31160
99.16695
0.414854
Ripley
IN
9.8
31715
99.53282
0.064998
Delaware
IN
16.5
31724
92.95749
5.98952
Franklin
IN
8.2
31770
99.57099
0.051073
Marshall
IN
12.3
31792
98.40216
0.180172
Putnam
IN
11.3
31892
96.30876
2.724724
Gibson
IN
9.1
32080
97.59659
1.867577
Clark
IN
11.2
32172
93.7478
5.357895
Jasper
IN
10.8
32288
98.79407
0.444712
Decatur
IN
9.7
32312
99.14993
0.16494
Adams
IN
10.7
32314
98.18299
0.115774
Brown
IN
15.2
32405
99.20454
0.09233
Newton
IN
8.1
32513
99.15135
0.066416
Vanderburgh
IN
16
32558
91.61385
7.518569
Carroll
IN
10
32816
99.52682
0.101015
Monroe
IN
32.9
32859
94.28692
2.601443
Floyd
IN
15.1
33085
95.35899
4.10223
La Porte
IN
11.7
33198
89.93144
8.947752
Montgomery
IN
12.8
33311
98.64967
0.583691
Madison
IN
11.7
33332
91.63153
7.553437
Huntington
IN
11.8
33402
98.82858
0.146781
Spencer
IN
9.2
33618
98.99949
0.569523
Noble
IN
8
33757
98.8885
0.153127
Steuben
IN
12.5
33882
98.90694
0.185819
St. Joseph
IN
19.2
34206
87.82928
9.791461
Shelby
IN
9.9
34422
98.60074
0.818716
De Kalb
IN
9.9
34853
99.10825
0.104745
Marion
IN
21.4
35054
77.15387
21.28233
Elkhart
IN
14.2
35152
93.79442
4.549354
Whitley
IN
8.8
35457
99.35626
0.104879
Kosciusko
IN
14.4
35548
98.10703
0.473244
Lake
IN
12.8
35604
70.27065
24.53521
Dearborn
IN
10.7
35711
98.98288
0.648899
Wells
IN
12.1
36001
99.26777
0.038539
Tippecanoe
IN
30.7
36073
93.42639
2.036785
Tipton
IN
9.8
36127
99.1997
0.062039
Bartholomew
IN
16.9
36195
97.04196
1.578774
Dubois
IN
10.9
36293
99.59034
0.090125
Posey
IN
11
36333
98.53666
1.089803
Morgan
IN
10
36462
99.49034
0.016094
Howard
IN
14.3
36902
93.3104
5.441251
Allen
IN
19
37866
87.78404
10.07659
Warrick
IN
16.2
38375
98.56189
0.825913
Johnson
IN
16.7
39687
98.12278
0.959039
Boone
IN
22.2
40485
99.12706
0.217579
Hancock
IN
14.9
41887
99.22244
0.096646
Porter
IN
18.5
41929
97.98111
0.352124
Hendricks
IN
18.2
44257
98.41779
0.904685
Hamilton
IN
36.2
51167
98.00617
0.620548
Confidence interval=
10.5624129619162±12.794108777214
31247.1061312821±33075.7199556745
96.2825119483177±98.1317645734215
1.07569444518343±2.70497562003396
We used excel for finding the confidence interval :
Step-1: you select analytic tool in excel
Step-2: select descriptive option in the analytic tool
Step-3: click on the confidence interval
Descriptives
Statistic
Std. Error
college
Mean
11.678261
.5617503
95% Confidence Interval for Mean
Lower Bound
10.562413
Upper Bound
12.794109
5% Trimmed Mean
11.022464
Median
10.000000
Variance
29.032
Std. Deviation
5.3881193
Minimum
5.6000
Maximum
36.2000
Range
30.6000
Interquartile Range
4.2000
Skewness
2.378
.251
Kurtosis
7.252
.498
income
Mean
32161.41
460.289
95% Confidence Interval for Mean
Lower Bound
31247.11
Upper Bound
33075.72
5% Trimmed Mean
31874.32
Median
31747.00
Variance
19491641.278
Std. Deviation
4414.934
Minimum
23307
Maximum
51167
Range
27860
Interquartile Range
5780
Skewness
1.230
.251
Kurtosis
3.183
.498
white
Mean
97.207138
.4654838
95% Confidence Interval for Mean
Lower Bound
96.282512
Upper Bound
98.131765
5% Trimmed Mean
97.921142
Median
98.829875
Variance
19.934
Std. Deviation
4.4647634
Minimum
70.2707
Maximum
99.6802
Range
29.4096
Interquartile Range
1.3469
Skewness
-3.809
.251
Kurtosis
17.941
.498
black
Mean
1.890335
.4101138
95% Confidence Interval for Mean
Lower Bound
1.075694
Upper Bound
2.704976
5% Trimmed Mean
1.241338
Median
.429783
Variance
15.474
Std. Deviation
3.9336729
Minimum.
Maximum
24.5352
Range
24.5266
Interquartile Range
1.1137
Skewness
3.833
.251
Kurtosis
17.455
.498
county
state
college
income
white
black
Crawford
IN
5.7
23307
99.53601
0.090781
Orange
IN
6
24813
98.9353
0.68988
Scott
IN
6.6
25542
99.32829
0.076223
Starke
IN
6
26525
98.67675
0.320921
Washington
IN
6.8
26564
99.61209
0.096977
Daviess
IN
7.6
27074
99.41525
0.359569
Owen
IN
7.1
27207
99.34032
0.254615
Sullivan
IN
10
27260
99.53667
0.078976
Greene
IN
9.9
27426
99.46728
0.032884
Miami
IN
9.7
27435
94.27325
3.021926
Switzerland
IN
5.6
27608
99.4443
0.193849
Martin
IN
8.6
27628
99.53708
0.11573
Jay
IN
8.2
27720
99.07494
0.139457
Knox
IN
11.1
27732
98.05185
1.218534
Wayne
IN
11.3
27905
93.85832
5.274423
Pike
IN
8.5
27927
99.68023
0.023983
Union
IN
8.4
27975
99.12557
0.286697
Randolph
IN
8.6
28551
99.25961
0.206277
Perry
IN
6.8
28666
98.4927
1.099074
Clay
IN
9.8
28727
99.25926
0.457397
Fountain
IN
7.6
28770
99.53954
0.022462
Jennings
IN
6.5
28787
98.67292
0.88331
Parke
IN
10.1
28921
98.78001
0.765737
Vermillion
IN
7.8
29100
99.50516
0.089429
Warren
IN
9.4
29271
99.55968
0.012231
Rush
IN
8.7
29395
98.74235
0.783275
Jefferson
IN
13.3
29608
97.93268
1.218243
Lagrange
IN
7.3
29843
98.91102
0.149269
Vigo
IN
18.1
29871
92.74694
5.575504
Fulton
IN
9.4
30000
98.48726
0.801486
Lawrence
IN
9.4
30105
99.29965
0.254459
Blackford
IN
8.9
30125
99.36732
0.049762
Jackson
IN
8.7
30191
98.83117
0.365757
Pulaski
IN
8.9
30276
98.94012
0.514118
Ohio
IN
6
30279
98.87112
0.771402
White
IN
10.7
30459
99.40684
0.008597
Fayette
IN
8.1
30543
97.87431
1.672112
Henry
IN
9.2
30579
98.56042
0.984649
Benton
IN
9.2
30935
99.44921
0.063553
Wabash
IN
11.7
31030
98.26913
0.39351
Cass
IN
9
31049
98.31307
0.859084
Grant
IN
11.2
31050
91.43578
6.80473
Clinton
IN
11
31070
98.97656
0.116227
Harrison
IN
8.4
31160
99.16695
0.414854
Ripley
IN
9.8
31715
99.53282
0.064998
Delaware
IN
16.5
31724
92.95749
5.98952
Franklin
IN
8.2
31770
99.57099
0.051073
Marshall
IN
12.3
31792
98.40216
0.180172
Putnam
IN
11.3
31892
96.30876
2.724724
Gibson
IN
9.1
32080
97.59659
1.867577
Clark
IN
11.2
32172
93.7478
5.357895
Jasper
IN
10.8
32288
98.79407
0.444712
Decatur
IN
9.7
32312
99.14993
0.16494
Adams
IN
10.7
32314
98.18299
0.115774
Brown
IN
15.2
32405
99.20454
0.09233
Newton
IN
8.1
32513
99.15135
0.066416
Vanderburgh
IN
16
32558
91.61385
7.518569
Carroll
IN
10
32816
99.52682
0.101015
Monroe
IN
32.9
32859
94.28692
2.601443
Floyd
IN
15.1
33085
95.35899
4.10223
La Porte
IN
11.7
33198
89.93144
8.947752
Montgomery
IN
12.8
33311
98.64967
0.583691
Madison
IN
11.7
33332
91.63153
7.553437
Huntington
IN
11.8
33402
98.82858
0.146781
Spencer
IN
9.2
33618
98.99949
0.569523
Noble
IN
8
33757
98.8885
0.153127
Steuben
IN
12.5
33882
98.90694
0.185819
St. Joseph
IN
19.2
34206
87.82928
9.791461
Shelby
IN
9.9
34422
98.60074
0.818716
De Kalb
IN
9.9
34853
99.10825
0.104745
Marion
IN
21.4
35054
77.15387
21.28233
Elkhart
IN
14.2
35152
93.79442
4.549354
Whitley
IN
8.8
35457
99.35626
0.104879
Kosciusko
IN
14.4
35548
98.10703
0.473244
Lake
IN
12.8
35604
70.27065
24.53521
Dearborn
IN
10.7
35711
98.98288
0.648899
Wells
IN
12.1
36001
99.26777
0.038539
Tippecanoe
IN
30.7
36073
93.42639
2.036785
Tipton
IN
9.8
36127
99.1997
0.062039
Bartholomew
IN
16.9
36195
97.04196
1.578774
Dubois
IN
10.9
36293
99.59034
0.090125
Posey
IN
11
36333
98.53666
1.089803
Morgan
IN
10
36462
99.49034
0.016094
Howard
IN
14.3
36902
93.3104
5.441251
Allen
IN
19
37866
87.78404
10.07659
Warrick
IN
16.2
38375
98.56189
0.825913
Johnson
IN
16.7
39687
98.12278
0.959039
Boone
IN
22.2
40485
99.12706
0.217579
Hancock
IN
14.9
41887
99.22244
0.096646
Porter
IN
18.5
41929
97.98111
0.352124
Hendricks
IN
18.2
44257
98.41779
0.904685
Hamilton
IN
36.2
51167
98.00617
0.620548
Confidence interval=
10.5624129619162±12.794108777214
31247.1061312821±33075.7199556745
96.2825119483177±98.1317645734215
1.07569444518343±2.70497562003396
We used excel for finding the confidence interval :
Step-1: you select analytic tool in excel
Step-2: select descriptive option in the analytic tool
Step-3: click on the confidence interval
Descriptives
Statistic
Std. Error
college
Mean
11.678261
.5617503
95% Confidence Interval for Mean
Lower Bound
10.562413
Upper Bound
12.794109
5% Trimmed Mean
11.022464
Median
10.000000
Variance
29.032
Std. Deviation
5.3881193
Minimum
5.6000
Maximum
36.2000
Range
30.6000
Interquartile Range
4.2000
Skewness
2.378
.251
Kurtosis
7.252
.498
income
Mean
32161.41
460.289
95% Confidence Interval for Mean
Lower Bound
31247.11
Upper Bound
33075.72
5% Trimmed Mean
31874.32
Median
31747.00
Variance
19491641.278
Std. Deviation
4414.934
Minimum
23307
Maximum
51167
Range
27860
Interquartile Range
5780
Skewness
1.230
.251
Kurtosis
3.183
.498
white
Mean
97.207138
.4654838
95% Confidence Interval for Mean
Lower Bound
96.282512
Upper Bound
98.131765
5% Trimmed Mean
97.921142
Median
98.829875
Variance
19.934
Std. Deviation
4.4647634
Minimum
70.2707
Maximum
99.6802
Range
29.4096
Interquartile Range
1.3469
Skewness
-3.809
.251
Kurtosis
17.941
.498
black
Mean
1.890335
.4101138
95% Confidence Interval for Mean
Lower Bound
1.075694
Upper Bound
2.704976
5% Trimmed Mean
1.241338
Median
.429783
Variance
15.474
Std. Deviation
3.9336729
Minimum.
Maximum
24.5352
Range
24.5266
Interquartile Range
1.1137
Skewness
3.833
.251
Kurtosis
17.455
.498
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.