Refer to Table 12.1, in which the relationship between x = mathematics achievement test score and y = final calculus grade was studied.

1. Enter the values for x and y into columns A and B of an Excel spreadsheet. 2. Use Data Data Analysis Regression to generate the dialogue box in Figure 12.18(a). Highlight or type in the cell ranges for the x and y values and check "Labels" if necessary. 3. If you click "Confidence Level," Excel will calculate confidence intervals for the regression estimates, a and

b. Enter a cell location for the Output Range and click OK. 4. The output will appear in the selected cell location, and should be adjusted using Format AutoFit Column Width on the Home tab in the Cells group while it is still highlighted. You can decrease the decimal accuracy if you like, using on the Home tab in the Number group (see Figure 12.18(b)). 5. The output in Figure 12.18

(b) can also be found in Figures 12.6

(b) and 12.7(b), with its interpretation found in Sections 12.4 and 12.5 of the text.

Transcribed Image Text:

Student Mathematics Achievement Test Score (x) Final Calculus Grade (y) 1 39 65 10 234567AGO 43 78 21 52 64 82 57 92 47 89 28 73 8 75 98 9 34 56 52 75