Simple Regression

Sheet4

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.7289852478
R Square	0.5314194915
Adjusted R Square	0.5118953037
Standard Error	14.983361666
Observations	26
ANOVA
	df	SS	MS	F	Significance F
Regression	1	6110.5883410552	6110.5883410552	27.2185196918	0.0000240038
Residual	24	5388.0270435601	224.501126815
Total	25	11498.6153846154
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	12.4393780619	3.8939375592	3.1945499569	0.0038916843	4.4026859902	20.4760701337	4.4026859902	20.4760701337
6	0.9193001867	0.1762077872	5.2171371165	0.0000240038	0.5556251907	1.2829751827	0.5556251907	1.2829751827

Sheet5

Bin	Frequency
-18	0
-7	0
-4	0
-3	0
1	4
3	0
3	0
5	0
6	3
6	0
7	0
10	2
10	0
10	0
10	0
14	2
21	4
21	0
21	0
21	0
22	0
27	0
28	3
28	0
31	1
52	4
58	1
More	3

Sheet6

SUMMARY OUTPUT
Regression Statistics
Multiple R	0.7289852478
R Square	0.5314194915
Adjusted R Square	0.5118953037
Standard Error	11.8814830837
Observations	26
ANOVA
	df	SS	MS	F	Significance F
Regression	1	3842.4286335479	3842.4286335479	27.2185196918	0.0000240038
Residual	24	3388.0713664521	141.1696402688
Total	25	7230.5
	Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
Intercept	-0.3964089322	3.6854103086	-0.1075616821	0.9152375392	-8.0027219144	7.20990405	-8.0027219144	7.20990405
0	0.5780696004	0.1108020716	5.2171371165	0.0000240038	0.3493853657	0.806753835	0.3493853657	0.806753835

Sheet1

1st half x2	final
0	6
76	58
8	-3
14	3
28	31
36	28
56	28
28	21
6	10
20	-18
28	-7
0	14
20	5
62	52
6	10
20	10
42	21
42	7
68	27
6	10
18	6
8	-4
0	3
34	21
30	22
14	21
0	1

first half

final 0 76 8 14 28 36 56 28 6 20 28 0 20 62 6 20 42 42 68 6 18 8 0 34 30 14 0 6 58 -3 3 31 28 28 21 10 -18 -7 14 5 52 10 10 21 7 27 10 6 -4 3 21 22 21 1

Sheet2

Sheet3