TABLE 13-5

The managing partner of an advertising agency believes that his company's sales are related to the industry sales. He uses Microsoft Excels Data Analysis tool to analyze the last 4 years of quarterly data (i.e., n = 16) with the following results:

Regression Statistics Multiple R 0.802 R Square 0.643 Adjusted R Square 0.618 Standard Error SYX 0.9224 Observations 16

ANOVA df SS MS F Sig.F Regression 1 21.497 21.497 25.27 0.000 Error 14 11.912 0.851 Total 15 33.409

Predictor Coef StdError tStat P-value Intercept 3.962 1.440 2.75 0.016 Industry 0.040451 0.008048 5.03 0.000

Durbin-Watson Statistic 1.59

Referring to Table 13-5, the prediction for a quarter in which X = 80 is Y -hat = ________.