Shopping Cart    

Application & Interpretation of Simple Linear Regression Education Schedule (PDF)
Education Catalog (PDF)
Some AI educational programs may not be approved in every state.
Students should check state approvals prior to registering for any Appraisal Institute program.

ClassroomOn-Demand Online EducationLive Online (Synchronous)

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.

Program Overview
• Table of Contents and Overview (PDF)
• Schedule (PDF)

Recommended Text
• An Introduction to Statistics for Appraisers

Ordering Information
To order books and other materials go to
our 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
• Attorneys
• Bankers
• Review appraisers
• Market researchers

Click Here for State Approvals

Class Schedule & Locations

11/10/2015 - 11/11/2015
Location: Orlando, FL
Click here for location details
Sponsor: East Florida
Contact: Lauren Dowling, (813) 651-5904
Instructor: Wright, Larry T., MAI, SRA, AI-GRS

03/16/2016 - 03/17/2016
Location: Chicago, IL
Click here for location details
Sponsor: Chicago
Contact: L.A. Anderson, (312) 616-9406
Instructor: Urubek, John H., MAI

07/27/2016 - 07/28/2016
Location: Chicago, IL
Click here for location details
Sponsor: Chicago
Contact: L.A. Anderson, (312) 616-9406
Instructor: Urubek, John H., MAI

09/15/2016 - 09/16/2016, Thurs. & Fri.
Location: Ft. Lauderdale, FL
Click here for location details
Sponsor: South Florida
Contact: Debra McClave, (954) 229-0499
Instructor: Smeltzer, Mark V., SRA

Pop up content here.

Agree Disagree