Question Details

(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

 

Adjusted R Square

 

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

 

X Property Address

 

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
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Jan 30, 2021

PRICE: $15

Solution~0001000453.zip (25.37 KB)

Buy this answer for only: $15

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)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Jan 30, 2021

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN A DEADLINE.

Order Now