Question

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

Answer 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.