MAT 240 RealEstate Data 3-3

xlsx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

240

Subject

Economics

Date

Feb 20, 2024

Type

xlsx

Pages

8

Uploaded by ConstableFire16218

Report
Region State County listing price square feet random East North Central mi bay 145,100 $117 1,239 0.9438599 East North Central oh cuyahoga 265,100 $136 1,947 0.0089883 East North Central oh clark 240,500 $137 1,752 0.9626635 East North Central oh marion 149,700 $116 1,296 0.5168714 East North Central il vermilion 254,500 $156 1,632 0.9859023 East North Central il peoria 187,900 $131 1,434 0.1416905 East North Central il ogle 236,600 $208 1,138 0.0479568 East North Central il madison 254,500 $156 1,628 0.9181611 East North Central il kankakee 148,700 $115 1,293 0.2131548 East North Central oh montgomery 225,300 $151 1,493 0.5246015 East North Central mi saginaw 171,800 $118 1,452 0.3335134 East North Central mi calhoun 266,200 $130 2,042 0.1811563 East North Central oh lawrence 248,300 $156 1,587 0.0162423 East North Central wi manitowoc 181,400 $140 1,294 0.0777598 East North Central il mclean 203,800 $134 1,526 0.2411877 East North Central il dekalb 347,500 $97 3,574 0.3710335 East North Central oh ashland 188,000 $151 1,246 0.18987 East North Central oh muskingum 188,300 $94 1,999 0.2909724 East North Central wi grant 243,200 $121 2,014 0.7634675 East North Central in madison 229,100 $187 1,224 0.8882037 East North Central oh jefferson 246,500 $136 1,814 0.7317699 East North Central il stephenson 235,600 $140 1,682 0.2719352 East North Central il adams 266,100 $166 1,599 0.8442448 East North Central oh huron 199,700 $147 1,359 0.4341986 East North Central il sangamon 213,500 $130 1,643 0.6438998 East North Central il knox 205,100 $118 1,740 0.7032371 East North Central oh wayne 256,700 $129 1,986 0.7230611 East North Central in grant 219,500 $116 1,898 0.296003 East North Central oh belmont 172,500 $101 1,710 0.7242036 $'s per square foot
Regression Equation slope Intercept R (correlation) Slope and Intercepts Slope Intercept R-squared Coefficient
Sample National Mean Price $ 220,368.97 $ 342,365.00 Median Price $ 225,300.00 $ 318,000.00 Std Dev Price $ 44,347.81 $ 125,914.00 Sample National Mean Sq Ft 1,663 2,111 Median Sq Ft 1,628 1,881 Std Dev Sq Ft 455 921 1,000 1,500 2,000 2,500 3,000 3,500 4,000 100,000 150,000 200,000 250,000 300,000 350,000 400,000 f(x) = 69.514880312621 x + 104732.160649616 Square Footage vs. Listing Price Square Footage Listing Price
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
69.515 6951.5 188150 104732 0.7128185619 Positive, strong because it is closer to 1 69.515 104732 0.508110302151415 How much the listing price is varying versus the amount of square footage.
Have Outlier because the random sample is a representative of ENC, and potentially there are few homes that are larger in the sq ft area. Price will be higher because the sq ft will be higher.
Predicted Listing Price
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
x= sq ft area y= listing price
229859