Choose your path
Find An Appraiser         Online Store         Donate         Lum Library         Join
 View Cart View Cart
0 Registrations in Cart
Appraisal Institute  
AI Resources Education Publications Professional Practice News Advocacy About Us
Select an Offering

Application & Interpretation of Simple Linear Regression

CALL   Date: November 15 - 16, 2018   Location: Knoxville, TN
Category  Other [Oth]  
Attendance Hours  14.0  
Exam Hours  1.0  
Current Price  $ 335.00 AI Price  
$ 385.00 Full Price  
John H. Urubek, MAI  
Name  UT Conference Ceneter  
Address  600 Henley St  
   4th Floor  
City  Knoxville  
State  TN  
Zip  37902  
Click Here to check state approvals
  Sponsor / Contact  
Chapter  Greater Tennessee
Contact Name  Myra W. Pitts  
Phone  (615) 515-9700  
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)
• 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
• Laptops (external mouse recommended)
• A four-function calculator is required. 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.
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.
  For Further Reading  
  An Introduction to Statistics for Appraisers  
Cancellation Policy
  • Up To 15 days prior to program start date, $25.00 cancellation fee.
  • 7 - 14 days prior to program start date, $50.00 cancellation fee.
  • Less than 7 days prior to program start date, forfeit of payment.
  Transfer Policy
  • Up To 15 days prior to program start date, $25.00 transfer fee.
  • 7 - 14 days prior to program start date, $25.00 transfer fee.
  • Less than 7 days prior to program start date, no transfer allowed.
AMERICANS WITH DISABILITIES ACT: In order that we may comply with ADA, we need advance notice of any special needs you may have. Please provide written details of any special needs you may have under ADA on a separate page and send it in at least two weeks in advance in order that reasonable accommodations may be arranged.

Program materials can be downloaded by the student.
  Additional Information  
UT Conference Center
600 Henley Street
Knoxville, TN 37902
4th Floor

Registration: 7:30am eastern time
Class begins: 8am eastern time

Parking located in the Locust Street Garage on the corner of Locust and Clinch Streets. Cost is $7 per day.

Sponsor / Contact
Chapter: Greater Tennessee
Contact: Myra Withers Pitts
Phone: 615-515-9700

Area Hotel:
Hilton Knoxville
501 W Church Ave
Knoxville, TN
(865) 523-2300

(Anything downtown will be close to the UT Conference Center. I suggest using Hotwire or Priceline or something like that as we do not have a preferred rate anywhere).



Appraisal Institute
200 W. Madison, Suite 1500, Chicago, IL 60606
888-7JOINAI (756-4624)  |
Contact Us   |   Site Map   |   Terms & Conditions   |   Privacy Policy   |   Advertise
  Copyright © 2017 Appraisal Institute. All rights reserved.