Choose your path
This two-day course is designed for appraisal professionals who want to learn how to use Microsoft® Excel to
apply statistical methods to valuation problems. The course employs Excel’s "data analysis" add-in and charting
capabilities to assist in developing descriptive statistics and in using simple linear regression analysis to
estimate linear relationships between two variables. Topics include descriptive statistics, charts and tables,
an introduction to simple linear regression, assumptions underlying application of linear regression modeling,
nonlinear curve fitting, prediction and forecasting, data sufficiency, and separation of pooled data by submarket.
Participants will be engaged in hands-on learning, discovering and applying basic statistical methods to data sets
custom built to illustrate each session’s objectives in a valuation context. This course will help you gain a solid
understanding of simple linear regression analysis and be prepared for more advanced multiple linear regression study.
Upon completion of the course, participants should be able to:
• Understand and validate the assumptions underlying linear regression analysis
• Develop credible estimates of outcome variable values and associated confidence intervals
• Interpret Excel’s linear regression outputs
• Transform nonlinear relations into linear equivalents for analysis
• Develop forecasts from time-series data
Note: When participants receive their registration e-mail confirmation, a secure
link will be available where they will be instructed to download Excel files to use
for in-class exercises. Be sure you download these files prior to coming to class.
This course is in the Analytics for Valuation Professional Development Program.
For more information, click here.
• Table of Contents and Overview (PDF) • Schedule (PDF)
• An Introduction to Statistics for Appraisers
To order books and other materials go toour store
Please contact the sponsoring chapter for information on fees applicable to chapter programs.
• Laptops (external mouse recommended)
• A financial calculator is required. The accepted model used in the course is the HP-12C. Note: Cellular phones, tablets, iPads, and other devices that connect to the Internet are NOT permitted during the exam.
• Spreadsheet program: Excel 2010. You must be familiar with basic Excel and calculator operation when the course begins. Answers to problems in course material are shown using Excel 2010. Do not come to class expecting to be taught how to use Excel.
Note to Mac users: Microsoft does not support the Data Analysis Tool Pack in Mac Office Excel 2008 or Mac Office Excel 2011.
However, they do suggest free third-party add-ins with similar functionality. For more information,
click here for 2008 or click here for 2011.
AI CE Credit for Designated Members and Practicing Affiliates
• Attend Only = 145 points
• Attend and Pass = 200 points
• Real Estate Finance, Statistics, and Valuation Modeling or university-level introduction to statistics course
• Using Spreadsheet Programs in Real Estate Appraisals - The Basics or similar course/seminar
• Participants must sign a waiver at the beginning of the course stating that they have the prerequisites. If they do not, they will not hold the Appraisal Institute responsible and will not expect to receive special attention during the course.
Who Should Enroll
• General or Residential Candidates working on their designations
• MAIs or SRAs who want to further their statistics knowledge and skill base
• Residential or general certified appraisers
• Tax assessors
• Review appraisers
• Market researchers
Click Here for State Approvals
Pop up content here.