Question #3: (23 marks) Week 9 Lecture 2 So what is important in this class? Is
ID: 3151570 • Letter: Q
Question
Question #3: (23 marks) Week 9 Lecture 2
So what is important in this class? Is it attending class? Is it doing well on the midterms? Or is it doing all the quizzes? I randomly selected 10 students from last semester and found out or determined the following from them…
Student
Final Grade
Average of the Mid-Terms
Classes Missed
Quizzes Missed
A
81
77
3
1
B
90
83
1
0
C
51
60
4
5
D
75
70
0
3
E
63
45
5
3
F
85
78
2
0
G
45
35
6
6
H
78
82
3
3
I
35
26
7
5
J
82
77
0
1
Mean
68.5
63.3
3.1
2.7
If one can assume that the distribution of marks and the number of classes and quizzes missed follow normal distributions, then one can run a multiple regression on these data to determine what would be the largest influence on the final grade. I did just this and came up with the following:
SUMMARY OUTPUT
Regression Statistics
R Square
Adjusted R Square
0.942
Standard Error
Observations
10
ANOVA
df
SS
MS
F
Significance F
Regression
3
3093
1031
49.50
0.0001
Residual
6
20.83
Total
9
3218
Coefficients
Standard Error
t Stat
P-value
Intercept
56.39
Average MT
0.41
0.162
2.54
0.04
C missed
-1.00
1.22
-0.82
0.44
Q missed
-4.05
1.18
-3.43
0.01
Correlation Matrix
Final Grade
Average of the Mid-Terms
Classes Missed
Quizzes Missed
Final Grade
1
Average of the Mid-Terms
0.935
1
Classes Missed
-0.855
-0.856
1
Quizzes Missed
-0.920
-0.799
0.727
1
Based on this information:
Conduct the “Individual” test of the coefficients.
State the Null and Alternative hypotheses (1)
Construct the probability density function and state the rejection rule (1,1)
Perform the test (2)
State your decision. (1)
Student
Final Grade
Average of the Mid-Terms
Classes Missed
Quizzes Missed
A
81
77
3
1
B
90
83
1
0
C
51
60
4
5
D
75
70
0
3
E
63
45
5
3
F
85
78
2
0
G
45
35
6
6
H
78
82
3
3
I
35
26
7
5
J
82
77
0
1
Mean
68.5
63.3
3.1
2.7
Explanation / Answer
using the values that of t stats and p value
F stats and p value to see the critical value and conclude about infereces