EXAMPLE 10.11 Prediction Intervals from a Spreadsheet

In Example 10.7 (pages 511–512), we used statistical software to predict the log income of Alexander, who has years of education. Suppose that we have only the Excel spreadsheet. The prediction interval then requires some additional work.

Step 1. From the Excel output in Figure 10.5 (page 492), we know that . Excel can also find the mean and variance of the EDUC for the 100 entrepreneurs. They are and .

Step 2. We need the value of . Recalling the definition of the variance, we see that this is just

Step 3. The standard error for predicting Alexander’s log income from his years of education, , is

Step 4. We predict Alexander’s log income from the least-squares line (Figure 10.5 again):

This agrees with the “Fit” from software in Example 10.8. The 95% prediction interval requires the 95% critical value for . For hand calculation we use from Table D with . The interval is

520

This agrees with the software result in Example 10.8, with a small difference due to roundoff and especially to not having the exact .