[WEEK 2] Halifax & Edmonton Real Estate

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

Info icon This 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: 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 $
Image of page 1

Info icon This 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 ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern