The managing partner of an advertising agency

Question 1: The managing partner of an advertising agency believes that his company's sales are related to the industry sales. He uses Microsoft Excel's Data Analysis tool to analyze the last 4 years of quarterly data (i.e., n 60) with the following results: Regression Statistics Multiple R R Square Adjusted R Square Standard Error SYX Observations 60 ANOVA df SS MS F Sig.F Regression 1
Error 58
Total 59 PredictorCoefStdErrort StatP-value Intercept
Industry 22.2 a) What is the value of the quantity that the least squares regression line minimizes? Explain your answer. b) What is the prediction of Y for a...