### Create an Account

Home / Questions / The file P10 10 xlsx contains data on 150 homes that were sold recently in a particular co...

# The file P10 10 xlsx contains data on 150 homes that were sold recently in a particular community a Find the table of correlations between all of the variables Do the correlations between price and

The file P10_10.xlsx contains data on 150 homes that were sold recently in a particular community.

a. Find the table of correlations between all of the variables. Do the correlations between price and each of the other variables have the sign (Positive or negative) you would expect? Explain briefly.b.Run a regression of price versus Rooms. What does the confidence interval for the coefficient of Rooms tell you about the effect of Rooms on Price for the entire population of such homes? c. Run a multiple regression of Price versus Home Size. Lot Size. Rooms. and Bathrooms. What is the confidence interval for the coefficient of Rooms now? Why do you think it can be so different from the one in part h? Based on this regression, can you reject the null hypothesis that the population regression coefficient of Rooms is zero versus a two-tailed altemative? What does this mean?

Sep 01 2020 View more View Less