Question

In: Economics

House price and number of bedrooms Suppose that you are provided the following data on house...

House price and number of bedrooms Suppose that you are provided the following data on house prices and the number of bedrooms

selling Price number of bedrooms

400 2

700 4

400 3

Calculate the sample mean for both selling price and mean number of bedrooms.

Calculate the sample standard deviations for both selling price and number of bedrooms.

Calculate the sample covariance between the selling price and the number of bedrooms.

Calculate the sample correlation between the selling price and the number of bedrooms.

Calculate the fraction of the variation in selling price that is explained (or attributed) to the number of bedrooms.

Solutions

Expert Solution

House price no. of bedrooms
400 2
400 3
700 4

(a) Sample mean for house price

Sample mean for number of bedrooms

(b) Sample standard deviation of house prices

Sample standard deviation of number of bedrooms

(c) Sample covariance between the house price and number of bedrooms

House price no. of bedrooms
400 2 100 1 100
400 3 100 0 0
700 4 -200 -1 200
total 0 0 100

(d) Sample correlation between the house price and number of bedrooms

(e) To calculate the fraction of the variation in selling price that is explained (or attributed) to the number of bedrooms, we have to find the r-squared value which measures the variation of one variable, say x which explains the variation of the other say y.


Related Solutions

The following data gives the selling price, square footage, number of bedrooms, and the age of...
The following data gives the selling price, square footage, number of bedrooms, and the age of a house in years. These houses have been sold in a specific neighborhood over the last six months. Selling Price ($) Square Footage Bedrooms Age (years) 84,000 1,670 2 30 79,000 1,339 2 25 91,500 1,712 3 30 120,000 1,840 3 40 127,500 2,300 3 18 132,500 2,234 3 30 145,000 2,311 3 19 164,000 2,377 3 7 155,000 2,736 4 10 168,000 2,500...
2) The following data gives the selling price, square footage, number of bedrooms, and the age...
2) The following data gives the selling price, square footage, number of bedrooms, and the age of a house in years. These houses have been sold in a specific neighborhood over the last six months. Selling Price ($) Square Footage Bedrooms Age (years) 84,000 1,670 2 30 79,000 1,339 2 25 91,500 1,712 3 30 120,000 1,840 3 40 127,500 2,300 3 18 132,500 2,234 3 30 145,000 2,311 3 19 164,000 2,377 3 7 155,000 2,736 4 10 168,000...
The following data give the selling price, square footage, number of bedrooms, and age of houses...
The following data give the selling price, square footage, number of bedrooms, and age of houses that have sold in a neighborhood in the past 6 months. Develop three regression models to predict the selling price based upon each of the other factors individually. Which of these is best? use 1 for yes and 0 for no develop a regression model to predict selling price based on the square footage and number of bedrooms. Use this to predict the selling...
2) The following data gives the selling price, square footage, number of bedrooms, and the age...
2) The following data gives the selling price, square footage, number of bedrooms, and the age of a house in years. These houses have been sold in a specific neighborhood over the last six months. Selling Price ($) Square Footage Bedrooms Age (years) 84,000 1,670 2 30 79,000 1,339 2 25 91,500 1,712 3 30 120,000 1,840 3 40 127,500 2,300 3 18 132,500 2,234 3 30 145,000 2,311 3 19 164,000 2,377 3 7 155,000 2,736 4 10 168,000...
The following data gives the selling price, square footage, number of bedrooms, and age (in years)...
The following data gives the selling price, square footage, number of bedrooms, and age (in years) of condominiums that were sold in a neighborhood in the Bronx in the past six months             Selling Price Square Footage No. of Bedrooms Age of Condo 64000 1670 2 30 59000 1339 2 25 61500 1712 3 30 79000 1840 3 40 87500 2300 3 18 92500 2234 3 30 95000 2311 3 19 113000 2377 3 7 115000 2736 4 10 138000...
The following data give the selling price, square footage, number of bedrooms, and age of houses...
The following data give the selling price, square footage, number of bedrooms, and age of houses that have sold in a neighborhood in the past 6 months. Develop three regression models to predict the selling price based upon each of the other factors individually. Which of these is best? Selling Price Square Footage Bedrooms Age (Years) 84000 1670 2 30 79000 1339 2 25 91500 1712 3 30 120000 1840 3 40 127500 2300 3 18 132500 2234 3 30...
(House Selling Price) The data below show the selling price, square footage, bedrooms, and age of...
(House Selling Price) The data below show the selling price, square footage, bedrooms, and age of houses that have sold in a neighborhood in the last six months. Selling price Square footage Bedrooms Age 64,000 1,670 2 30 59,000 1,339 2 25 61,500 1,712 3 30 79,000 1,840 3 40 87,500 2,300 3 18 92,500 2,234 3 30 95,000 2,311 3 19 113,000 2,377 3 7 115,000 2,736 4 10 138,000 2,500 3 1 142,500 2,500 4 3 144,000 2,479...
A real estate agent would like to know if the number of bedrooms in a house...
A real estate agent would like to know if the number of bedrooms in a house can be used to predict the selling price of the house. More specifically, she wants to know whether a larger number of bedrooms leads to a higher selling price. Records for 25 houses that recently sold in the area were selected at random, and data on the number of bedrooms (x) and the selling price (y) (in $000s) for each house were used to...
Suppose the following data were collected relating the selling price of a house to square footage...
Suppose the following data were collected relating the selling price of a house to square footage and whether or not the house is made out of brick. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average brick houses are more expensive than other types of houses at the 0.050.05 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else,...
Suppose the following data were collected relating the selling price of a house to square footage...
Suppose the following data were collected relating the selling price of a house to square footage and whether or not the house is made out of wood. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average wood houses are more expensive than other types of houses at the 0.05 level of significance? If yes, type the regression equation in the spaces provided with answers rounded to two decimal places. Else,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT