Regression Analysis Made Easy with Excel

Course

A Skill-Building Course with Compensation and Excel Expert Dianne Auld

Are you nervous about using regression analysis for rewards work? Watch Excel expert Dianne Auld demonstrate how Excel can help you with three different types of regression analysis:

  • Using linear regression to predict executive pay
  • Using multilinear regression to predict executive pay and test for pay discrimination
  • Using exponential regression to create a base pay policy line and pay scales using market and internal pay data

Dianne will explain how to use and interpret the slope, intercept and R-squared (R2) values created by the regression formulas. In addition, you’ll learn how to create a scatter chart, combined with traditional rectangular pay scales, and market and internal median pay lines, using the regressed data. This is a challenging but effective chart, and you must use a specific process to create it.

What You Will Learn:

  • How to conduct linear and exponential regression in Excel using scatter charts and trend lines to predict pay, create a base pay policy line and create pay scales
  • How to conduct multilinear regression using the add-in regression analysis tool in Excel to predict executive pay
  • How to conduct multilinear regression using the add-in regression analysis tool in Excel to test for gender pay discrimination
  • How to use and interpret the slope, intercept and R-squared (R2) values generated by the regression formulas
  • How to create scatter charts with rectangular pay scales, and market and internal median lines overlaid on the chart.

Extra Value!

After the session, you’ll get the Excel spreadsheets used in the demonstration and instructions for replicating the functionality with your own data.

Learning Options

Virtual Classroom

Live online instructor-led delivery of online course materials including real-time interaction with a subject-matter expert and peers — no travel required!

Course

Member: $395 USD

$525 USD

Instructor

Dianne Auld

Reward Consultant
Auld Compensation Consulting

Dianne Auld, CCP, GRP, CSCP, WLCP owns a consulting practice, Auld Compensation Consulting, in Cape Town, South Africa. . She consults to a wide range of organizations globally in all areas of total rewards. She has developed and taught courses in Africa, the Middle East, Asia, Europe, and the United States.

Dianne is also a faculty member at WorldatWork and a reviewer for the WorldatWork Journal. Well respected and known as an expert in the compensation field and Excel, Dianne's skills and expertise are in high demand. In fact, her sessions at the WorldatWork Total Rewards Conference and Exhibition typically fill to capacity. She is the author of the popular Dianne Auld’s Excel Tips, third edition.

Dianne has partnered with WorldatWork to develop several educational products to assist compensation professionals with their day-to-day tasks in Excel, including "Working Smarter and Faster with Excel Formulas, Charts and ASAP Utilities,” “Regression Analysis Made Easy with Excel,” “Hello Excel Power Query, My New BFF”, "Excel Skills for Compensation Professionals," and "Advanced Excel Skills and Dashboards for Compensation Professionals."

Course Credits & Certifications

  • Recertification

    0.25 credits

More Information

Who Should Register

Compensation practitioners or compensation managers with at least intermediate Excel skills.

Requirements

You should have a computer with Microsoft Excel 2010 or later in order to use the modeling tools and formulas demonstrated in class.

How to Register

Policies

Click Here to view our policies on payments, returns, class schedules, registration, cancellation, and more.

Have Questions?

Phone

+1 877 951 9191

USA and Canada

+1 480 951 9191

Other Countries

Online

Email Us