Fall 2015 PSYB07 Assignment

data.xlsx

Sheet1

Morning		Evening
Midterm_Morning	Final_Morning	Midterm_Evening	Final_Evening
80	59	62	40	t-Test: Paired Two Sample for Means
80	64	70	45
75	65	80	55		Midterm_Morning	Final_Morning
92	70	78	55	Mean	79	66
78	67	84	60	Variance	48	50.6667
79	58	64	70	Observations	7	7
69	79	84	60	Pearson Correlation	-0.2839
		70	63	Hypothesized Mean Difference	0
				df	6
				t Stat	3.0561
				P(T<=t) one-tail	0.0112
				t Critical one-tail	1.9432
				P(T<=t) two-tail	0.0223
				t Critical two-tail	2.4469
		Midterm_Evening	Final_Evening
	Midterm_Evening	1
	Final_Evening	0.2345	1	SUMMARY OUTPUT
				Regression Statistics
				Multiple R	0.2345
				R Square	0.0550
				Adjusted R Square	-0.1025
				Standard Error	10.1647
				Observations	8
				ANOVA
					df	SS	MS	F	Significance F
				Regression	1	36.0682	36.0682	0.3491	0.5762
				Residual	6	619.9318	103.3220
				Total	7	656
					Coefficients	Standard Error	t Stat	P-value	Lower 95%	Upper 95%	Lower 95.0%	Upper 95.0%
				Intercept	36.6591	32.9316	1.1132	0.3082	-43.9216	117.2398	-43.9215954515	117.2397772696
				Midterm_Evening	0.2614	0.4424	0.5908	0.5762	-0.8211	1.3438	-0.8210610826	1.3437883553