## (solution) What proportion of the variation in listing price is determined

• What proportion of the variation in listing price is determined by variation in the square footage?  What proportion of the variation in listing price is due to other factors?

• Check the coefficients in your summary output. What is the regression equation relating square footage to listing price?

Square Footage

1728

2918

2257

1672

8276

1279

1694

1954

1714

1750

2632

1688

3475

1960

2339

3043

2086

1086

2558

3738

1442

2087

2495

1677

2576

2062

2177

3158

1056

1244

2958

2696

1116

1130

2250

1713

1416

1425

2563

1805

3374

4124

5554

4247

2404

3282

2400 Listing Price

\$ 348,900.00

\$ 363,500.00

\$ 455,900.00

\$ 184,900.00

\$ 699,999.00

\$ 249,900.00

\$ 265,000.00

\$ 181,000.00

\$ 454,900.00

\$ 240,000.00

\$ 327,500.00

\$ 236,000.00

\$ 474,900.00

\$ 469,900.00

\$ 499,000.00

\$ 465,000.00

\$ 409,900.00

\$ 219,900.00

\$ 249,000.00

\$ 625,500.00

\$ 199,900.00

\$ 359,000.00

\$ 639,900.00

\$ 249,950.00

\$ 624,500.00

\$ 542,000.00

\$ 249,900.00

\$ 359,900.00

\$ 199,916.00

\$ 315,000.00

\$ 769,900.00

\$ 649,000.00

\$ 144,900.00

\$ 185,000.00

\$ 375,000.00

\$ 295,000.00

\$ 265,000.00

\$ 250,000.00

\$ 337,900.00

\$ 457,500.00

\$ 494,140.00

\$ 350,000.00

\$ 1,595,000.00

\$ 524,900.00

\$ 569,000.00

\$ 795,000.00

\$ 489,000.00 \$2,000,000.00

\$1,800,000.00

\$1,600,000.00

\$1,400,000.00

\$1,200,000.00 Listing Price \$1,000,000.00

\$800,000.00

\$600,000.00

\$400,000.00

\$200,000.00

\$0 1000 2000 3000 400 Square Foot 2349

3497

2177

2565

3136

1340

2957

3290

1650

2150

1344

1834

2316

2590

1772

1892

2230

1652

1200

975

2491

1752

1500

747

1450

1804

1513

3593

3000

2162

2471

2893

3640

2341

2200

1374

1809

3002

1695

2665

1936

2422

2278

1800

1910

1984

1331

1456 \$ 229,900.00

\$ 369,000.00

\$ 337,000.00

\$ 745,000.00

\$ 469,000.00

\$ 378,000.00

\$ 430,000.00

\$ 650,000.00

\$ 679,900.00

\$ 559,000.00

\$ 254,900.00

\$ 379,000.00

\$ 389,900.00

\$ 925,000.00

\$ 277,500.00

\$ 447,500.00

\$ 649,000.00

\$ 200,000.00

\$ 127,000.00

\$ 140,000.00

\$ 465,000.00

\$ 499,000.00

\$ 322,000.00

\$ 140,000.00

\$ 289,900.00

\$ 400,000.00

\$ 199,900.00

\$ 500,000.00

\$ 525,000.00

\$ 606,500.00

\$ 624,900.00

\$ 415,000.00

\$ 1,799,000.00

\$ 399,000.00

\$ 459,900.00

\$ 275,000.00

\$ 239,900.00

\$ 510,000.00

\$ 249,900.00

\$ 224,900.00

\$ 399,900.00

\$ 289,900.00

\$ 389,000.00

\$ 535,000.00

\$

82,000.00

\$ 259,999.00

\$ 275,900.00

\$ 285,000.00 1344

1672

5036

3800

4361 \$ 260,000.00

\$ 349,900.00

\$ 1,375,000.00

\$ 779,000.00

\$ 599,900.00 Column C

Linear (Column C) 1000 2000 3000 4000 Square Footage 5000 6000 7000 8000 9000 SUMMARY OUTPUT

Regression Statistics

Multiple R

0.622698752

R Square

0.387753736

0.381506325

Standard Error

211160.5556

Observations

100

ANOVA

df

Regression

Residual

Total Intercept

Square Footage SS

MS

F

Significance F

1 2767461031056 2.7675E+012 62.06630945 4.61011E-012

98 4369700461706 44588780221

99 7137161492762 Coefficients Standard Error

t Stat

P-value

Lower 95%

Upper 95%

71807.69521 50555.270691 1.420379997 0.158670813 -28517.59413 172132.9845

155.5627251 19.7459294537 7.878217403 4.61011E-012 116.3775707 194.7478794 Lower 95.0% Upper 95.0%

-28517.59413 172132.98455

116.3775707 194.74787942 Real Estate Regression

\$2,000,000.00

\$1,800,000.00

\$1,600,000.00

\$1,400,000.00

f(x) = 155.5627250571x + 71807.695208613

R² = 0.3877537357 \$1,200,000.00

Y \$1,000,000.00

\$800,000.00

\$600,000.00

\$400,000.00

\$200,000.00

\$0 1000 2000 3000 4000 5000 6000 7000 8000 9000

1815 Heiman St Nashville TN 37208

5000 Lewisdale Ct Nashville TN 37211

223 Orlando Ave Nashville TN 37209

1504 Autum Ridge Dr Nashville TN 37209

2015 Sweetbriar Ave Nashville TN 37212

1805 Willow Springs Dr Nashville TN 37216

996 Dozier Pl Nashville TN 37216

2230 Nashboro Blvd Nashville TN 37217

302 Sylvan Park LN Nashville TN 37209

5225 Greenleaf Dr Nashville TN 37211

7305 S Colony Ct Nashville TN 37221

4940 Yorkshire Rd Nashville TN 37211

6741 Christiansted Ln Nashville TN 37211

1523 Boscobel St Nashville TN 37206

3804 Baxter Ave Nashville TN 37216

1200 Applecross Dr Nashville TN 37220

1111 McKennie Ave Nashville TN 37206

2507 Woodyhill Dr Nashville TN 37207

724 Wildview Dr Nashville TN 37211

2200 Harding Place Nashville TN 37215

2608 Live Oak Road Nashville TN 37210

137 Elmhurst Ave Nashville TN 37207

213 Gentry Ave Nashville TN 37206

604 Coble Ct. Nashville TN 37211

704 Newberry Road Nashville TN 37205

4707 Utah Ave Nashville TN 37209

610 Tobylnn Circle Nashville TN 37211

1008 Hickory Bark Circle Nashville TN 37211

1525 Luton St Nashville TN 37207

707 Shelby Ave Nashville TN 37206

2003 Eastside Ave Nashville TN 37206

1306 Ashwood Ave Nashville TN 37212

559 Annex Ave Nashville TN 37209

126 Lucie St Nashville TN 37207

5167 Ashley Dr Nashville TN 37211

618 Cornet Dr Nashville TN 37209

1427 McGavock Pike Nashville TN 37216

8251 Coley Davis Road Nashville TN 37221

1409 Alteras Circle Nashville TN 37211

818 Melpark Ct Nashville TN 37204

7108 Natchez Pointe Pl Nashville TN 37221

1417 Timber Ridge Cir Nashville TN 37211

88 Valley Frg Nashville TN 37205

8449 Rolling Hills Dr Nashville TN 37221

414 N. 17St Nashville TN 37206

6510 Whittemore LN Nashville TN 37013 Listing Price

\$ 348,900.00

\$ 363,500.00

\$ 455,900.00

\$ 184,900.00

\$ 699,999.00

\$ 249,900.00

\$ 265,000.00

\$ 181,000.00

\$ 454,900.00

\$ 240,000.00

\$ 327,500.00

\$ 236,000.00

\$ 474,900.00

\$ 469,900.00

\$ 499,000.00

\$ 465,000.00

\$ 409,900.00

\$ 219,900.00

\$ 249,000.00

\$ 625,500.00

\$ 199,900.00

\$ 359,000.00

\$ 639,900.00

\$ 249,950.00

\$ 624,500.00

\$ 542,000.00

\$ 249,900.00

\$ 359,900.00

\$ 199,916.00

\$ 315,000.00

\$ 769,900.00

\$ 649,000.00

\$ 144,900.00

\$ 185,000.00

\$ 375,000.00

\$ 295,000.00

\$ 265,000.00

\$ 250,000.00

\$ 337,900.00

\$ 457,500.00

\$ 494,140.00

\$ 350,000.00

\$ 1,595,000.00

\$ 524,900.00

\$ 569,000.00

\$ 795,000.00 Square Footage

1728

2918

2257

1672

8276

1279

1694

1954

1714

1750

2632

1688

3475

1960

2339

3043

2086

1086

2558

3738

1442

2087

2495

1677

2576

2062

2177

3158

1056

1244

2958

2696

1116

1130

2250

1713

1416

1425

2563

1805

3374

4124

5554

4247

2404

3282 1105 Sunnymeade Dr Nasvhille TN 37216

2621 Walker LN Nashville TN 37211

945 S Woodstone LN Nashville TN 37211

5115 Brucewood Dr Nashville TN 37211

4105 Aberdeen Rd Nashville TN 37205

1008 Curdwood Blvd Nashville TN 37216

1006 9th Ave N Nashville TN 37208

813 Rodney Dr Nashville TN 37205

6605 Highway 100 Nashville TN 37204

2101 White Ave Nashville TN 37204

1610 Eastland Ave Nashville TN 37206

506 Drake Ave Nashville TN 37211

1338 Stainback Ave Nashville TN 37207

212 Lutie St Nashville 37210

930 Chancery LN Nashville TN 37205

1705 Welcome LN Nashville TN 37216

605 Coffee St Nashville TN 37208

3001 Blakemore Ave Nashville TN 37212

2402 Oakwood Ave Nashville TN 37207

1015 Capital Funds Ct Nashville TN 37217

334 Fairlane Dr Nashville TN 37211

441 Newton Ct Nashville TN 37209

1146 Cahal Ave Nashville TN 37206

385 Blackman Rd Nashville TN 37211

2403 Alarneda St Nashville TN 37208

1712 17th Ave N Nashville TN 37208

1900 Lombardy Ave Nashville TN 37215

1623 Chase St Nashville TN 37216

852 Forest Hills Dr Nashville TN 37220

2505 Stones River Ct Nashville TN 37214

256 Cherokee Station Dr Nashville TN 37209

310 S 11th St Nashville TN 37206

6607 Wilhugh Pl Nashville TN 37209

1504 Sweetbriar Ave Nashville TN 37212

2415 Foster Ave Nashville TN 37210

2010 Benjamin St Nashville TN 37206

2411 Gregory Dr Nashville TN 37216

5124 Edmondson Pike Nashville TN 37211

544 Nachez Bend Rd Nashville TN 37221

803 Cedarstone Way Nashville TN 37214

2505 Ravine Dr Nashville TN 37217

2228 Fernwood Dr Nashville TN 37216

708 E Colony Ct Nashville TN 37221

2140 Burns St Nashville TN 37216

1342 Rosa Parks Blvd Nashville TN 37208

456 Ewing Lane Nashville TN 37207

1013 Woodbury Falls Dr Nashville TN 37221

140 Keyway Dr Nashville TN 37208 \$ 489,000.00

\$ 229,900.00

\$ 369,000.00

\$ 337,000.00

\$ 745,000.00

\$ 469,000.00

\$ 378,000.00

\$ 430,000.00

\$ 650,000.00

\$ 679,900.00

\$ 559,000.00

\$ 254,900.00

\$ 379,000.00

\$ 389,900.00

\$ 925,000.00

\$ 277,500.00

\$ 447,500.00

\$ 649,000.00

\$ 200,000.00

\$ 127,000.00

\$ 140,000.00

\$ 465,000.00

\$ 499,000.00

\$ 322,000.00

\$ 140,000.00

\$ 289,900.00

\$ 400,000.00

\$ 199,900.00

\$ 500,000.00

\$ 525,000.00

\$ 606,500.00

\$ 624,900.00

\$ 415,000.00

\$ 1,799,000.00

\$ 399,000.00

\$ 459,900.00

\$ 275,000.00

\$ 239,900.00

\$ 510,000.00

\$ 249,900.00

\$ 224,900.00

\$ 399,900.00

\$ 289,900.00

\$ 389,000.00

\$ 535,000.00

\$

82,000.00

\$ 259,999.00

\$ 275,900.00 2400

2349

3497

2177

2565

3136

1340

2957

3290

1650

2150

1344

1834

2316

2590

1772

1892

2230

1652

1200

975

2491

1752

1500

747

1450

1804

1513

3593

3000

2162

2471

2893

3640

2341

2200

1374

1809

3002

1695

2665

1936

2422

2278

1800

1910

1984

1331 213 N 9th St Nashville TN 37206

220 Treutland Ave Nashville TN 37207

713 45th Ave N Nashville TN 37209

408 Hyde Park Nashville TN 37215

6009 Sherwood Dr Nashville TN 37215

1123 Osprey Ln Nashville TN 37221 \$ 285,000.00

\$ 260,000.00

\$ 349,900.00

\$ 1,375,000.00

\$ 779,000.00

\$ 599,900.00 1456

1344

1672

5036

3800

4361 Number of Bedrooms

3

4

3

3

4

3

5

3

2

3

3

3

4

3

3

4

3

3

3

4

2

3

4

3

3

3

3

4

3

2

3

3

3

2

4

3

3

3

4

3

4

7

3

3

3

5 4

3

5

3

4

5

3

4

4

3

3

3

4

3

3

3

3

3

4

2

2

3

2

3

2

3

3

3

4

6

3

3

4

5

4

3

3

3

3

2

3

3

3

3

2

3

4

3 2

3

3

4

5

4

Solution details:
STATUS
QUALITY
Approved

This question was answered on: Jan 30, 2021

Solution~0001000453.zip (25.37 KB)

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

STATUS

QUALITY

Approved

Jan 30, 2021

EXPERT

Tutor