This file contains data on the crime rates (total and violent) and population. Using Excel or other software of your choice, for each of the following pairs make a ScatterPlot then determine the Correlation Coefficient:
(3pts) Crime Rate and Population
(3pts) Violent Crime Rate and Population
(3pts) Crime Rate and Population Density (that’s the Number of people Per square mile – Hint: You need to compute this last one on your own using data in the table.)
Copy and paste each scatter plot into your Word Document. Give each value of r.
(1pt) In a short well-written paragraph, explain what can be concluded from these correlations and absences of correlation.
[Source: US Statistical Abstract 2016: Table 332. Rates per 100,000 population] | ||||
State | Population | Violent Crime Rate | Property Crime Rate | Land Area (sq. miles) |
New York, NY | 8,473,938 | 597 | 1,602 | 308.9 |
Los Angeles, CA | 3,906,772 | 491 | 2,128 | 469.3 |
Chicago \2 | 2,724,121 | 884 | 3,126 | 227.2 |
Houston, TX | 2,219,933 | 991 | 4,694 | 539.9 |
Philadelphia, PA | 1,559,062 | 1,021 | 3,388 | 135.1 |
Las Vegas, NV | 1,530,899 | 841 | 2,923 | 135.9 |
Phoenix, AZ | 1,529,852 | 572 | 3,724 | 419.9 |
San Antonio, TX | 1,428,465 | 539 | 5,418 | 333.0 |
San Diego, CA | 1,368,690 | 381 | 1,959 | 324.0 |
Dallas, TX | 1,272,396 | 665 | 3,589 | 342.4 |
San Jose, CA | 1,009,679 | 321 | 2,434 | 171.3 |
Austin, TX | 903,924 | 396 | 4,142 | 217.8 |
Indianapolis, IN | 858,238 | 1,255 | 4,823 | 361.7 |
Charlotte-Mecklenburg, NC | 856,916 | 590 | 3,567 | 397.7 |
Jacksonville, FL | 856,021 | 684 | 3,941 | 758.7 |
San Francisco, CA | 850,294 | 795 | 5,303 | 46.7 |
Columbus, OH | 830,811 | 549 | 4,253 | 223.1 |
Detroit, MI | 684,694 | 1,989 | 4,817 | 138.7 |
El Paso, TX | 680,273 | 393 | 2,142 | 256 |
Louisville Metro, KY | 677,710 | 591 | 4,185 | 399.0 |
Denver, CO | 665,353 | 599 | 3,359 | 153.3 |
Seattle, WA | 663,410 | 603 | 6,127 | 142.5 |
Baltimore, MD | 622,671 | 1,401 | 4,945 | 80.8 |
Memphis, TN | 654,922 | 1,741 | 5,988 | 256.0 |
Boston, MA | 654,413 | 726 | 2,639 | 48.4 |
Nashville, TN | 647,689 | 1,122 | 3,631 | 473.3 |
Milwaukee, WI | 600,374 | 1,476 | 4,580 | 96.1 |
Correlation =
-0.195615544 |
Correlation =
-0.482988583 |
Correlation =
-0.332225048 In all the above three correlations, all are negative. It means if one will increase then other will decrease. Population and Violent Crime Rate has a negative correlation of -0.19 which is very less. It means you can not say anything about the population based on the Violent Crime Rate. The almost same situation is with density and Crime rate While the crime rate and population has a negative correlation of -0.48. i.e. there is a inverse relationship between these two. |
Get Answers For Free
Most questions answered within 1 hours.