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 Microsoft Excel

EMAIL   Date: February 21 - 22, 2013   Location: Greensboro, NC
 
  Seminar    
Category  General/Residential [G/R]  
Attendance Hours  14.0  
Current Price  $ 305.00 AI
$ 355.00 Full
 
  Instructor    
John H. Urubek, MAI  
    
 
  Location    
Name  Deep River Event Center  
Address  606 Millwood School Road  
City  Greensboro  
State  NC  
Zip  27408  
Phone  (336) 542-3797  
 
Click Here to check state approvals
     
 
  Sponsor / Contact    
Chapter  North Carolina
Website  www.ncappraisalinstitute.org  
Contact Name  Nancy Linton-Hall  
Email  nancy@ncappraisalinstitute.org  
Phone  (336) 297-9511  
 
  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 14 days prior to program start date, $50.00 cancellation fee.
    • 7 - 13 days prior to program start date, $85.00 cancellation fee.
    • Less than 7 days prior to program start date, forfeit of payment.
    		        
    Cancellations
    All cancellations must be submitted writing via e-mail at nancy@ncappraisalinstitute.org or by fax at 336-297-9055. Confirmed participants should not assume that cancellation has been granted until confirmation has been received. No refunds 7 days or less prior to event.

    The North Carolina Chapter Appraisal Institute is not responsible for students' non-refundable airline reservations or other travel costs.

    The Chapter reserves the right to cancel, limit, or reschedule the program and to change faculty assignments and facility locations at any time.

    ADA Policy
    If you have a disability and require accommodations, please notify the NC Chapter office, 336-297-9511, at least two weeks in advance and we will arrange for reasonable accommodations. We reserve the rights to cancel, limit, or reschedule the course and to change faculty assignments and facility locations at any time. Prospective students should confirm their registration before making any nonrefundable airline reservations.


    Program materials can be downloaded by the student or can be picked up at the site.
     
      Additional Information    
    Seminar Materials
    Materials will be sent directly to your mailing address via UPS within four (4) weeks of the event, unless you choose the "download materials" option for a $15 savings
    or unless it is 10 business days or less until the event.
    Please do not forget to bring them with you to class!!

    Seminar Schedule
    Registration: 2/21/13: 8 a.m. -- 8:30 a.m.
    Class: 2/21-22/13 : 8:30 a.m. -- 4:30 p.m.

    CE Credit Approvals
    Appraisal Institute: 14 Hours
    NC Appraisal Board: 14 Hours

    Attendance Policy
    The Appraisal Institute and Appraisal Qualifications Board require 100% attendance in order to receive credit. If the attendance roster reflects less than 100%, it could/will show up on the roster submission to the states.

    Tuition Includes
    Seminar materials and breaks

    Seminar Location
    Deep River Event Center, 606 Millwood School Road, Greensboro, NC 27409; T 336-542-3797

    Lodging Information
    Courtyard by Marriott: (Wendover Ave.) -- Greensboro; T 336-294-3800 or 800-321-2211; Ask for the Appraisal Institute rate of $79++ per night, which includes Bistro Breakfast (a $10 value); Complimentary in room wireless; Newly renovated sleeping rooms; You may also register online at
    http://cwp.marriott.com/gsown/nccourseschedules/: Use Y8I for online booking discount code.
    Comfort Suites: (Thorndike Rd); T 336-882-6666; The Appraisal Institute Group rate is $79++ per night; Includes free Wi-Fi; full hot breakfast; manager's reception; free airport shuttle; has valet and laundry available.
    Fairfield Inn Airport: (Thorndike Rd): T 336-841-0140; The Appraisal Institute group rate is $84++ per night (King or Double); Includes complimentary hot breakfast; complimentary shuttle to airport and Deep River Event Center; Free In-room Wi-Fi and more;
    Use corporate code: Y8I if booking online: http://cwp.marriott.com/gsoap/appraisalinstitute/
    Holiday Inn Express & Suites: (Regional Rd): T 336-882-0004; The Appraisal Institute group rate is $79++ (Standard) and $99++ (King or Double Suites); Appraisal Institute Corporate Code: 100215437 for the website; Includes complimentary hot breakfast; complimentary shuttle to airport and to Deep River Event Center; Free In-room Wi-Fi; microwaves and refrigerators in most rooms; and more.



    •  Driving Directions