Sales of new houses and three-month lagged unemployement data are shown in the following table. Regression analysis is to be performed to determine if lagged unemployment levels can be used to predict new house sales. Enter the data into an Excel spreadsheet and create a scatterplot of the data. How would you interpret the scatterplot? Which variable is the independent {explanatory} variable? Which is the dependent (response) variable? Run a regression analysis using Excel's Data Analysis/Regression What is the Value of the correlation coefficient? How would you interpret it? What is the value of the coefficient of determination? How would you interpret it? What are the hypotheses for the test of the slope? What is the p-value for the test of the slope? How would you interpret it? How would you interpret the residual plot? What is the regression formula that expresses the relationship between Houses Sold and Unemployment rate Use your regression formula to forecast