Excel Questions

Using the data below and chart above, please answer the following questions directly in Excel: 

 a) Run the regression in Excel, and be sure to include the regression results in your worksheet and write the equation of the regression line.  

b) What is the meaning of the intercept? Does it make sense in this context? 

 c) In a year in which the United States grows at 0%, what do you predict for European growth? 

 e) What is the R-squared for this regression, and what does it mean in the context of the problem? 

 f) How would you describe the above scatterplot’s direction, form, and shape?