Question

93	95
93	81
88	88
84	75
89	81
92	91
83	78
88	77
95	94
90	94
80	84
95	87
92	92
94	84
83	89
84	87
78	99
97	79
93	83
76	92
96	77
52	89
95	76
87	92
80	70
94	90
93	83
88	89
95	87
88	96
92	87
96	93
96	81
93	76
78	96
96	84
89	91
92	87
91	90
86	88
87	82
93	83
96	81
95	92
91	84
87	86
84	93
90	79
85	89
93	83
93	90
96	76
87	65
92	86
91	91
91	92
90	86
92	98
90	95
97	94
91	95
84	80
85	69
90	80
91	91
89	88
99	85
90	87
90	97
84	89

calculate the t stat for this data range for a two tailed test? and find p value? How?

Answer 1

Run t-Test: Two-Sample Assuming Equal Variances in excel followed by below procedures:

1. Go to data tab --> data analysis --> choose t-Test: Two-Sample Assuming Equal Variances

Output:

t stat: 2.66

P-value: 0.009