Question

In: Statistics and Probability

county state college income white black Crawford IN 5.7 23307 99.53601 0.090781 Orange IN 6 24813...

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

I need Confidence of intervals using this data and how to implement it in excel!!!!

Solutions

Expert Solution

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

orchestra answered 3 years ago
Next > < Previous

Related Solutions

In cats with tortoiseshell coat color, the fur is white with patchy black and orange spots....
In cats with tortoiseshell coat color, the fur is white with patchy black and orange spots. In cats, the tortoiseshell gene is on the X chromosome, and the tortoiseshell phenotype requires the presence of 2 different alleles at this locus: one for orange fur (o) and one for black fur (b). Which phenomenon best explains why female cats can inherit tortoiseshell coat color? (A. In females, the alleles for coat color are pleiotropic, resulting in patches of orange and black...
Lake McMurtry Monsters (LMM) have three different coat color phenotypes (black, orange, and white). Their coat...
Lake McMurtry Monsters (LMM) have three different coat color phenotypes (black, orange, and white). Their coat color is an example of epistasis. The B gene codes for color type while the W gene codes for the presence or absence of color. ‘B’ is completely dominant to ‘b’ and ‘W’ is completely dominant to ‘w’. For a LMM to be black or orange, they must have the ‘W’ allele. Black is dominant to orange. What are the possible genotypes for the...
A researcher conducts a study of white and black attitudes toward the police in his state....
A researcher conducts a study of white and black attitudes toward the police in his state. The percentage of a random sample of white respondents (N = 300) who say they have a favorable attitude toward the police is 61%. The percentage of a random sample of black respondents (N = 250) who say they have a favorable attitude toward the police is 47%. Is there a real (statistically significant) difference between the percentage of Whites and African Americans who...
An urn contains 6 white and 10 black balls. The figure gives by the roll of...
An urn contains 6 white and 10 black balls. The figure gives by the roll of a dice balance indicates the number of balls that will be drawn without delivery of the ballot box. Let A be the event defined by: A: all the balls drawn from the urn are white. What is the probability that the dice has delivered a 3 knowing that A has realized (Use Bayes' Law)?
1). Given a container with 6 white balls and 9 black balls, if 4 balls are...
1). Given a container with 6 white balls and 9 black balls, if 4 balls are chosen randomly, what is the probability that exactly two are white? 2). Given a container with 6 white balls and 9 black balls, if 4 balls are chosen randomly, and one of the chosen balls is black, what is the probability that exactly two are white?
Topic: Comparing support for including ethnic consideration in college admissions between White and Black Populations. Data:...
Topic: Comparing support for including ethnic consideration in college admissions between White and Black Populations. Data: Whites (659 of 2,997 say Yes, race should be a factor) Blacks (577 of 1,518 say Yes, race should be a factor) Provide the following: 1. Summary Statistics 2. T-Test (or Confidence Interval) 3. Hypothesis Test 4. Regression
Suppose 2 boxes: - Box #1 contains: + 5 Black balls. + 6 White balls. -...
Suppose 2 boxes: - Box #1 contains: + 5 Black balls. + 6 White balls. - Box #2 contains: + 8 Black balls. + 4 White balls. - Two balls are drawn from Box #2 and placed into Box #1. - A ball is drawn from Box #1. 1- What is the probability that the ball drawn from Box #1 is White? 2- Suppose that the ball drawn from Box #1 is White, then what is the probability that at...
Suppose 2 boxes: - Box #1 contains: + 5 Black balls. + 6 White balls. -...
Suppose 2 boxes: - Box #1 contains: + 5 Black balls. + 6 White balls. - Box #2 contains: + 8 Black balls. + 4 White balls. - Two balls are drawn from Box #2 and placed into Box #1. - A ball is drawn from Box #1. 1- What is the probability that the ball drawn from Box #1 is White? 2- Suppose that the ball drawn from Box #1 is White, then what is the probability that at...
Black Hispanic White Pass 9 6 41 Fail 18 17 27 Use this data and a...
Black Hispanic White Pass 9 6 41 Fail 18 17 27 Use this data and a 0.05 significance level to test the claim that less than 58% of the minority candidates (Black and Hispanic candidates grouped together) pass the lieutenants exam. Sample proportion, p-hat = A. 0.26 B. 0.17 C. 0.31 D. 0.62 Test Statistic, z = A. -3.27 B. -2.71 C. 1.12 D. 0.82 Critical z = A. -1.645 B. 1.645 C. -1.645, 1.645 D. -1.96, 1.96 P-Value =...
Two boxes are labelled I and II. Box I contains 4 black balls and 6 white...
Two boxes are labelled I and II. Box I contains 4 black balls and 6 white balls. Box II contains 2 black balls and 8 white balls. A player randomly selects one box and then randomly draws 2 balls without replacement from the selected box. 1) What is the probability of obtaining 2 black balls? 2) Given that 2 black balls are obtained, what is the probability that Box I is selected? 3) Suppose that 20 players conduct the game...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT