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

CALL   Date: April 18 - 19, 2013, Class is on Thursday & Friday   Location: Ft. Lauderdale, FL
 
  Seminar    
Category  General/Residential [G/R]  
Attendance Hours  14.0  
Current Price  $ 375.00 AI
$ 475.00 Full
 
  Instructor    
James B. Atwood, SRA  
    
 
  Location    
Name  Courtyard by Marriott, Cypress Creek  
Address  2440 West Cypress Creek Rd.  
City  Ft. Lauderdale  
State  FL  
Zip  33309  
Phone  954-772-7770  
 
Click Here to check state approvals
    
 
  Sponsor / Contact    
Chapter  South Florida
Website  www.southflorida-ai.org  
Contact Name  Debra McClave  
Email  sfchap@bellsouth.net  
Phone  (954) 229-0499  
 
  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.
    • 7 - 14 days prior to program start date, $100.00 cancellation fee.
    • Less than 7 days prior to program start date, forfeit of payment.
           
    Cancellations/Refunds: Requests for cancellations must be received in writing at the chapter office. Confirmed students should not assume that cancellation has been granted until a confirmation has been received. Direct your email requests to: sfchap@bellsouth.net. There are NO transfers; you must cancel out of the offering.

    The South Florida Chapter of the Appraisal Institute is not responsible for students' non-refundable airline reservations or other travel expenses. The Chapter reserves the right to cancel, limit, or reschedule the program and to change faculty assignments and facility locations at any time.

    Required Equipment: Some classes require you to 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 equipment, none will be provided. Please safeguard your equipment and personal belongings at all times. The Appraisal Institute, the South Florida Chapter, the Instructor or the facility will not be responsible for the loss of your personal belongings.

    Program materials will be shipped directly to the student. If you do not receive your materials within 5 days before the offering start date, please call the South Florida Chapter at 954-229-0499 to inform them.

    Download Materials: If you requested a download of the seminar materials, please bring a copy with you or have it loaded on your laptop for viewing.

    Please note: If you opted to download the materials when you registered, you will not receive the seminar workbook. Bring a copy of the downloaded seminar materials with you or have them loaded on your laptop. You cannot attend the class without seminar materials. NO ADDITIONAL SEMINAR WORKBOOKS WILL BE AVAILABLE AT THE CLASS.

    Course Attendance: One hundred percent (100%) attendance is required for all Appraisal Institute education programs. This follows Appraiser Qualification Board minimum criteria requirements.

    State Certification: Students should contact their specific state to determine current education approval and requirements. Please follow the link above under locations to verify certification in your state.

    Continuing Education Credit: Appraisal Institute: 14-Hours
    Florida Real Estate Appraisal Board Credit: 14-Hours, 0009006

    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.

    ADA Policy: If you have a disability and may require special accommodation, please notify us in writing at least two (2) weeks in advance and we will arrange for reasonable accommodation.


    Program materials can be downloaded by the student or can be picked up at the site.
     
      Additional Information    
    Course Schedule: Registration/Class, Thursday, April 18, 2013: 8:15 a.m. – 4:30 p.m.
    Class, Friday, April 19, 2013: 8:30 a.m. – 4:30 p.m.

    Required 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.

    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.

    Hotel Accommodations: Courtyard by Marriott, please call in-house reservations @ 954-772-7770. Rate is $79 per night. Mention the Appraisal Institute when reserving a room. Register early! Thirty (30) days prior to arrival date.

    Directions:
    Fort Lauderdale Airport (12 miles north): Exit the Airport following direction signs to I-95 North. Proceed North on I-95 to Cypress Creek Road WEST, Exit 33B. Proceed west off of the Exit 1.9 miles. The hotel is located on the left hand side of the road. Estimated taxi fare: $42.00 (one way).

    Miami International Airport (37 miles north): Merge onto Airport Expressway/FL-112 E toward I-95 N/ BEACHES (Portions toll). 4.4 miles and take the I-95 South exit toward DOWNTOWN. 0.2 miles. Merge onto I-95 N via the exit on the LEFT toward FT. LAUDERDALE/ORLANDO approximately 29.1 miles. Exit on Cypress Creek Road WEST, Exit 33B. Proceed west off of the exit 1.9 miles. The hotel is located on the left hand side of the road. Estimated taxi fare: $70.00 (one way).

    Program materials will be shipped directly to the student. If you do not receive your materials within 5 days before the offering start date, please call the South Florida Chapter at 954-229-0499.

    Download Materials: If you requested a download of the seminar materials, please bring a copy with you or have it loaded on your laptop for viewing.

    Please note: If you opted to download the materials when you registered, you will not receive the seminar workbook. Bring a copy of the downloaded seminar materials with you or have them loaded on your laptop. You cannot attend the class without seminar materials. NO ADDITIONAL SEMINAR WORKBOOKS WILL BE AVAILABLE AT THE CLASS.

    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.

    Temperatures in the classrooms vary. Please dress accordingly.


      Courtyard by Marriott