Question

A college professor is interested in finding the strength of a relationship between the final

exam grades of students enrolled in MMW and Calculus.

MMW, x 83 97 80 95 73 78 91 86

Calculus, y 78 95 83 97 78 72 90 80

a. Make a scatter plot

b. Compute the correlation coefficient

c. Find the equation of the regression line

Answer 1

a.

b.

=CORREL(B1:I1,B2:I2)

r = 0.881075

c.

y=ax+b

a:

=SLOPE(B2:I2,B1:I1)

a=0.9297

b:

=INTERCEPT(B2:I2,B1:I1)

b=4.7464

y=0.9297x + 4.7464