Skip to Content (custom)

    Application & Interpretation of Simple Linear Regression

    More Info Register
    August 21-22, 2024 Walnut Creek, CA
    Date
    August 21-22, 2024
    Sponsor
    Northern California Chapter
    Location
    Treat Towers
    1255 Treat Boulevard
    First Floor Conference Room
    Walnut Creek, CA 94597
    Instructor
    John H. Urubek, MAI, AI-GRS
    Class Time
    14 hours
    Exam Time
    1 Hour
    Full Price
    $580.00
    AI Price
    $480.00
    Enroll by August 9 and save $75!
    View Pricing Options
    Course Description
    Are you interested in learning how to use Excel to apply statistical methods to valuation problems? The course employs Microsoft® Excel’s “data analysis” add-in and charting capabilities to assist in developing descriptive statistics and in using simple linear regression analysis to estimate linear relationships between two variables. Topics include descriptive statistics, charts and tables, an introduction to simple linear regression, assumptions underlying application of linear regression modeling, nonlinear curve fitting, prediction and forecasting, data sufficiency, and separation of pooled data by submarket. Through hands-on exercises, you’ll apply basic statistical methods to data sets custom built to illustrate each session’s objectives in a valuation context. You’ll gain a solid understanding of simple linear regression analysis and be prepared for more advanced multiple linear regression study.

     

    This course is in the Analytics for Valuation Professional Development Program. View this list of FAQs, which includes information regarding the courses you’ll need to complete the program successfully.

    Who Should Enroll
    • General or residential Candidates for Designation who are working on their designations 
    • MAIs or SRAs who want to further their statistics knowledge and skill base
    • Certified general or residential real property appraisers
    • Tax assessors
    • Attorneys
    • Bankers
    • Review appraisers
    • Market researchers
    AI CE Points
    Attend:
    150
    Attend & Pass Exam:
    200
    Pass Only:
    150
    State Approvals
    State QE/CE Course & Exam Course Only Exam Only Delivery Format Approval Format Start Date Expire Date State Code
    AK CE 15 14 1 Classroom Classroom 07/01/2023 04/17/2026 19395
    AL CE 14 14 Classroom Classroom 10/01/2022 09/30/2024 C02584
    AR CE 15 14 1 Classroom Classroom 05/07/2024 03/07/2026 AI006
    CA CE 14 14 Classroom Classroom 02/24/2022 02/23/2026 14CP754601097
    CO CE 14 14 Classroom Classroom 02/20/2024 12/06/2026 2530
    CO CE 15 14 1 Classroom Classroom 02/20/2024 12/06/2026 2530
    CT CE 14 14 Classroom Classroom 03/10/2022 03/10/2025 AAL.000898
    DC CE 15 14 1 Classroom Classroom 02/29/2024 02/28/2026 3614
    DE CE 15 14 1 Classroom Classroom 11/01/2023 10/31/2025 REA-AC-092023-073895
    GA CE 14 14 Classroom Classroom 04/01/2014 64597
    GA CE 15 14 1 Classroom Classroom 04/02/2014 64598
    HI CE 15 14 1 Classroom Classroom 01/01/2024 12/31/2024 23-466
    HI CE 14 14 Classroom Classroom 01/01/2024 12/31/2024 23-466
    IA CE 15 14 1 Classroom Classroom 04/17/2020 07/11/2025 A518-1023
    IA CE 14 14 Classroom Classroom 04/17/2020 07/11/2025 A518-1022
    ID CE 15 14 1 Classroom Classroom 04/01/2024 07/10/2026
    IL CE 14 14 Classroom Classroom 01/01/2023 12/31/2024 575.001889
    IN CE 15 14 1 Classroom Classroom 04/10/2015
    KS CE 14 14 Classroom Classroom 01/01/2024 12/31/2024 168.C24.R
    KY CE 14 14 Classroom Classroom 07/01/2024 05/30/2025
    LA CE 14 14 Classroom Classroom 09/09/2019
    MA CE 14 14 Classroom Classroom 03/12/2024 03/11/2026 00120135
    MD CE 15 14 1 Classroom Classroom
    ME CE 15 14 1 Classroom Classroom 09/26/2023 09/25/2024
    MI CE 14 14 Classroom Classroom 01/28/2023 01/28/2026 1710
    MN CE 15 14 1 Classroom Classroom 08/01/2022 07/31/2024 1016396
    MN CE 14 14 Classroom Classroom 08/01/2022 07/31/2024 1016395
    MO CE 14 14 Classroom Classroom 07/01/2024 06/30/2026
    MS CE 15 14 1 Classroom Classroom 05/27/2024 05/26/2026 MAB #49680
    MT CE 14 14 Classroom Classroom 06/19/2023 04/28/2026 REA-CEC-REC-16716
    MT CE 14 14 1 Classroom Classroom 06/19/2023 04/28/2026 REA-CEC-REC-16716
    NC CE 14 14 Classroom Classroom 01/01/2024 12/31/2024 3015
    ND CE 15 14 1 Classroom Classroom 03/02/2022 03/02/2026 CE-222022
    NE CE 14 14 Classroom Classroom 09/19/2019 09/24/2024 2191495.02
    NH CE 15 14 1 Classroom Classroom 02/27/2024 11/22/2025
    NJ CE 15 14 1 Classroom Classroom 03/25/2014 2014-3114
    NM CE 15 14 1 Classroom Classroom 07/19/2023 05/26/2026 4269
    NM CE 14 14 Classroom Classroom 07/19/2023 05/26/2026 4269
    NV CE 14 14 Classroom Classroom 05/01/2021 08/31/2024 CE.0009736-A
    NY CE 15 14 1 Classroom Classroom 01/01/2024 12/31/2024 A4220-14
    OH CE 15 14 1 Classroom Classroom 01/01/2024 12/31/2024 084404609A 23
    OK CE 15 14 1 Classroom Classroom 08/08/2023 07/10/2026 860
    OK CE 14 14 Classroom Classroom 08/08/2023 07/10/2026 860
    OR CE 14 14 Classroom Classroom 05/01/2023 03/17/2026 APIN-C-0323-8976
    PA CE 15 14 1 Classroom Classroom 02/23/2023 02/23/2026 000002
    PR CE 15 14 1 Classroom Classroom
    RI CE 15 15 Classroom Classroom 08/04/2023 08/02/2024 REA.0002040-CE
    SC CE 15 14 1 Classroom Classroom 09/01/2022 08/31/2024 CE1443
    SD CE 15 14 1 Classroom Classroom 01/12/2024 11/14/2026 SD 1022 CE
    TN CE 15 14 1 Classroom Classroom 05/01/2024 04/30/2026 2151
    TX CE 15 14 1 Classroom Classroom 09/01/2022 07/31/2025 TX Provider #:10 Course #: 47114
    UT CE 14 14 Classroom Classroom 02/01/2021 07/31/2025 AC230707
    VT CE 14 14 Classroom Classroom 12/10/2020 12/10/2024
    WA CE 15 14 1 Classroom Classroom 02/15/2023 03/14/2026 A3207
    WI CE 15 14 1 Classroom Classroom 05/12/2014 3951
    WV CE 15 14 1 Classroom Classroom 04/22/2023 04/26/2026
    WY CE 15 14 1 Classroom Classroom 04/02/2023 04/01/2026
    Course Objectives
    • Understand and validate the assumptions underlying linear regression analysis.
    • Develop credible estimates of outcome variable values and associated confidence intervals.
    • Interpret Excel’s linear regression outputs.
    • Transform nonlinear relations into linear equivalents for analysis.
    • Develop forecasts from time-series data.
    Course Details

    Program Overview:
    Table of Contents and Overview
    Course Schedule

    Assignments:
    Yes. After you register for this class, please go to your Education and Events page for

    details on what you must complete BEFORE class begins.
     
    To access your Education and Events page, log on to the Appraisal Institute website at https://ai.appraisalinstitute.org/eweb (click on the three horizontal lines to the left of the AI logo and select “My
    AI Account” from the drop-down menu).

    Equipment:

    • A laptop computer is required.
    • Microsoft Excel 365 must be loaded and operational. If you do not have Excel, you may download a free trial at http://office.microsoft.com/en-us/try/. Please note that this links to the latest version of Excel. There may be minor differences between versions. 
    • Solver Add-In and Analysis Tool Pak must be installed prior to class. Note. These add-ins may not work with the online version of Excel. As a result, it is highly recommended that you download a computer-based version of Excel.
    • Note to Apple Mac Users: The course will be taught in Windows using Excel 365. You will need the latest version of Excel in order to perform some of the exercises. Also, Microsoft does not support the Data Analysis Tool Pack in Mac Office Excel 2011. However, they do suggest free third-party add-ins with similar functionality. For more information, click here.
    • A regular-function or financial calculator is required for the exam.

    Additional Information:

    Course Materials Include:

    • Course Handbook (308 pp.)
    • Pre-Class Downloads (232 KB)
    • Post-Class Solutions Downloads (369 KB)
    • Pre-Class Memo (1 p.)
    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 to download these files prior to coming to class.

    You will be asked to clear the calculator’s memory before and after the examination. Only one calculator is permitted in the testing room. Examinees taking most AI exams may bring their own calculator to use during the exam. Laptops, cellular phones, tablets, iPads, wearable technology (smart watch, Apple Watch, Google Glass, etc.), and other devices that can store data or connect to the Internet are NOT permitted during the exam. In addition, all watches, wallets, bags, and purses must be removed and stored out of reach prior to taking the exam.

    Requirements:
    None specified

    Prerequisites
    Course Materials & Recommended Books
    Pricing Options
    Rate Full Price AI Price
    Standard
    Today thru 08/09/2024
    $580.00 $480.00
    Late
    After 08/10/2024
    $655.00 $555.00
    Have Exam Questions?
    Event Information

    * * * * * Please review the entire section below. * * * * *

    It contains IMPORTANT SPECIFIC details about the August offering that you are registering for.



    Location

    Treat Towers
    1255 Treat Boulevard
    First Floor Conference Room
    Walnut Creek, CA  94597

     


    BART and Onsite Parking 

    • Treat Towers is a quick walk from the Pleasant Hill BART Station
    • Onsite parking is available
      - enter from Buskirk Avenue
      - $9 daily rate (subject to change)
      - no in / out privileges

    • Street parking may also be available; be watchful of any parking restrictions


    Program Hours and Materials
    Onsite check-in will begin at 8:00am on Wednesday, August 21.  "Live / in-person" Instruction will run from 8:30am – 5:00pm (Pacific Time) Wednesday, August 21 and from 8:30am – 4:00pm on Thursday, August 22.  The one-hour exam will be administered at 4:00pm on Thursday, August 22.  Students will be on their own for lunch; numerous eateries are available within easy walking distance of and onsite at Treat Towers.


    Tips on Downloading the Course Handbook
    Upon registering, students will have access to the downloadable course materials.  Students are strongly encouraged to have pre-printed and/or pre-downloaded the materials.  Do not wait until the day of the course to download as the files are quite large.  

    • Log in to My Account (https://www.appraisalinstitute.org/)
    • Select Education & Events (right sidebar)
    • See list of all offerings, scroll to Application & Interpretation of Simple Linear Regression and select View
    • You will now see a box that contains downloadable program materials
    • Click link(s) to download:

    • Course Handbook
    • Solutions Booklet (if applicable)
    • Pre-Class Downloads (if applicable)


    Ordered Printed Materials or Need Assistance in Downloading? If you (1) have not received your pre-printed materials (must be selected at the time of online registration; extra fees apply for printing and shipping) within 4 weeks of the offering, (2) have any questions or difficulty in accessing / downloading the required electronic course materials 
    contact AI's Education Delivery Department directly at 312-335-4207 or education@appraisalinstitute.org.  


    Required Text

    • None other than the items listed above.

    Required Equipment

    • A financial calculator is required. The accepted model used in the program is the HP-12C. AI education programs that require a financial calculator are developed with HP-12C keystrokes; using this model is highly recommended.
    • You must be familiar with calculator operation when the program begins. Do not enroll expecting to be taught how to use a financial calculator.
    • For more information and a free review, click here.
    • For additional help with the HP-12C calculator, take our online seminar Using Your HP-12C Financial Calculator
    • HP-12C calculator User's Manual.
    • Access in class to Excel
    • Students will need a No. 2 pencil for the exam
    • Students are encouraged to bring extension cords / powerstrips (especially if viewing materials on a laptop)

    Education Credit Hours and Attendance Verifications
    Those who check in late, leave early or are not in attendance during non-scheduled breaks may jeopardize receipt of credit.

    Appraisal Institute: Full attendance (100%) and successful completion of the exam enables Designated Members, Candidates for Designation and Practicing Affiliates to receive 200 AI CEC points; 150 points for full attendance only (no exam). Those seeking credit toward the Analytics for Valuation Professional Development Program must successfully pass the exam and have full (100%) attendance.

    BREA ContinuingApplication & Interpretation of Simple Linear Regression has been approved by the BREA (#14CP754601097) for 14-hours of BREA CEC. Full (100%) attendance required but BREA CEC (continuing education credit) does not require successful completion of the exam.

    BREA Basic/QualifyingApplication & Interpretation of Simple Linear Regression is not approved for BREA qualifying education (QE) credit.

     

    If you are seeking credit for this offering from a state outside of California, check with your state licensing board(s) to make sure an out-of-state offering will be accepted before registering.  It is best to speak directly with a representative from your board rather than relying on information posted to the web.  Note: Some states outside of California may have additional reporting requirements that the chapter is not able to comply with.


    Attendance Verification Process Effective 10/01/19
    Verified attendance certificates will be available for downloading within 15 working days of the offering

    • Logging into My Account www.appraisalinstitute.org
    • Select EDUCATION
    • Click on the specific offering that you are seeking the certificate for; it will show REGISTERED
    • Scroll to the very bottom of the screen to (1) COMPLETE EVALUATION FORM and (2) RETRIEVE CERTIFICATE

    Note:  Effective 10/01/19 students will be able to access their attendance certificates 24/7 through the Appraisal Institute's netFORUM association management program.  The Northern California Chapter does not have direct access to certificates for programs held after this time. Any issues in retrieving certificates should be brought directly to the attention of the Appraisal Institute's Education Delivery Department at 312/335-4207 or education@appraisalinstitute.org.  

    Confirmation Emails
    All confirmed registrants will receive a payment receipt plus a separate confirmation by email.  Be sure that you can accept emails from each of the following email addresses: 

    Any last-minute updates to this offering will most likely be sent from lisa-norcal-ai.org@shared1.ccsend.com (registrants should not send emails to this address).  Be sure that you can accept emails from these email addresses, or these important emails may default to your spam / junk files.


    Payment Receipt
    All confirmed registrants will receive an email confirmation that will also serve as a payment receipt on the day of registration.  

    • noreply@appraisalinstitute.org (confirmation details) 
    • aiservice@appraisalinstitute.org (payment receipt)


    Registrants can also log into their MyAccount portal, select TRANSACTIONS to download a duplicate payment receipt.


    Note: 
     If you do not receive emails on a regular basis from the Northern California Chapter ( lisa-norcal-ai.org@shared1.ccsend.com ) be sure to visit our homepage and sign-up to receive our emails.  Registrants will not want important details like location changes or material downloads defaulting to spam / junk or be classified as undeliverable.  

    • Those who work for financial institutions or government agencies my need to enlist the assistance of their IT Department to insure timely email delivery.


    Accommodations
    The following hotels are within proximity of Treat Towers (Walnut Creek)

    • Embassy Suites (at Pleasant Hill BART) - 925/934-2500 - 1345 Treat Boulevard, Walnut Creek, CA
    • Holiday Inn Express - 925/932-3332 - 2730 N Main St, Walnut Creek, CA
    • Hyatt House - 925/934-3343 - 2611 Contra Costa Blvd, Pleasant Hill, CA

    Click here - for additional lodging options in the Pleasant Hill / Walnut Creek Area

    Some students have also explored options for vrbo and Airbnb.


    Questions? Contact Us
    Northern California Chapter
    925/932-7753 l 916/972-9700
    via email


    CEC Approvals
    Approval outside of California or acceptance of out-of-state providers cannot be guaranteed.  If you are seeking credit for this offering from a state outside of California, check directly with your state licensing board(s) - before registering - to make sure that they will accept credit from an out-of-state provider.  Some states may have special pre-approval or reporting requirements that the chapter is not able to comply with.  Use caution in relying on website approvals as they may not be up-to-date.


    COVID Protocols
    All registrants attending a live-classroom offering do so at their own risk.  Each registrant is individually responsible for being aware of and following state, city and county COVID protocols and guidelines.


    Disclaimers
    By registering for this event, you agree that

    • your attendance may be recorded, photographed, and/or monitored at any time
    • will accept emails from the Northern California Chapter
    • registrants will add this address to their accepted list of emails - lisa-norcal-ai.org@shared1.ccsend.com
    • your contact information may be published in a networking roster
    • we may switch or change locations or cancel this offering based on program logistics or out of necessity
    • if you have a disability and may require special accommodation, please notify us in writing at least two weeks in advance to arrange for reasonable accommodation
    • all registrants attending a live-classroom offering do so at their own risk.  Each registrant is individually responsible for being aware of and following COVID protocols and guidelines


    Lost or Damaged Items
    The Appraisal Institute nor the chapter presenting this program is not liable for lost or damaged items. This includes but is not limited to calculators, laptops, cell phones, etc.


    Cancellations
    Written cancellations received by Wednesday, August 7 subject to a $50 cancellation fee.  Cancellations received after that time but prior to noon on Wednesday, August 14, are subject to a $100 cancellation fee.  No refunds for cancellations received after August 14 or for program "no shows".   Cancellations can be emailed to lisa@norcal-ai.org.

    We reserve the right to substitute instructors, or to cancel or modify this program (adjust hours or location) if sufficient registrations are not received by Friday, August 2 or due to other circumstances beyond our control. In the event of cancellation, tuition fees will be refunded. All other costs incurred are the registrant’s responsibility. Those requiring out-of-town travel arrangements should exercise caution in booking non-refundable tickets/reservations.


    Questions? Contact Us
    Northern California Chapter
    925/932-7753 l 916/972-9700
    via email