The data I calculated for contains advertising budgets and sales figures (both in $1000 units) for 24 months.

1. How do I write the equation of the line for predicting Sales (Y) using the amount of Advertising (X) as the predictor?
2. How Do I find the correlation and use it to make a statement about the quality of the prediction line?

Advertising dollars Sales a in AWN - 6.5 6.6 120 6.4 SUMMARY OUTPUT 6.5 120 6.7 117 6.8 123 Regression Statistics Multiple R 0.8132587 R Square .6613897 Adjusted R Square 0.6459983 6.2 110 Standard Error 3.6914091 5.8 115 6 .2 Observations 24 117 ANOVA 119 SS MS F Significance F Font 122 Regression 585.5503109 585.5503109 42.971436 1.35962E-06 Residual 119 299.7830225 13.62650102 119 Total 885.3333333 122 Coefficients Standard Error t Stat P-value 42.328321 Lower 95% Upper 95% Lower 95.0% Upper 95.0% Intercept 11.21305542 3.774914123 0.0010426 19.07386763 65.582775 19.07386763 65.58277493 Advertising dollars 1.564522 .764159165 6.555260146 1.36E-06 7.905880088 15.223164 7.905880088 15.22316445 RESIDUAL OUTPUT Observation redicted Salt Residuals 105.93319 -5.933193757 109.40255 0.597449562 AWN 111.71545 0.284545108 110.559 1.440997335 120 5 114.02836 2.971640655 6 1 0.815188428 7 117.4977 100 0.502283974 118.65417 1.345831747 9 1 4.658736201 10 1 2.502283974 11 119.81062 -2.81062048 . Sales 12 1 120.96707 2.032927293 Predicted Sales 13 104.77674 -4.77674153 - Linear (Sales 14 115.18481 -7.184811572 - Linear (Predicted Sales) 15 114.02836 4.028359345 16 109.40255 5.59744956 17 114.02836 2.971640655 18 118.65417 -1.654168253 19 120.96707 1.967072707 20 116.34126 2.658736201 122.12352 22 122. 12352 0.123524933 3.123524933 23 123.27998 -4.27997716 Advertising dollars 24 117.49772 4.502283974