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.

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote