"Bayfield provides high quality training in many technical aspects of Real Estate"
Head of Global Forecasting & Strategy, DTZ

Quantitative Research Models

Course Length: 2-day
Pre-requisite: Familiarity with basic statistical concepts

This is a new course trialed over the last year with excellent feedback from top international property consultancies. Delegates will learn the advantages of Excel and econometric software, consider data sources and how to prepare data for analysis, regression analysis, dummy variables, indexation models including how to model property cycles.

The course is designed especially for researchers and some degree of statistical knowledge is assumed. The material is reinforced with case studies including UK and Chinese property price indices and price determination models. This is the newest in our suite of courses and is continually being updated to reflect the market and delegate feedback. The course can also be customised to your requirements.

Who will benefit from this course?
This course is essential for anyone involved in quantitative research. UK and Chinese case studies give the universal nature of statistics an international relevance from a real estate perspective. Bayfield Training are not aware of any existing executive programs that are similar to this quantitative research models course. Making Bayfield once again pioneers in real estate modelling training.

Included with course

  • All Excel/Eviews models used on the course, provided on disk
  • 2-months post course email and telephone support
  • Comprehensive course manual (also available separately and designed for self-study)

Course Outline – Day 1(of 2)

Know how to assess and prepare data and use regression analysis for property solutions
Part A (morning) – Data Analysis Fundamentals

  • Introduction to course and intro to Excel v. Econometric packages
  • Basic modelling rules, a priori economic thought, sound economic basis
  • The impact of poor quality data
  • The effects of smoothed data
  • Transformation of data – making data real & logging data in Excel
  • Trend analysis, forecasting & back-casting
  • Decomposition, smoothing, moving averageCase Study: UK property price indices

Part B (afternoon) – Modelling in Excel & Eviews

  • OLS models and analysis of EViews output and multiple linear regression
  • Assessing regression models
  • Testing hypothesis about coefficient estimates
  • Measuring real estate investment return and risk
  • Hedonic price modelling and real estate valuation
  • Case Study: Property price determination in the town of HertfordCourse Outline – Day 1(of 2)

Course Outline – Day 2(of 2)

Know how to model real estate cycles and develop a property price index

Part C (morning) – Using Dummy Variables in OLS

  • Categorical data and dummy variables in OLS
  • Creating dummy variables in Eviews
  • Interactions
  • Interpreting OLS output when dummy variables are involved
  • Modelling real estate cycles using dummy variables
  • Case Study: Land prices in Hong Kong: 1985 – 2007

 Part  D (afternoon) – Property Price Index

  • Weighted Average Method of Indexing using Excel, Pros & Cons
  • Repeat Sales Method: Application, Eviews, Pros & Cons
  • Hedonic Price Method: Application, Eviews, Pros & Cons
  • Case Study: Centa-City Property Index
  • Course Summary