Back to Main Page

Quantitative Analysis in Real Estate (Summer 2009, 8-Week Session)

General information

• SPSS has a free 30-day trial version of their software.  SPSS website: http://www.spss.com/

Link to course blog (check regularly for announcements)

        http://reae5350.blogspot.com

Downloads (pdf files - requires Adobe Acrobat viewer)

Syllabus (Print and bring to class.)

General (print out select files below)

Z-table (Print and bring to class.)                                      T-table (Print and bring to class.)

Research Paper Outline (Print and bring to class.)            Class Example Data (Excel file)

Frequency Distribution Example (Print and bring to class.)  Class Outline and Notes (Print and bring these notes to class!)

Homework

Homework 1 questions                                                            Homework 2 Questions

Homework 2 SPSS Output

Noise Paper

Noise Paper Instructions & Grading Sheet                           Noise Data

Noise Output                                                                      Noise paper grading comments

3 citations

Final Project

Variable Input Form                                                               Area Maps

Project Default Data - Arlington Area 83-1 near UTA (Excel file- Updated for Summer 2009!)

Search Criteria: June 1, 2008 to June 7, 2009; Area 83

Library Research Tips

• Do an electronic search of many databases.  In addition to Business Source Premier try EconLit, Academic Search Premier, JSTOR, Kluwer Online, and Ingenta (although downloads are not always free on this one).
• Choose your Key Search Words carefully.  Start broad and then try to narrow into your topic.  For example, start with Real Estate and then try Hedonic and so on.  Also, use the term Property in place of Real Estate.  (Real Estate is called Property almost everywhere else in the world.  You might find some useful British or New Zealand references.)
• If you are having trouble thinking of a topic it might be helpful to flip through journals.  Check out the following journals: Appraisal Journal, Journal of Real Estate Research, Real Estate Economics, Land Economics, Urban Studies, and Journal of Real Estate Finance and Economics (and others). 
• Once you find one good citation, check out that citation’s citations.  Bet you find several other good ones (although they might be older so make sure you check for any recent ones).

Additional Research Websites

The following links are to websites that contain journal abstracts or articles.  Some of these sites might be useful resources for the research paper.  The sites in bold might be particularly useful.  Please note that these are just a few examples.

                                        Journal Title                                                                                    Link

Using Regression in Excel

Step 1: Load the Data Analysis Tool.  Go to Tools then Add In and check the Analysis TookPak box.  Click OK.

Step 2: Go back to Tools and at the bottom of the menu should be Data Analysis....  Click Data Analysis and scroll down to Regression.  Also, note there are several other useful functions such as frequencies, descriptive statistics, and ANOVA.

Step 3: Once in the regression menu it is pretty self explanatory (if not, don't forget the Excel help functions).  Basically, you just paint in the Y and X variables and indicated where and what you want your output to contain. 

GIS Related Links

ArcGIS website (ESRI): http://www.esri.com/ (free trial version)

MapInfo website: http://extranet.mapinfo.com/products/products_index.cfm?productcategoryid=1

MapPoint website:  http://www.microsoft.com/mappoint

Maptitude GIS software website: http://www.caliper.com/maptovu.htm

Other Relevant Links