Deliverable 6 - Analysis with Correlation and Regression/ Power Point & Excel Sheet
ACL267
Deliverable_06_Data_ALopez_November192020.xlsxSheet1
| MAG | DEPTH | |||||||||
| 0.70 | 7.2 | 3 | ||||||||
| 0.74 | 2.2 | |||||||||
| 0.64 | 13.9 | |||||||||
| 0.39 | 15.5 | |||||||||
| 0.70 | 3.0 | |||||||||
| 2.20 | 2.4 | |||||||||
| 1.98 | 14.4 | |||||||||
| 0.64 | 5.7 | |||||||||
| 1.22 | 6.1 | |||||||||
| 0.20 | 9.1 | |||||||||
| 1.64 | 17.2 | |||||||||
| 1.32 | 8.7 | |||||||||
| 2.95 | 9.3 | |||||||||
| 0.90 | 12.3 | |||||||||
| 1.76 | 7.4 | |||||||||
| 1.01 | 7.0 | |||||||||
| 1.26 | 17.1 | |||||||||
| 0.00 | 8.8 | |||||||||
| 0.65 | 6.0 | 4 | Critical value | 2.57 | ||||||
| 1.46 | 19.1 | |||||||||
| 1.62 | 12.7 | 5 | r | 0.023100158 | ||||||
| 1.83 | 4.7 | |||||||||
| 0.99 | 8.6 | n | 50 | |||||||
| 1.56 | 6.0 | |||||||||
| 0.40 | 14.6 | T Statistic | 0.1600853073 | |||||||
| 1.28 | 4.9 | |||||||||
| 0.83 | 19.1 | df | 48 | |||||||
| 1.34 | 9.9 | |||||||||
| 0.54 | 16.1 | P value | 0.8734856645 | |||||||
| 1.25 | 4.6 | |||||||||
| 0.92 | 4.9 | |||||||||
| 1.00 | 16.1 | 6 | depth =.1933magnitude + 9.4225 | |||||||
| 0.79 | 14.0 | |||||||||
| 0.79 | 4.2 | |||||||||
| 1.44 | 5.9 | 7 | depth | Coeff | magnitude | intercept | ||||
| 1.00 | 5.4 | 9.8091 | 0.1933 | 2 | 9.4225 | |||||
| 2.24 | 15.6 | |||||||||
| 2.50 | 7.7 | |||||||||
| 1.79 | 15.4 | |||||||||
| 1.25 | 16.4 | |||||||||
| 1.49 | 4.9 | |||||||||
| 0.84 | 8.1 | |||||||||
| 1.42 | 7.5 | |||||||||
| 1.00 | 14.1 | |||||||||
| 1.25 | 11.1 | |||||||||
| 1.42 | 16.0 | |||||||||
| 1.35 | 5.5 | |||||||||
| 0.93 | 7.3 | |||||||||
| 0.40 | 3.1 | |||||||||
| 1.39 | 6.0 |
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
