Application & Interpretation of Simple Linear Regression

Description

This two-day course is designed for appraisal professionals who want to use Microsoft® Excel in applying 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 participants gain a solid understanding of simple linear regression analysis and be prepared for more advanced multiple linear regression study.

 

This course is in the Analytics for Valuation Professional Development Program. View this list of FAQs, which includes information regarding the courses you’ll need to complete the program successfully.

Sponsor Date Location Delivery Format Check
State Approvals
 

Program State Approval & Hours

Some AI educational programs may not be approved in every state and every delivery format. To see a list of all state approvals across all formats for this course, please use the link below.

View all approvals for this course

Who should Enroll

  • General or residential Candidates for Designation who are working on their designations 
  • MAIs or SRAs who want to further their statistics knowledge and skill base
  • Certified general or residential real property appraisers
  • Tax assessors
  • Attorneys
  • Bankers
  • Review appraisers
  • Market researchers

Objectives

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

Prerequisites


Exam

Yes, 1 hours

Level

Intermediate

Appraisal Institute CE Points

Attend: 150 AI Points,  Attend and Pass Exam: 200 AI Points,  Pass Only: 150 AI Points

Class Time

14 hours

Assignments

Yes. After you register for this class, please go to your Education and Events page for
details on what you must complete BEFORE class begins.
 
To access your Education and Events page, log on to the Appraisal Institute website at https://ai.appraisalinstitute.org/eweb (click on the three horizontal lines to the left of the AI logo and select “My
AI Account” from the drop-down menu).

Program Overview


Required and/or Recommended Equipment

Classroom
  • A laptop computer is required.
  • Microsoft Excel 365 must be loaded and operational. If you do not have Excel, you may download a free trial at http://office.microsoft.com/en-us/try/. Please note that this links to the latest version of Excel. There may be minor differences between versions. 
  • Solver Add-In and Analysis Tool Pak must be installed prior to class. Note. These add-ins may not work with the online version of Excel. As a result, it is highly recommended that you download a computer-based version of Excel.
  • Note to Apple Mac Users: The course will be taught in Windows using Excel 365. You will need the latest version of Excel in order to perform some of the exercises. Also, Microsoft does not support the Data Analysis Tool Pack in Mac Office Excel 2011. However, they do suggest free third-party add-ins with similar functionality. For more information, click here.
  • A regular-function or financial calculator is required for the exam.

Synchronous
  • A laptop computer is required.
  • Microsoft Excel 2010 or later must be loaded and operational. If you do not have Excel, you may download a free trial at http://office.microsoft.com/en-us/try/. Please note that this links to the latest version of Excel. There may be minor differences between versions. 
  • Solver Add-In and Analysis Tool Pak must be installed prior to class.
  • Note to Apple 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.
  • A regular-function or financial calculator is required for the exam.

System Requirements

None specified

Additional Information

Course Materials Include:

  • Course Handbook (308 pp.)
  • Pre-Class Downloads (232 KB)
  • Post-Class Solutions Downloads (369 KB)
  • Pre-Class Memo (1 p.)
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 to download these files prior to coming to class.

You will be asked to clear the calculator’s memory before and after the examination. Only one calculator is permitted in the testing room. Examinees taking most AI exams may bring their own calculator to use during the exam. Laptops, cellular phones, tablets, iPads, wearable technology (smart watch, Apple Watch, Google Glass, etc.), and other devices that can store data or connect to the Internet are NOT permitted during the exam. In addition, all watches, wallets, bags, and purses must be removed and stored out of reach prior to taking the exam.


Book Recommendations