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
 
   


Practical Regression Using Excel

CALL   Date: October 18 - 19, 2012   Location: Albuquerque, NM
 
  Seminar    
Category  General/Residential [G/R]  
Attendance Hours  14.0  
Current Price  $ 325.00 AI *
$ 375.00 Full *
* includes late fee
Late Fee  $ 25.00
 
  Instructor    
John H. Urubek, MAI  
    
 
  Location    
Name  Four Hills Country Club  
Address  911 Four Hills Road, SE  
City  Albuquerque  
State  NM  
Zip  87123  
Phone  (505) 299-9555  
 
Click Here to check state approvals
     
 
  Sponsor / Contact    
Chapter  Rio Grande
Website  www.ai-riogrande.org  
Contact Name  Ruth Kelton  
Address  P.O. Box 801807  
City  Dallas  
State  TX  
Zip  75380-1807  
Email  ainorthtexas@sbcglobal.net  
Phone  (972) 233-2244  
 
  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 will 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    
    Cancellation Policy
    • Up To 15 days prior to program start date, $50.00 cancellation fee.
    • 2 - 14 days prior to program start date, $75.00 cancellation fee.
    • Less than 2 days prior to program start date, forfeit of payment.
    		        
    CANCELLATION POLICY:
    Requests for cancellation must be received in writing at the Chapter Office. The Chapter reserves the right to cancel, limit, or reschedule the seminar and to change faculty assignments and facility location at any time; therefore, prospective students should confirm their registration prior to making any non-refundable airline reservations. The Appraisal Institute, Rio Grande Chapter is not responsible for students’ non-refundable airline reservations or other travel costs.

    There are NO transfers; you must cancel out of the seminar.

    If you have received the seminar materials, and cancel from the seminar, a $75 cancellation fee will be assessed if you want to keep the materials.

    ATTENDANCE POLICY:
    The Appraisal Institute enforces attendance requirements mandated by state licensing and certification regulatory agencies. The Appraisal Institute issues certificates for state certification/licensing or state continuing education credit that verify successful completion and attendance of 100% with your grade notification letter for courses, or at the conclusion of seminars. Attendance at course orientation is mandatory. One hundred percent (100%) attendance is required for all Appraisal Institute education programs. This follows Appraiser Qualifications Board minimum criteria requirements.

    ADA COMPLIANCE:
    If you are disabled and/or have special needs, a prompt reply is required to allow sufficient time to arrange for reasonable accommodations. If notification is not requested in advance, we cannot guarantee the availability of accommodation on site. For additional information, please call the Chapter office at 972-233-2244.



    Program materials can be downloaded by the student or can be picked up at the site.
     
      Additional Information    
    IF THE SEMINAR MATERIAL WAS MAILED TO YOU, PLEASE MAKE SURE YOU BRING IT WITH YOU TO CLASS. ADDITIONAL SEMINAR MATERIAL WILL NOT BE AVAILABLE TO YOU AT THE CLASS.

    SEMINAR SCHEDULE:
    Registration – 8:00 to 8:30 am
    Day 1 Lecture – 8:30 am to 4:30 pm
    Day 2 Lecture - 8:30 am to 4:30 pm

    All day beverage service. Morning pastries and lunch will be provided.

    CONTINUING EDUCATION CREDITS:
    Appraisal Institute – 14 hours
    New Mexico Continuing Education (CE) - pending
    Texas Continuing Education (ACE) – 14 hours

    TUITION INCLUDES:
    Seminar materials. Tuition does not include textbooks or equipment.

    ACCOMMODATIONS:
    Hampton Inn Albuquerque-University/Midtown
    2300 Carlisle NE, Albuquerque, NM, 87110
    505-837-9300
    Guest room block reserved under "Appraisal Institute." Special room block rate - $65.00 + tax per night. Please contact the hotel no later than Friday, October 5 to book a room at the special rate.

    STUDENT ROSTERS:
    Students that do not wish to have their name, address, phone number and email address published to other students in the class must notify the Chapter five (5) days prior to the beginning of the seminar.