The data for this exercise ( Table 2.8) may be loaded from the file ...\CHAP02\TA02_008.XSL.

  See  exercise 2.25.       for instructions. 

After loading the data, read the Exercise 2.46 from the textbook and
answer the questions (a) to (d) as instructed below:  

Question.  Hand in an Excel worksheet (for Ex. 2.46) with a chart like that .

For parts (a), (b) and (c) make a scatterplot with the least-square regression line,

and the equation of the line and the R^2 value displayed on the graph.

Write the answer to part (b) under the graph, starting at the cell D25 .

Write the predicted value for part (c) in cell D29.

Write the answer to part (d) starting at the cell D30.