rw spradlintaylor_238420_16446791_North Valley Real Estate Data Project1

.docx

School

Clovis Commuity College *

*We aren’t endorsed by this school

Course

4A

Subject

Economics

Date

Apr 3, 2024

Type

docx

Pages

13

Uploaded by SargentMoleMaster1703

Taylor Spradlin July 18, 2022 North Valley Real Estate Data I was curious to see how the price of a home correlated to the size of the home. I surveyed a total of 30 realtors from North Valley Real Estate to gather this data. Below you will find my findings. Record Price ($) Size (sq.ft) Pool (yes =1) 1 167962 1920 1 2 188799 1950 0 3 206424 1820 0 4 214910 1950 1 5 228810 2630 0 6 251269 2050 1 7 264160 2540 0 8 274482 2990 0 9 276000 2300 0 10 294086 3440 1 11 310622 3330 0 12 313200 3600 0 13 335610 2970 0 14 346150 3010 0 15 346421 2970 1 16 372360 3210 1 17 376146 3290 1 18 384020 4220 1 19 384420 4470 1 20 388960 4420 1 21 393557 3180 1 22 416120 4040 1 23 448800 5280 1 24 453913 3660 0 25 459950 4680 1 26 478675 4660 1 27 487494 4380 0 28 496100 4510 0 29 547596 4920 1 30 694430 5900 1
Houses Sold by Price Number of Classes 2 k > n 2 k > 30 = 5 Class Interval High Low k 694430 167962 5 = 105,294 I choose a class interval of 105,300. Table 1.1 Classes (Home Price) f Midpoint Cumulative Relative Frequency $167,950 to $273,250 7 214,910 7 0.23 $273,250 to $378,550 10 324,405 17 0.33 $378,550 to $483,850 9 416,120 26 0.30 $483,850 to $589,150 3 496,100 29 0.10 $589,150 to $694,450 1 NA 30 0.03 30 1.00 Table 1.2 167950-273249 273250-378549 378550-483849 483850-589149 589150-694450 0 2 4 6 8 10 12 Hisotgram Frequency of Homes Sold by Price Total Price ($) Frequency
Table 1.3 217,476 324,508 423,157 510,397 694,430 0 2 4 6 8 10 12 Frequency Polygon Frequency of Homes Sold by Price Price Frequency Mean: x = $ 10,801,446 30 = $ 36 0,048 Median: 372360 + 346421 2 = $ 359 , 391 Range: Highest – Lowest $ 694,430 $ 167,962 = $ 526,468 Standard Deviation: S = ( x x ) 2 n 1 S = 402650480342 30 1 S = 13884499322 S = $ 117832.51
Variance: Variance = ( x x ) 2 n 1 Variance = 402650480342 30 1 Variance = 13884499322 Level of Skewness*: *Data is positively skewed Level of skewness = 3 Mean Median St .Deviation Level of skewness = 3 ( 360048 359391 ) 117832.51 Level of skewness = 0.017 Coefficient of Variable: Coefficient of variation = St .Deviation Mean 100 Coefficient of variation = 117832.51 360048 100 Coefficient of variation = 32.73%
Table 1.4 Standard Deviation Table for Home Price: x Mean x - mean St. dev 167962 360048 -192086 36897031396 188799 360048 -171249 29326220001 206424 360048 -153624 23600333376 214910 360048 -145138 21065039044 228810 360048 -131238 17223412644 251269 360048 -108779 11832870841 264160 360048 -95888 9194508544 274482 360048 -85566 7321540356 276000 360048 -84048 7064066304 294086 360048 -65962 4350985444 310622 360048 -49426 2442929476 313200 360048 -46848 2194735104 335610 360048 -24438 597215844 346150 360048 -13898 193154404 346421 360048 -13627 185695129 372360 360048 12312 151585344 376146 360048 16098 259145604 384020 360048 23972 574656784 384420 360048 24372 593994384 388960 360048 28912 835903744 393557 360048 33509 1122853081 416120 360048 56072 3144069184 448800 360048 88752 7876917504 453913 360048 93865 8810638225 459950 360048 99902 9980409604 478675 360048 118627 14072365129 487494 360048 127446 16242482916 496100 360048 136052 18510146704 547596 360048 187548 35174252304
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