{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

[WEEK 2] Halifax & Edmonton Real Estate

[WEEK 2] Halifax & Edmonton Real Estate - MLS listings...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
MLS listings from the CREA website for Halifax, Nova Scotia. The listings are in close proximity to St Mary's University and Dalhousie University. To Create a Frequency Distribu Retrieved December 2010 at:www.crea.ca 1. Insert>Pivot Table 2. Select the range of values inclu List Price Type Full Baths Half Baths 3. Drag and drop the List Price fie $ 164,900 Townhouse 1 1 0 515 Count of List Price 4. We want to change the Sum to $ 167,510 Apartment 1 1 0 518 Row Labels Total Value Field Settings… choose $ 179,000 Apartment 1 1 0 720 0-399999 40 5. Now in the actual Pivot Table, r $ 179,000 Apartment 1 1 0 720 400000-799999 42 8. Once you have filled in these v $ 184,900 Apartment 1 1 0 500 800000-1199999 7 $ 189,000 Apartment 1 1 0 840 1200000-1599999 7 $ 192,779 Apartment 1 1 0 612 1600000-1999999 1 $ 214,900 Apartment 2 1 1 1050 2400000-2799999 1 $ 219,500 Apartment 2 1 0 1130 Grand Total 98 $ 220,000 Apartment 2 1 0 1010 $ 222,400 House 2 1 1 1428 $ 227,000 Apartment 2 1 0 1014 Relative $ 229,000 Apartment 2 1 1 1050 Count of List Price Mid Point Relative Cumulativ Cumulative $ 237,500 Apartment 1 1 0 742 Row Labels (x1000) Total Frequency Frequency Frequency $ 239,000 Apartment 1 1 0 609 0-400000 40 $ 241,745 Apartment 1 1 0 749 400000-800000 42 $ 244,900 Apartment 1 1 0 713 800000-1200000 7 $ 249,000 Apartment 2 2 0 1293 1200000-1600000 7 $ 249,999 Townhouse 2 1 0 1150 1600000-2000000 1 $ 269,000 Apartment 1 1 0 831 2000000-2400000 0 $ 274,900 House 3 1 0 1104 2400000-2800000 1 $ 274,900 Townhouse 2 1 1 1105 $ 289,900 Apartment 1 1 0 550 Grand Total 98 $ 292,000 Apartment 2 2 0 1057 $ 295,000 Townhouse 3 1 0 1200 $ 299,000 Apartment 1 1 0 880 $ 299,900 House 3 1 0 1560 $ 299,900 Townhouse 2 1 1 1379 $ 324,900 Townhouse 3 1 1 1600 $ 332,000 Apartment 1 2 0 937 $ 335,000 Apartment 1 1 0 780 $ 339,900 Apartment 1 1 0 800 $
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}