Deliverable 6 - Analysis with Correlation and Regression/ Power Point & Excel Sheet
ACL267
ALopez_CorrelationAnalysis_November192020.pptx
Correlation Analysis
Alexis Lopez
November 19,2020
STA3215
Introduction
Correlation is the measure of the extent to which a change in one variable affects a change in another variable. This exercise investigates whether there exists a linear relationship between magnitude and the depth of an earthquake.
This inquiry is based on a dataset containing magnitude and depth of the earthquake for 50 cases. Therefore, the are two attributes and two rows.
Scatterplot
This figure indicates that there exists a weak positive correlation between magnitude and depth.
Relationship between magnitude and Depth
DEPTH
0.7 0.74 0.64 0.39 0.7 2.2000000000000002 1.98 0.64 1.22 0.2 1.64 1.32 2.95 0.9 1.76 1.01 1.26 0 0.65 1.46 1.62 1.83 0.99 1.56 0.4 1.28 0.83 1.34 0.54 1.25 0.92 1 0.79 0.79 1.44 1 2.2400000000000002 2.5 1.79 1.25 1.49 0.84 1.42 1 1.25 1.42 1.35 0.93 0.4 1.39 7.194 2.16 13.923000000000002 15.48 3.04 2.3540000000000005 14.356 5.7119999999999997 6.1 9.1 17.204999999999998 8.7479999999999993 9.2999999999999989 12.33 7.36 7 17.112000000000002 8.7739999999999991 5.9850000000000003 19.088999999999999 12.740999999999998 4.7250000000000005 8.6320000000000014 6 14.625999999999999 4.8600000000000003 19.116 9.9 16.088999999999999 4.59 4.8760000000000003 16.059000000000001 13.974 4.242 5.9280000000000008 5.4280000000000008 15.553000000000001 7.65 15.435 16.399999999999999 4.9350000000000005 8.0839999999999996 7.4619999999999997 14.135999999999999 11.110000000000001 15.950000000000001 5.4600000000000009 7.2680000000000007 3.0689999999999995 5.952
Magnitude
Depth
Value of r
Value of correlation r = .0231
Critical value at alpha = .05 ( two tailed) = 2.57
Significance
There is no significant correlation between magnitude and depth (p> .05)
r =0.023100158
n =50
T Statistic 0.160085307
df 48
P value 0.873485665
Regression equation
Regression equation: depth = .1933Magnitude + 9.4225
Slope : .1933
Y intercept : 9.4225
Good Fit or Not
The equation is not a good fit for the model. This is because the points do not appear to be closer to the line of fit. Again, the value of R square is closer to 0.
Summary
This study investigated the correlation between magnitude and the depth of an earthquake.
The correlation coefficient was found to be .0231, which is weak and positive.
This correlation is insignificant since p > .05, thus no significant association.
