Shopping Cart    
Search
Login
Welcome,   My Account


   
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 (PDF)
• Schedule (PDF)

Recommended Text
• An Introduction to Statistics for Appraisers

Ordering Information
To order books and other materials go to
our store

Tuition
Please contact the sponsoring chapter for information on fees applicable to chapter programs.

Required
• 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

2008: http://answers.microsoft.com/en-us/mac/forum/macoffice2008-macexcel/what-happened-to-the-data-analysis-toolpak-or/7a9e9491-cb73-4496-ac06-3ada487c719a
2011: http://answers.microsoft.com/en-us/mac/forum/macoffice2011-macexcel/what-happened-to-the-data-analysis-toolpak-or/740ff33a-6ed9-4553-bc09-5cef06ce5f23

Hours
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

Prerequisites

Recommended:

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/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
Register


06/11/2015 - 06/12/2015
Location: Las Vegas, NV
Click here for location details
Sponsor: Las Vegas
Contact: Tina Anderson, (702) 838-8489
Instructor: Wright, Larry T., MAI, SRA
Register


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






Pop up content here.

Agree Disagree