Fix assignment-Deliverable 6 - Analysis with Correlation and Regression

Sheet1

MAG	DEPTH		SUMMARY OUTPUT				T-Critical
0.70	6.6
0.74	2.0		Regression Statistics				n	50
0.64	15.3		Multiple R	0.0270197286			r	0.0270197286
0.39	17.2		R Square	0.0007300657			T-Critical	0.143027184
0.70	3.2		Adjusted R Square	-0.0200880579
2.20	2.2		Standard Error	5.0634673614					2.0106347576
1.98	14.8		Observations	50
0.64	5.6
1.22	6.1		ANOVA
0.20	9.1			df	SS	MS	F	Significance F
1.64	18.5		Regression	1	0.8991174203	0.8991174203	0.0350687578	0.8522409932
1.32	8.1		Residual	48	1230.6576825797	25.6387017204
2.95	10.0		Total	49	1231.5568
0.90	13.7
1.76	8.0			Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
1.01	7.0		Intercept	9.5348734098	1.6247985738	5.8683418138	0.0000003981	6.2679969231	12.8017498965	6.2679969231	12.8017498965
1.26	18.6		MAG	0.2306422819	1.2316256783	0.1872665421	0.8522409932	-2.2457071152	2.706991679	-2.2457071152	2.706991679
0.00	8.2
0.65	5.7
1.46	18.9
1.62	13.7
1.83	4.5
0.99	8.3
1.56	6.0
0.40	14.2
1.28	5.4
0.83	17.7
1.34	9.9
0.54	17.3
1.25	5.1
0.92	5.3
1.00	15.9
0.79	13.7
0.79	4.2
1.44	5.7
1.00	5.9
2.24	15.1
2.50	8.5
1.79	14.7
1.25	16.4
1.49	4.7
0.84	8.6
1.42	8.2
1.00	15.2
1.25	10.1
1.42	14.5
1.35	5.2
0.93	7.9
0.40	3.3
1.39	6.4

DEPTH

y = 0.2306x + 9.5349 R² = 0.0007

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 6.6 2 15.3 17.2 3.2 2.2000000000000002 14.8 5.6 6.1 9.1 18.5 8.1 10 13.7 8 7 18.600000000000001 8.1999999999999993 5.7 18.899999999999999 13.7 4.5 8.3000000000000007 6 14.2 5.4 17.7 9.9 17.3 5.0999999999999996 5.3 15.9 13.7 4.2 5.7 5.9 15.1 8.5 14.7 16.399999999999999 4.7 8.6 8.1999999999999993 15.2 10.1 14.5 5.2 7.9 3.3 6.4

MAG

DEPTH

Sheet2

Sheet3