Question

In: Statistics and Probability

Use the data below to solve. The data gives the square footage and sales prices for...

Use the data below to solve. The data gives the square footage and sales prices for several houses in Bellevue, Washington. Use this information to solve the following:

PLEASE SHOW YOUR WORK : )

1) You plan to build a 500 square foot addition to your home. How much do you think your home value will increase as a result?

2) What percentage of the variation in home value is explained by the variation in the house size?

3) A 3000 square foot home is listed for $500,000. Is this price out of line with typical sales in Bellevue? What might cause this discrepancy?

Square Footage   Value
2000   238139.3695
2200   259711.9508
2400   300953.668
3000   369965.7313
3200   340091.2955
3600   405425.021
2900   345131.0331

Solutions

Expert Solution

Independent variable (X): Square Footage

Dependent variable (Y): Value

First we need to find the regression equation. Following table shows the calculations:

X Y X^2 Y^2 XY
2000 238139.3695 4000000 56710359306 476278739
2200 259711.9508 4840000 67450297388 571366292
2400 300953.668 5760000 90573110283 722288803
3000 369965.7313 9000000 1.36875E+11 1109897194
3200 340091.2955 10240000 1.15662E+11 1088292146
3600 405425.021 12960000 1.64369E+11 1459530076
2900 345131.0331 8410000 1.19115E+11 1000879996
Total 19300 2259418.069 55210000 7.50755E+11 6428533245

That is for each addition square footage value is increased by $99.6398. So for additional 500 square footage, value is increased by

500 * 99.6398 =  49819.9

Answer: $49819.90

(b)

That is 92.4% of the variation in home value is explained by the variation in the house size.

(c)

According to regression line, the value of house with 3000 square foot is $346972.247. So price $500,000 is out of line with typical sales in Bellevue. It may be due to location of house or amenities of house (like parking space etc).


Related Solutions

This data gives the square footage and sales prices for several houses and sales prices for...
This data gives the square footage and sales prices for several houses and sales prices for several houses in Dallas, Texas. Square Footage Value 2000 238139.4 2200 259712 2400 300953.7 3000 369965.7 3200 340091.3 3600 405425 2900 345131 You plan to build a 500-sqaure-foot addition to your house. How much do you think your home value will increase as a result? What percentage of the variation in home value is explained by the variation in the house size? Please set...
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...
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...
(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...
The following data represents the square footage and rent of apartments in the boroughs of Queens,...
The following data represents the square footage and rent of apartments in the boroughs of Queens, New York. Queens (New York City) Square Footage Rent Per Month 500 650 588 1215 1000 2000 688 1655 825 1250 460 1805 1259 2700 650 1200 560 1250 1073 2350 1452 3300 1305 3100 a. Find the least-squares regression line, treating square footage as the explanatory variable. b. Interpret the slope and y-intercept, if appropriate. c. Is the rent on the 825-square-foot apartment...
The data is the square footage and selling price of single-family homes for the month of...
The data is the square footage and selling price of single-family homes for the month of February and the first week of March. Square Footage Selling Price 1746 129320 1764 97000 676 35000 2788 400000 1944 68000 1960 117000 1056 148400 1564 35000 1100 165000 1120 114480 4080 175000 1442 65000 1937 60000 1900 18000 1150 258000 1650 134800 1953 30000 2424 69100 512 63000 1540 82500 1200 50000 1316 37500 1840 69000 3500 270000 5000 485000 1564 27000 1018...
The city government has collected data on the square footage of houses within the city. They...
The city government has collected data on the square footage of houses within the city. They found that the average square footage of homes within the city limit is 1,240 square feet while the median square footage of homes within the city limits is 1,660 square feet. The city government also found that the standard deviation of home square footage within the city limits is 198 square feet. A statistician hired by a local home-carpeting company is going to randomly...
The city government has collected data on the square footage of houses within the city. They...
The city government has collected data on the square footage of houses within the city. They found that the average square footage of homes within the city limit is 1,240 square feet while the median square footage of homes within the city limits is 1,660 square feet. The city government also found that the standard deviation of home square footage within the city limits is 198 square feet. A statistician hired by a local home-carpeting company is going to randomly...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT