Home | Site Map | Contact Us

  View Cart              View Cart             
0 Registrations in Cart
 
 
Welcome. If you are a returning student or previously created an AI website account, please log in.
Back to Schedule  |  Select an Offering  |  Forgot Password?  |  Create Login
 
   


Promotional Package
Save $ 25.00 AI / 35.00 Reg   March 2013-Residential Applications & Practical Regression w/Excel $ 425.00 AI
$ 465.00 Reg      
Availability
Inquiry?
  
Residential Applications: Using Technology to Measure and Support Assignment Results Seminar
Details
[Res]    7  Mar 26, 2013 Little Rock, AR Arkansas Chapter Availability
Inquiry?
  
Practical Regression Using Microsoft Excel Seminar
Details
[G/R]   14  Mar 27 - 28, 2013 Little Rock, AR Arkansas Chapter Availability
Inquiry?
  

Practical Regression Using Microsoft Excel

EMAIL   Date: March 27 - 28, 2013   Location: Little Rock, AR
 
  Seminar    
Category  General/Residential [G/R]  
Attendance Hours  14.0  
Current Price  $ 275.00 AI
$ 300.00 Full
 
  Instructor    
Jim Amorin, MAI, SRA  
    
 
  Location    
Name  Searcy Building Conference Room  
Address  10809 Executive Center Drive  
City  Little Rock  
State  AR  
Zip  72211  
Phone  (501) 224-1200  
 
Click Here to check state approvals
    
 
  Sponsor / Contact    
Chapter  Arkansas
Website  www.appraisalinstituteofAR.com  
Contact Name  Lynda Hampel  
Email  appraisalinst@sbcglobal.net  
Phone  (501) 786-4502  
 
  Description    

Today, many lenders require more support for adjustments, especially for market conditions. In litigation, recent court decisions require experts to prove their work or risk exclusion by judges. The appraisal profession faces increased competition from brokers and accountants who want to provide alternative valuation products like AVMs and BPOs.

This two-day seminar, a hands-on experience, is designed for both residential and commercial appraisers. Participants will use Microsoft Excel's statistical and graphic tools to aid many everyday valuation problems, such as statistical support for market delineation, highest and best use, adjustments, and value estimates. Students will complete this seminar a step ahead of the competition with a new set of skills they can use the very next day!

Upon completion of the seminar, participants should be able to:

  • Use simple regression and small data sets to support a variety of adjustments
  • Understand how statistical modeling can improve valuation support
  • Compute descriptive statistics that assist in identifying market segments
  • Use indications of dispersion to evaluate risk
  • Utilize statistics to expand the availability of data
  • Interpret results of statistical analyses
  • Prepare dazzling graphs to communicate findings in a pictorial and persuasive fashion

     

    Prerequisites

    This seminar is designed for both residential and commercial appraisers with a basic knowledge of spreadsheets, especially Excel. Participants should also have a basic understanding of market analysis, highest and best use, and the sales comparison approach. 

    Note.  This seminar will be taught using Excel 2007 or 2010. If you are taking the seminar and plan to use an Apple laptop, you will need to have the latest version of Excel (2011) in order to perform some of the exercises.

     

  •  
      Equipment    
    All students MUST HAVE a laptop computer with MICROSOFT Excel 2007 or 2010 loaded and operational. Be sure that Solver Add-in and Analysis Tool Pak Add-in are installed prior to class. If you do not currently own MICROSOFT EXCEL, you can download a free copy for 60 days at Microsoft Excel Free Trial.

    Note. This seminar is hands-on! 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.

     
      Disclaimer    
             


    Program materials can be downloaded by the student or can be picked up at the site.