Back to Main Page

Quantitative Analysis in Real Estate

Announcements:

• Download Data has been updated to include Sale Prices.
• Noise Paper due on Saturday, November 19th!
• SPSS has a free 30-day trial version of their software.  SPSS website: http://www.spss.com/
• Prentice Hall sells a student version of SPSS.  http://vig.prenhall.com/catalog/academic/discipline/0,4094,3171,00.html

Downloads (pdf files - requires Adobe Acrobat viewer)

Syllabus

General

Z-table                                                                           T-table

Research Paper Outline                                                  Class Example Data (Excel file)

Frequency Distribution Example                                      Partial Class Outline

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)

Search Criteria: January 1, 2005 to October 1, 2005

Note: Default data has been changed and now includes the Sale Price!!!!  Also, please check your data if I have made custom download for you.

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

Josh1            Josh2        Josh3        Josh4

Other Relevant Links: