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: February 28 - March 1, 2013   Location: Ontario, CA
 
  Seminar    
Category  General/Residential [G/R]  
Attendance Hours  14.0  
Current Price  $ 425.00 AI *
$ 525.00 Full *
* includes late fee
Late Fee  $ 50.00
 
  Instructor    
George Dell, MAI, SRA  
    
 
  Location    
Name  University of Phoenix  
Address  3110 E. Guasti Road  
   Suite 100  
City  Ontario  
State  CA  
Zip  91761-1219  
 
Click Here to check state approvals
     
 
  Sponsor / Contact    
Chapter  Southern California
Website  www.sccai.org  
Contact Name  Lianna Chaparyan / Linda Zimmer  
Email  lianna@sccai.org / Linda @sccai.org  
Phone  (818) 957-5111  
 
  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    
    Cancellation Policy
    • Up To 15 days prior to program start date, $50.00 cancellation fee.
    • 2 - 14 days prior to program start date, $100.00 cancellation fee.
    • Less than 2 days prior to program start date, forfeit of payment.
    		        
    ENROLLMENT
    Enrollment is on a first-come, first served basis. If the event is filled, a waiting list will be retained. The Southern California Chapter reserves the rights to cancel, limit, or reschedule this event if the minimum enrollment level is not reached, and to change faculty assignments and facility locations at any time. Prospective students should confirm their registration before making any non-refundable airline reservations. There are NO transfers; you must cancel out of the offering.

    ATTENDANCE
    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. One hundred percent (100%) attendance is required for all Appraisal Institute education programs. This follows Appraiser Qualification Board minimum criteria requirements.

    PREREQUISITES
    Some classes have prerequisites. Be sure to read the course description to find out if there are any prerequisites for this course.

    REQUIRED TEXTBOOKS
    Some classes have required textbooks. Be sure to read the class description to find out if there are any required textbooks for this course. There will not be any textbooks for purchase at the class. You must buy them ahead of time. If you arrive for a class without the required textbook credit for the class cannot be given and there will be no refund.

    REQUIRED EQUIPMENT
    Some classes require you bring a laptop and or other equipment. Be sure to read the class description to determine if any equipment is required. You are responsible for bringing your own extension cord(s). None will be provided. Please safeguard your equipment and personal belongings at all times. The Appraisal Institute, the Southern California Chapter, the Instructor or the facility will not be responsible for any loss of your personal belongings.

    CLASS MATERIALS TO DOWNLOAD
    Some classes are now available with downloadable materials. If you opted to download class materials instead of having them shipped to you, you will be required to bring the materials with you on a laptop or as a hard copy. If you do not have the materials with you credit for the class cannot be given and there will be no refund. Copies will not be available to you in the class. You are responsible for bringing your own extension cord(s). None will be provided.

    ADA COMPLIANCE
    It is the policy of the Appraisal Institute to provide reasonable accommodations for qualified persons with disabilities who are participating in Appraisal Institute educational programs. If you need accommodations to participate because of a disability, please notify us in writing at least two weeks in advance of the program and we will arrange for reasonable accommodation. Without two weeks’ notice, accommodation may not be available.

    COMPLETION CERTIFICATES
    For scannable exams, written notification of results will be sent to the examinee approximately 15 business days from the date of receipt of the exams at the national office.
    Certificates of completion for continuing education will be sent to the student in approximately 15 days from the date of the class. Express Grading is available. For more information contact the national office at (312)335-4207.

    Program materials can be downloaded by the student or can be picked up at the site.
     
      Additional Information    
    CHECK IN AT 8:00 AM

    CLASS STARTS AT 8:30 AM

    NO BREAKFAST OR REFRESHMENTS WILL BE SERVED.

    LUNCH: YOU ARE ON YOUR OWN

    PARKING: FREE

    TEMPERATURES IN CLASS ROOMS VARY. PLEASE DRESS ACCORDINGLY.

    •  FACILITY INFORMATION AND DIRECTIONS