1) Calculate r for the correlation between percentage of the adult population th
ID: 3471467 • Letter: 1
Question
1) Calculate r for the correlation between percentage of the adult population that graduated from college (Coll Grad) and Burglary rate (Burglary)?
-.20
-.40
-.30
-.10
2) According to your regression output on the previous question, how much variability in the Burglary rate can we predict by knowing the percentage of the population who graduated college?
a. 1%
16%
9%
d. 4%
3) Was this correlation significant?
a. yes
b. no
4) What is r for the correlation between percentage of the adult population that graduated from college (%Coll Grad) and vehicle theft rate (VehTheft)?
a .36
b .42
c .54
d .13
5) According to your regression output on the previous question, how much variability in the vehicle theft rate can we predict by knowing the percentage of the population who graduated college?
a. 13%
b. 16%
c. 22%
d. 36%
6) Was this correlation significant?
a. yes
b. no
7) Now use your regression analysis to predict the burglary rate based on the percentage of college graduates in the area.
What would our predicted Y value be in an area where 20 percent of the population were college graduates?
a. 23074.37
811
1026
612
state %Coll Grad Burglary VehTheft Alabama 19.8 1081.3 288.7 Alaska 28.6 472.1 238.7 Arizona 28 868.9 572.6 Arkansas 17.5 1180 228 California 30.6 647.1 523.8 Colorado 35.5 572 273.7 Connecticut 36.8 428.7 256 Delaware 25.6 774.3 291 District of Columbia 46.9 640 1092.4 Florida 25.4 1028.3 346.5 Georgia 27.1 1038.9 409.1 Hawaii 30.4 728.1 398.5 Idaho 25.9 439.8 109.5 Illinois 29.6 612.1 252.5 Indiana 22.6 762.8 273.7 Iowa 24.5 547.9 144.3 Kansas 30.4 699.9 263.9 Kentucky 18.9 675.5 179.6 Louisiana 19.6 982.1 311.6 Maine 24.3 495.4 89.3 Maryland 36.3 689.6 449.7 Massachusetts 36.6 555.5 196 Michigan 24.6 741.5 362.3 Minnesota 34.2 505.9 193.1 Mississippi 21.8 885.6 216.2 Missouri 25 774.5 351.3 Montana 25.4 344.4 162.6 Nebraska 25.4 492 234.8 Nevada 23.4 929 611.6 New Hampshire 32.8 325.7 105.4 New Jersey 36.3 465.3 232.4 New Mexico 27.4 1094.2 403.4 New York 30.4 337.3 128.9 North Carolina 25.3 1210.1 290 North Dakota 27.2 328.3 137.5 Ohio 23 892.8 248.4 Oklahoma 24 963.1 298.7 Oregon 29 550.9 299 Pennsylvania 26 470.9 180.5 Rhode Island 29.2 547.2 304.5 South Carolina 24.2 1026.1 394 South Dakota 25 302.2 99.5 Tennessee 21.5 1046 309.3 Texas 25.5 946 350.8 Utah 29.8 536.5 262.9 Vermont 34.4 557.2 94.2 Virginia 30.6 411.8 170.7 Washington 30.9 801.3 432.6 West Virginia 15.1 609.9 176.6 Wisconsin 25 488.3 204.7 Wyoming 23.4 410 133.9
Explanation / Answer
1.
X Values
? = 1396.7
Mean = 27.386
?(X - Mx)2 = SSx = 1652.86
Y Values
? = 34914.3
Mean = 684.594
?(Y - My)2 = SSy = 3123820.468
X and Y Combined
N = 51
?(X - Mx)(Y - My) = -28365.134
R Calculation
r = ?((X - My)(Y - Mx)) / ?((SSx)(SSy))
r = -28365.134 / ?((1652.86)(3123820.468)) = -0.3948
Therefore, the correct answer is Option B, -.40.
Please post the other questions separately as we are supposed to answer just one question or four subparts of a question.
State X (% Coll Grad) Y (Burglary) X - Mx Y - My (X - Mx)2 (Y - My)2 (X - Mx)(Y - My) Alabama 19.8 1081.3 -7.586 396.706 57.552 157375.6 -3009.52 Alaska 28.6 472.1 1.214 -212.494 1.473 45153.75 -257.91 Arizona 28 868.9 0.614 184.306 0.377 33968.66 113.113 Arkansas 17.5 1180 -9.886 495.406 97.738 245427 -4897.72 California 30.6 647.1 3.214 -37.494 10.328 1405.809 -120.496 Colorado 35.5 572 8.114 -112.594 65.833 12677.44 -913.558 Connecticut 36.8 428.7 9.414 -255.894 88.618 65481.8 -2408.92 Delaware 25.6 774.3 -1.786 89.706 3.191 8047.145 -160.239 District of Columbia 46.9 640 19.514 -44.594 380.785 1988.635 -870.197 Florida 25.4 1028.3 -1.986 343.706 3.945 118133.7 -682.694 Georgia 27.1 1038.9 -0.286 354.306 0.082 125532.7 -101.429 Hawaii 30.4 728.1 3.014 43.506 9.083 1892.762 131.115 Idaho 25.9 439.8 -1.486 -244.794 2.209 59924.16 363.831 Illinois 29.6 612.1 2.214 -72.494 4.901 5255.397 -160.482 Indiana 22.6 762.8 -4.786 78.206 22.908 6116.16 -374.315 Iowa 24.5 547.9 -2.886 -136.694 8.331 18685.28 394.537 Kansas 30.4 699.9 3.014 15.306 9.083 234.27 46.128 Kentucky 18.9 675.5 -8.486 -9.094 72.017 82.703 77.175 Louisiana 19.6 982.1 -7.786 297.506 60.626 88509.75 -2316.46 Maine 24.3 495.4 -3.086 -189.194 9.525 35794.41 583.905 Maryland 36.3 689.6 8.914 5.006 79.455 25.059 44.621 Massachusetts 36.6 555.5 9.214 -129.094 84.893 16665.29 -1189.44 Michigan 24.6 741.5 -2.786 56.906 7.763 3238.279 -158.555 Minnesota 34.2 505.9 6.814 -178.694 46.427 31931.59 -1217.57 Mississippi 21.8 885.6 -5.586 201.006 31.206 40403.37 -1122.87 Missouri 25 774.5 -2.386 89.906 5.694 8083.068 -214.54 Montana 25.4 344.4 -1.986 -340.194 3.945 115732 675.719 Nebraska 25.4 492 -1.986 -192.594 3.945 37092.49 382.545 Nevada 23.4 929 -3.986 244.406 15.89 59734.24 -974.269 New Hampshire 32.8 325.7 5.414 -358.894 29.308 128805 -1942.95 New Jersey 36.3 465.3 8.914 -219.294 79.455 48089.91 -1954.73 New Mexico 27.4 1094.2 0.014 409.606 0 167777 5.622 New York 30.4 337.3 3.014 -347.294 9.083 120613.2 -1046.65 North Carolina 25.3 1210.1 -2.086 525.506 4.353 276156.4 -1096.35 North Dakota 27.2 328.3 -0.186 -356.294 0.035 126945.5 66.369 Ohio 23 892.8 -4.386 208.206 19.239 43349.69 -913.248 Oklahoma 24 963.1 -3.386 278.506 11.467 77565.53 -943.097 Oregon 29 550.9 1.614 -133.694 2.604 17874.12 -215.746 Pennsylvania 26 470.9 -1.386 -213.694 1.922 45665.18 296.239 Rhode Island 29.2 547.2 1.814 -137.394 3.29 18877.14 -249.195 South Carolina 24.2 1026.1 -3.186 341.506 10.152 116626.3 -1088.13 South Dakota 25 302.2 -2.386 -382.394 5.694 146225.3 912.497 Tennessee 21.5 1046 -5.886 361.406 34.648 130614.2 -2127.33 Texas 25.5 946 -1.886 261.406 3.558 68333.04 -493.083 Utah 29.8 536.5 2.414 -148.094 5.826 21931.87 -357.459 Vermont 34.4 557.2 7.014 -127.394 49.192 16229.26 -893.507 Virginia 30.6 411.8 3.214 -272.794 10.328 74416.63 -876.685 Washington 30.9 801.3 3.514 116.706 12.346 13620.26 410.072 West Virginia 15.1 609.9 -12.286 -74.694 150.953 5579.211 917.712 Wisconsin 25 488.3 -2.386 -196.294 5.694 38531.38 468.412 Wyoming 23.4 410 -3.986 -274.594 15.89 75401.93 1094.608Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.