Consider the following data of 20 students on their high-school GPA and undergra
ID: 3435750 • Letter: C
Question
Consider the following data of 20 students on their high-school GPA and undergraduate GPA when they graduated.
Student number
High-school GPA
Undergraduate GPA
1
2.83
3.59
2
3.31
3.11
3
3.50
2.75
4
3.29
3.33
5
3.13
2.84
6
2.81
3.30
7
3.19
3.05
8
3.49
3.28
9
2.93
2.87
10
3.14
3.50
11
3.00
2.72
12
2.95
2.73
13
2.93
3.08
14
2.89
2.81
15
2.76
2.89
16
2.82
3.02
17
3.00
3.27
18
3.13
3.10
19
3.37
2.93
20
3.30
3.07
CAN YOU PLEASE LIST THE STEPS IN EXCEL YOU TOOK TO SOLVE THIS PROBLEM
Use Excel to calculate the correlation between high-school GPA and undergraduate GPA.
Conduct a hypothesis test with the following hypothesis (use alpha value of 0.05):
Null hypothesis: The correlation between high-school GPA and undergraduate GPA is zero.
Alternate hypothesis: The correlation between high-school GPA and undergraduate GPA is not zero.
Answer the following questions:
What is the p-value and how do you interpret it?
What does the alpha value signify?
What is a type-1 error in this case?
What do you conclude as a result of the test?
CAN YOU PLEASE LIST THE STEPS IN EXCEL YOU TOOK TO SOLVE THIS PROBLEM
Student number
High-school GPA
Undergraduate GPA
1
2.83
3.59
2
3.31
3.11
3
3.50
2.75
4
3.29
3.33
5
3.13
2.84
6
2.81
3.30
7
3.19
3.05
8
3.49
3.28
9
2.93
2.87
10
3.14
3.50
11
3.00
2.72
12
2.95
2.73
13
2.93
3.08
14
2.89
2.81
15
2.76
2.89
16
2.82
3.02
17
3.00
3.27
18
3.13
3.10
19
3.37
2.93
20
3.30
3.07
Explanation / Answer
H0: r=0
Ha: r not equals 0
t = r/sr
sr = rtof 1-r^2/(n-2) = rt of0.9999/18 =0.236
t = 0.0022/0.236 = 0.0093
The P-Value is 0.992682. The result is not significant at p < 0.05.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.