Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

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 22

Explanation / 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.