# Create a scatterplot of the size of the house (x-axis) and the electrical power usage (y-axis)…

Question 12 Use the Excel data file, Electrical Power Usage to: 1. Create a scatterplot of the size of the house (x-axis) and the electrical power usage (y-axis). Display the least squares regression line and r2 value on the scatterpl ot. Based on the scatterplot, does it appear that the size of the home and the electrical power usage are strongly related? is the relationship a linear one? 2. Conduct a simple I inear regression analysis to determine if there is a significant relationship between the size of the house (predictor variable) and electrical power usage (dependent variable). a. State the null and alternative hypotheses. b. Did you reject the null hypothesis at the alpha =MS level (report the F-value and p-value)? Explain why or why not c. Report and interpret the correlation coefficient (r), r2, and the standard error of the estimate. Also, state the regression model and interpret the regression coefficients. Complete the problem and answer the questions in Excel.
Question 13 Use the Excel data set Stock_Market” to conduct a multiple linear regression ana lysis to determine if there is a significant relationship between the return on the independent variables, average equity (Xi), annual dividend rate (X2), and the dependent variable, stock price (Y). a. State the null and alternative hypotheses. b. Did you reject the null hypothesis at the alpha =MS level? Explain why or why not (report the F-value and p-value). c. Report and interpret the correlation coefficient (R), R2, Adjusted-R2, the standard error of the estimate, and the regression coefficients. d. Check for mu lti col linearity by calculating the correlation coefficient between the predictor variables. Does it appear that Xi and X2 are correlated? Explain why or why not. Complete the problem and answer the questions in Excel.

View less »