Question

In: Math

The biggest determining the value of a home square footage accompanying data represent the square footage...

The biggest determining the value of a home square footage accompanying data represent the square footage and selling price for a random sample of homes for sale in a certain region
Sample Footage, x. Selling Price ($000s), y
2292. 393.8
3216 381.5
1074 181.5
1948 333.8
3196 634
2670 354
4126 629.7
2126 363.8
2637 429.4
1707 298.1
1855 281.9
3930 708.6

a.) determine the linear correlation coefficient between square footage and asking price
b.) find the least squares regression line treating square footage as the explanatory variable
c.) interpret the slope
for every additional square foot, the selling price increased by ______ thousand dollars, on average
d.) is it reasonable to interprey the y-intercept? why?
a house of ___ square feet is not possible and outsidw the scope of the model
e.) one home that is 1431 square feet is sold for $210 thousand. is this home’s price above or below average for a homr of this size?
the average price of a home that id 1431 feet id $______ thosand.

Solutions

Expert Solution

X Y XY
2292 393.8 902589.6 5253264 155078.44
3216 381.5 1226904 10342656 145542.25
1074 181.5 194931 1153476 32942.25
1948 333.8 650242.4 3794704 111422.44
3196 634 2026264 10214416 401956
2670 354 945180 7128900 125316
4126 629.7 2598142.2 17023876 396522.09
2126 363.8 773438.8 4519876 132350.44
2637 429.4 1132327.8 6953769 184384.36
1707 298.1 508856.7 2913849 88863.61
1855 281.9 522924.5 3441025 79467.61
3930 708.6 2784798 15444900 502113.96
Ʃx = Ʃy = Ʃxy = Ʃx² = Ʃy² =
30777 4990.1 14266599 88184711 2355959.45
Sample size, n = 12
x̅ = Ʃx/n = 30777/12 = 2564.75
y̅ = Ʃy/n = 4990.1/12 = 415.841667
SSxx = Ʃx² - (Ʃx)²/n = 88184711 - (30777)²/12 = 9249400.25
SSyy = Ʃy² - (Ʃy)²/n = 2355959.45 - (4990.1)²/12 = 280867.949
SSxy = Ʃxy - (Ʃx)(Ʃy)/n = 14266599 - (30777)(4990.1)/12 = 1468240.03

a) Correlation coefficient, r = SSxy/√(SSxx*SSyy)

= 1468240.025/√(9249400.25*280867.94917) = 0.9109

b) Slope, b = SSxy/SSxx = 1468240.025/9249400.25 = 0.158738944

y-intercept, a = y̅ -b* x̅ = 415.84167 - (0.15874)*2564.75 = 8.715960963

Regression equation :   

ŷ = 8.716 + (0.1587) x  

c) For every additional square foot, the selling price increased by 0.1587 thousand dollars, on average

d) No, it is not reasonable to interpret the y-intercept.

A house of 0 square feet is not possible and outside the scope of the model.

e) Predicted value of y at x = 1431

ŷ = 8.716 + (0.1587) * 1431 = $ 235.87

The average price of a home that is 1431 feet is $235.87 thousand.

This home’s price is below average for a home of this size.


Related Solutions

One of the biggest factors in determining the value of a home is the square footage....
One of the biggest factors in determining the value of a home is the square footage. The accompanying data represent the square footage and selling price​ (in thousands of​ dollars) for a random sample of homes for sale in a certain region. Complete parts​ (a) through​ (h) below. Square Footage, x   Selling Price ($000s), y 2247 386.5 3291 391.6 1163 195.4 2015 344.3 3053 611.7 2857 384.5 4001 610.3 2175 371.5 2497 407.5 1707 297.9 1846 280.2 3910    705.5...
One of the biggest factors in determining the value of a home is the square footage....
One of the biggest factors in determining the value of a home is the square footage. The accompanying data represent the square footage and selling price​ (in thousands of​ dollars) for a random sample of homes for sale in a certain region. Complete parts​ (a) through​ (h) below. Square​ Footage, x Selling Price​ ($000s), y 21162116 366.2366.2 31243124 365.1365.1 11251125 189.4189.4 18771877 322.7322.7 31363136 624.2624.2 27382738 364.4364.4 42614261 650.7650.7 23062306 392392 27052705 440440 17801780 309.4309.4 18181818 275.8275.8 39463946 710.3 ​(c)...
The accompanying data file shows the square footage and associated property taxes for 20 homes in...
The accompanying data file shows the square footage and associated property taxes for 20 homes in an affluent suburb 30 miles outside of New York City. Estimate a home’s property taxes as a linear function of its square footage. At the 5% significance level, is square footage significant in explaining property taxes? Show the relevant steps of the test. Please use Minitab and explain the various steps involved. Property Taxes Square Footage 21928 2449 17339 2479 18229 1890 15693 1000...
The data in the accompanying table represent the compressive​ strength, in thousands of pounds per square...
The data in the accompanying table represent the compressive​ strength, in thousands of pounds per square inch​ (psi), of 20 samples of concrete taken two and seven days after pouring. Sample Two days Seven days 1 3.205 3.54 2 2.855 3.355 3 3.135 3.605 4 3.425 4.03 5 3.16 3.43 6 3.765 4.57 7 2.68 3.805 8 3.315 3.685 9 3.205 3.59 10 3.605 3.72 11 2.895 3.25 12 3.08 3.14 13 3 4.005 14 3.035 3.595 15 2.27 3.91...
The accompanying frequency distribution represents the square footage of a random sample of 500 houses that...
The accompanying frequency distribution represents the square footage of a random sample of 500 houses that are owner occupied year round. Approximate the mean and standard deviation square footage. The mean square footage is x bar = ? Table Square footage Frequency 0 ? 499?1 9 500 ? 999?1 13 ?1,000 - ?1,499 33 ?1,500 - 1,999 115 ?2,000 - 2,499 125 ?2,500 - 2,999 83 ?3,000 - 3,499 45 ?3,500 - ?3,999 41 ?4,000 ? ?4,499 26 ?4,500 ?...
The accompanying frequency distribution represents the square footage of a random sample of 500 houses that...
The accompanying frequency distribution represents the square footage of a random sample of 500 houses that are owner occupied year round. Approximate the mean and standard deviation square footage. Square footage Lower Limit Upper Limit Frequency 0-499 0 499 5 500-999 500 999 17 1000-1499 1000 1499 33 1500-1999 1500 1999 121 2000-2499 2000 2499 119 2500-2999 2500 2999 81 3000-3499 3000 3499 47 3500-3999 3500 3999 41 4000-4499 4000 4499 26 4500-4999 4500 4999 10
The accompanying frequency distribution represents the square footage of a random sample of 500 houses that...
The accompanying frequency distribution represents the square footage of a random sample of 500 houses that are owner occupied year round. Approximate the mean and standard deviation square footage. LOADING... Click the icon to view the data table. The mean square footage is x overbarxequals=nothing. ​(Round to the nearest integer as​ needed.) The standard deviation square footage is Square footage Lower Limit Upper Limit Frequency 0-499 0 499 9 500-999 500 999 13 1000-1499 1000 1499 36 1500-1999 1500 1999...
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...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT