Please specify which excel formulas to use for each step

Ohio Education Performance Results Year 2000
School District	Writing	Reading	Math	Citizenship	Science	All		#18 The State of Ohio Department ojf Education has a mandated nineth grade proficiency test that covers writing,, reading, mathematics, citizenship (social studies)and science. The Excel file Ohio Education Performance provides data on success rates districts in the greater Cincinnati Metropolitan area along with state averages. Test null hypothesis that the average scores in the Cincinnati area for each test and also for the composite scores are equal to the state averages.
Indian Hill	95	98	89	95	91	83
Wyoming	98	96	86	93	87	81
Mason City	96	92	85	94	86	72
Madiera	94	95	88	82	88	69
Mariemont	99	92	74	89	88	68
Sycamore	85	88	80	87	84	68
Forest Hills	93	91	73	85	88	67
Kings Local	92	86	78	82	78	64
Lakota	90	88	73	85	81	64
Loveland	85	93	72	86	86	61
Southwest	92	82	73	78	73	58
Fairf ield	90	86	71	83	77	57
Oak Hills	88	86	75	77	79	57
Three Rivers	87	85	66	84	77	56
Milford	82	86	72	82	76	53
Ross	84	85	66	75	78	52
West Clermont	88	83	63	73	70	48
Reading	88	80	58	76	75	46
Princeton	83	75	59	76	63	46
Finneytown	79	71	61	67	62	45
Norwood	86	77	64	75	67	44
Lockland	88	79	52	82	64	41
Franklin City	85	79	49	70	67	40
Winton Woods	82	77	55	65	59	40
Northwest	75	74	51	62	61	38
North College Hill	77	76	50	66	57	35
Mount Healthy	87	72	40	62	53	32
Felicity Franklin	52	64	52	81	64	28		t-Test: Paired Two Sample for Means	Reading/Writing		t-Test: Paired Two Sample for Means	Math/Science
St. Bernard	81	59	40	41	48	26
Deer Park	69	66	40	43	52	25			Variable 1	Variable 2		Variable 1	Variable 2
Cincinnati Public	63	59	35	50	44	23		Mean	84.935484	81.290323	Mean	64.193548	71.709677
								Variance	99.729032	108.07957	Variance	227.49462	172.14624
State Averages	79	79	60	72	68	46		Observations	31	31	Observations	31	31
								Pearson Correlation	0.8009284		Pearson Correlation	0.9353021
								Hypothesized Mean Difference	0		Hypothesized Mean Difference	0
								df	30		df	30
								t Stat	3.1503345		t Stat	-7.7103301
								P(T<=t) one-tail	0.0018398		P(T<=t) one-tail	6.668E-09
								t Critical one-tail	1.6972609		t Critical one-tail	1.6972609
								P(T<=t) two-tail	0.0036795		P(T<=t) two-tail	1.334E-08
								t Critical two-tail	2.0422725		t Critical two-tail	2.0422725