Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Use the Crime and Demographics2 data set to create a Correlation Matrix of these

ID: 3237154 • Letter: U

Question

Use the Crime and Demographics2 data set to create a Correlation Matrix of these four variables: crc332 (% of Murders with Firearms); scs131 (% of population graduated from high school; pvs338 (% of pop. without health insurance); dms491 (Divorce rate). Please identify the two variables that have the strongest association and the two variables that have the weakest association. Report the variable names, the value of Pearson's r and the probability of the Null Hypothesis for each pair (the pair of variables with the strongest association and the pair with the weakest association).

Please help! I'm confused in how to determine which 2 are strong and which 2 are weak.

Correlations of of Population Population of Murders Graduated Not Covered Involving from High by Health Divorce Rate Firearms in School as of Insurance Per 1000 Pop 1998 1998 1998 in 1998 of Murders Involving Pearson Correlation Firearms in 1998 Sig. 2-tailed 008 003 627 of Population Pearson Correlation Graduated from High Sig. 2-tailed) .247 008 004 School as of 1998 18 -.392 424 of Population Not Pearson Correlation Covered by Health Sig. 2-tailed 003 004 003 Insurance 1998 Divorce Rate Per 1000 Pearson Correlation 424 Pop in 1998 Sig. 2-tailed) 627 .247 003 N 42 46 46 46 Correlation is significant at the 0.01 level (2-tailed

Explanation / Answer

strong correlation/association (as the p-value is less than level of significance alpha=0.01)

(% of murders involving firearms in 1998 ) and (% of population graduated from high school as of 1998)

:p-value=0.008

(% of murders involving firearms in 1998 ) and (% of population not coverd by health insurance 1988)

p-value=0.003

(% of population graduated from high school as of 1998) and (% of population not coverd by health insurance 1988)

p-value=0.004

weakest correlation (as the p-value is more than level of significance alpha=0.01)

(% of murders involving firearms in 1998 ) and (Divorce Rate Per 1000 Pop in 1998)

p-value= 0.627

(% of population graduated from high school as of 1998) and  (Divorce Rate Per 1000 Pop in 1998)

p-value=0.247