1. Download the dataset "prisons.xlsx" from canvas.

a. Before running the correlation matrix between , explicitly identify what you think is therelationship between median income and each of the other 3 variables in thespreadsheet. Make sure you provide an explanation as to why you think the relationshipis positive, negative or zero.

b. Use excel to calculate the correlation matrix. Are the correlation coefficients the sameas what you predicted? Identify the variables with correlation coefficients that have adifferent sign from what you predicted.

"prison.xlsx" dataset:

2010 data

united states

Alabama

Alaska

Arizona

Arkansas

California

Colorado

Connecticut

Delaware

Florida

Georgia

Hawaii

Idaho

Illinois

Indiana

Iowa

Kansas

Kentucky

Louisiana

Maine

Maryland

Massachusetts

Michigan

Minnesota

Mississippi

Missouri

Montana

Nebraska

Nevada

New Hampshire

New Jersey

New Mexico

New York

North Carolina

North Dakota

Ohio

Oklahoma

Oregon

Pennsylvania

Rhode Island

South Carolina

South Dakota

Tennessee

Texas

Utah

Vermont

Virginia

Washington

West Virginia

Wisconsin

Wyoming

median income

49276.42843

40933.08954

57847.58172

46895.62495

38586.61852

54282.50562

60232.65404

65998.13361

55214.07629

44066.41515

44117.40159

59539.02758

47050.45199

50727.50187

46139.18339

49016.06828

46053.81564

41104.33301

39300.37724

47930.51901

64200.66887

60933.86257

46276.25041

52321.35083

38159.60534

45816.51771

41279.54596

52503.85353

51199.95444

66632.79438

62968.22926

45134.45588

49781.11015

43830.25507

51005.53481

45885.77527

43103.21144

50601.95286

48314.20885

51623.17132

41698.22222

45352.39787

38591.45448

47265.91472

56700.72461

55927.82173

60367.0204

56162.85451

42777.18205

50351.10337

52200.9245

minimum wage

$7.25

0

7.75

7.25

6.25

8

7.24

8.25

7.25

7.25

5.15

7.25

7.25

8

7.25

7.25

7.25

7.25

0

7.5

7.25

8

7.4

5.25

0

7.25

4

7.25

6.55

7.25

7.25

7.5

7.25

7.25

7.25

7.3

2

8.4

7.25

7.4

0

7.25

0

7.25

7.25

8.06

7.25

8.55

7.25

7.25

5.15

HS Grads/1000

9.760780641

8.490406551

11.70628975

9.450882077

9.758391669

10.27580388

9.457787837

10.55796983

9.046535199

0.159778217

8.790014412

62.61740305

6.810506256

1.340914719

20.60049099

20.47077538

11.72029521

6.914759146

9.015821248

26.04380512

2.414581793

8.870460163

6.444171154

21.22900778

20.10052282

4.331426694

64.30141338

5.431275514

7.421560539

14.07951203

1.645530651

45.8199353

0.934767076

18.54138717

126.7215017

0.587625135

31.9612019

9.928791986

2.741056928

115.8068954

2.044378541

47.25703467

1.359038455

2.303842174

95.7168114

42.1626786

0.881111841

11.63289065

34.78813267

3.078188627

113.4346759

PrisonPop/1000

4.547835789

6.637688252

7.54887656

6.269766003

5.546298794

4.420727535

4.519887505

5.403722782

7.351699059

5.53681951

5.810449728

4.33634868

4.72980112

3.770290874

4.31823021

3.099794702

3.165633898

4.725775512

8.678112961

1.622746781

3.913973135

1.72573544

4.471434705

1.844592516

7.093094039

5.107480926

3.749906656

2.506364264

4.678874215

2.09673855

2.84183598

3.273613168

2.921134223

4.223955188

2.204174443

4.481898372

6.981573242

3.875641815

4.030910567

3.189463843

5.08463684

4.205251544

4.317935721

6.876244235

2.452549632

3.32156911

4.690705442

2.704305979

3.602844743

3.993387517

3.741006175