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

    Date: August 1 - 2, 2013   Location: St. Paul, MN
 
  Seminar    
Category  General/Residential [G/R]  
Level  Basic/Intermediate  
Attendance Hours  14.0  
Current Price  $ 345.00 AI
$ 395.00 Full
Note
Please register early  		After Jul 22, 2013
$ 50.00 Late Fee
 
  Instructor    
John H. Urubek, MAI  
    
 
  Location    
Name  Continuing Education and Conference Center - U of M  
Address  1890 Buford Ave  
City  St. Paul  
State  MN  
Zip  55108  
 
Click Here to check state approvals
     
 
  Sponsor / Contact    
Chapter  North Star
Website  www.northstarai.org  
Contact Name  Maribelle Cushman  
Email  maribellec@aol.com  
Phone  (651) 633-0676  
 
  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, refund in full.
    • 2 - 14 days prior to program start date, $50.00 cancellation fee.
    • Less than 2 days prior to program start date, forfeit of payment.
    		       Program Material Policy

    Beginning 4 weeks before the offering start date, program material will be shipped directly to the student. If this material has been shipped and you request a registration cancellation, you will automatically be charged a $25.00 fee and you may keep the material. Once the fee is charged, your refund will be processed. Material returns are no longer accepted. Contact the offering sponsor for more information.
    • Cancel Offering, $25.00 material fee.
    ENROLLMENT: Enrollment is on a first-come, first served basis. If the event is filled, a waiting list will be retained. The North Star 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 with the Chapter office before making any nonrefundable airline reservations.


    ATTENDANCE: The North Star Chapter and the Appraisal Institute enforce the 100% attendance requirements mandated by the State of Minnesota, the AQB and other 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%. Students who are late or leave early will not receive credit.

    PROGRAM MATERIAL POLICY: Beginning four weeks before the course start date, program materials will be shipped to the student. If you do not receive your materials within five business days of the start date, PLEASE NOTIFY the North Star Chapter office immediately. All students must bring their materials with them to class; there will be NO EXTRA’s available. Students who have a late confirmed registration will pick up their materials at the registration desk on the first day of class.

    ADA POLICY: If you have a disability and may require some accommodation at any event, please notify us in writing at least 2 weeks in advance and we will arrange for reasonable accommodations.

    CANCELLATION: PLEASE READ CAREFULLY.
    The North Star Chapter charges a cancellation fee specific to each course/seminar.
    If you cancel less than 48 hours before the start of the course or seminar you will receive NO REFUND. All cancellations must be submitted in writing to the Chapter Office in order to receive a refund. Confirmed students should not assume that cancellation has been granted until a confirmation has been received. Direct your e-mail requests to: maribellec@aol.com or fax: 651.633.5956.

    Please remember, if you cancel there is an additional $25 material charge from the national office. You do not return course materials any longer

    Program materials can be downloaded by the student or can be shipped directly to the student. If you choose to have the material shipped and do not receive your materials within 5 days before the offering start date, please call the sponsor to inform them.
     
      Additional Information    
    Seminar Schedule:
    Aug. 1 - 8:00 am – 8:30 am - Registration; 8:30 am – 4:30 pm Lecture;
    Aug. 2 - 8:30 am - 4:30 pm Lecture
    The Fees include Instruction, Seminar Materials, Coffee Breaks and Lunch.

    Credit: Appraisal Institute Continuing Education Credit: full attendance at the Course and completion of the exam: 14 Hours.
    State of Minnesota: 14 Hours of Appraiser Continuing Education approved. 14 Hours of Real Estate CE applied for. Assessor CEUs

    All courses and seminars will be held at the Continuing Education and Conference Center, 1890 Buford Ave., St. Paul, MN 5510
    Hotel Information: Contact any of the following hotels and indicate you are attending a University of Minnesota course to receive a discounted rate.
    • Radisson Hotel – Roseville: 651.636.4567 or toll free: 800.333.3333 www.radison.com/rosevillemn (The Radisson has complimentary shuttle service available to the Continuing Education and Conference Center, if you request the shuttle service when you make your reservation.)
    http://marriott.com/property/propertypage/SACFR
    • Holiday Inn Express – 651.636.5800 - Shuttle service is available - please request when you make your reservation. 800-456-4000
    • Ramada Plaza, 1330 Industrial Blvd., Mpls., MN 55413, 612-331-1900 – Shuttle service is available - please request when you make your reservation.
    • Fairfield Inn – 651.636.7869 (or 1-800-228-2800 telling them you would like reservations at the Roseville, MN Fairfield Inn) http://marriott.com/property/propertypage/SACFR
    • St. Paul-Days Inn Roseville – 651.636.5966
    • Radisson Hotel Metrodome – 612.379.8888


    •  Map  

    •  Directions