I have attached screen shot of the excel sheet HomePrice3.xlsx. Using this data file, help me answer the following questions (use Excel as needed):

a)

Make a scatter plot of Y against X. Discuss what it tells you.

b) Use Excel's Add Trendline feature to fit a linear regression to the scatter plot. Is a linear model credible?

c) Interpret the slope. Does the intercept have meaning, given the range of the data?

d) Use Excel, MegaStat, or Minitab to fit the regression model, including residuals and standardized residuals.

e)

(1) Based on the R2 and ANOVA table for your model, how would you assess the fit? (2) Interpret the p-value for the F statistic. (3) Would you say that your model's fit is good enough to be of practical value?