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 seminar, 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.
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,