Question

Open SAT data.

Test if there is a significant difference in College and High school GPAs. Answer the questions for Assessment. (Pick the closest answer)

4. What is the P-value?

• a. 0.51364714
• b. 0.256823064
• c. 6.18089E-06
• d. None of these

5. What is the Statistical interpretation?

• a. The P-value is too small to have a conclusive answer.
• b. The P-value is too large to have a conclusive answer.
• c. The P-value is much smaller then 5%, thus we are very certain that students with higher SAT have higher GPA.
• d. None of these.

6. What is the conclusion?

• a. The Statistical interpretation agrees with intuition: the higher SAT the higher GPA.
• b. The Statistical interpretation confirms the intuition that High School and College GPA are similar.
• c. Since the test is inconclusive, we cannot say anything regarding the High School and College GPA comparison.
• d. None of these.

DATA: https://www.limes.one/Content/DataFiles/SAT.txt

Answer 1

Excel output

	t-Test: Two-Sample Assuming Unequal Variances
		Variable 1	Variable 2
	Mean	1.9805	2.0486
	Variance	0.56134	0.521776
	Observations	100	100
	Hypothesized Mean Difference	0
	df	198
	t Stat	-0.65435
	P(T<=t) one-tail	0.256823
	t Critical one-tail	1.652586
	P(T<=t) two-tail	0.513646
	t Critical two-tail	1.972017

==================================================================

4. a  0.51364714

5. b. The P-value is too large to have a conclusive answer.

6 b. The Statistical interpretation confirms the intuition that High School and College GPA are similar.