The following data were collected during a study of consumer buying patterns.

a. Plot the data as a scatter plot.

b. Obtain a linear regression line for the data. (You may use Excel’s “=s lope(Range Y, Range X)” and “ =intercept(Range Y, Range X, where Range Y is the range of Excel cells containing they values and Range X is the range of Excel cells containing the x values)” to obtain the regression coefficients b and G, respectively. Alternatively, use Trendline in the Layout menu.) 

c. What percentage of the variation is explained by the regression line? (You may use Excel’s “=RSQ(Range Y, Range X)” to obtain r2).

d. Use the equation determined in part b to predict the value of y for x = 41.

Observation 1 www. 2 NAGAWN 3 4 5. 6 ****** 7. On X 15 25 40 32 51 47 30 Y 74 80 84 81 96 95 83 Observation 8 9 10 11 12 X 18 14 15 22 24 Y 78 70 72 85 88