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 (PDF)
• Schedule (PDF)
• An Introduction to Statistics for Appraisers
To order books and other materials go to
Please contact the sponsoring chapter for information on fees applicable to chapter programs.
• Laptops (recommend external mouse)
• Spreadsheet program: Excel 2010
• 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.
• 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, see
15 (14 classroom + 1-hour exam)
AI CE Credit for Designated Members, Candidates for Designation, 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, attorneys, bankers, review appraisers, market researchers.
Click Here for State Approvals
Class Schedule & Locations
10/28/2014 - 10/29/2014
Location: Memphis, TN
Click here for location details
Contact: Susan F. Evans, (901) 218-0782
Instructor: Vernor, PhD, James D., MAI
11/05/2014 - 11/06/2014
Location: San Juan, PR
Click here for location details
Sponsor: Puerto Rico and Caribbean
Contact: Daphne Comas, SRA, AI-RRS, (787) 607-0840
Instructor: Wright, Larry T., MAI, SRA