The following Excel tables are obtained when \"Score received on an exam (measur
ID: 3217882 • Letter: T
Question
The following Excel tables are obtained when "Score received on an exam (measured in percentage points)" (Y) is regressed on "percentage attendance" (X) for 22 students in a Statistics for Business and Economics course.
Regression Statistics
Q1) Which of the following statements is true?
A) If attendance increases by 0.341%, the estimated mean score received will increase by 1 percentage point
B)If attendance increases by 1%, the estimated mean score received will increase by 39.39 percentage points
C) If the score received increases by 39.39%, the estimated mean attendance will go up by 1%
D) If attendance increases by 1%, the estimated mean score received will increase by 0.341 percentage points
Q2) The least squares method minimizes which of the following?
I. SSR
II. SSE
III. SST
A) I only
B) III only
C) II only
D) All of these
Multiple R 0.142620229 R Square 0.02034053 Standard Error 20.2597994 Observations 22Explanation / Answer
Q1. From the given table we see that the coefficient of the independent variable Attendance is 0.340583573
Therefore,
Mean score = 0.341 * Attendance + constant
Now it is clear from the above regression equation that if we increase the attendance by 1% there will be an increase of 0.341% on the mean score.
Therefore d) is the correct answer here.
Q2: The whole derivation of the ordinary least squares method is to minimize the sum of squares of errors. Therefore c) II only is the correct answer.