Regression Analysis Made Easy with Excel

Course

Be confident your pay structures are fair and competitive by leveraging the power of regression analysis in your compensation work. In just two hours, this course will take the mystery and angst out of regression analysis with a clear, step-by-step approach. The result: You will be more productive and better able to quickly analyze data and produce valuable insights that lead to better business decisions.

At the end of the class, the Excel spreadsheets used by the instructor are yours to keep, along with detailed directions showing how to replicate the functions you’ve learned.

What You Will Learn:

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.
Using regressed data to create an effective scatter chart that combines traditional rectangular pay scales and market and internal median pay lines.

Additional Information

This course is ideal for compensation professionals who regularly use Excel to analyze large quantities of data – and who want to work faster and more efficiently. The course requires an intermediate to advanced knowledge of Excel. Participants also should have access to a computer with Excel 2013 or newer.

Based in India? Contact india@worldatwork.org for India-special course pricing.

Related Courses

This learning experience is part of WorldatWork’s suite of Excel mastery courses, which include:

Policies

View our Return/Cancellation policies and more here.

Become a Member

Members can register for this course at a special rate and gain exclusive access to research, publications and more!

Join Now

Course Credits

WorldatWork Recertification

By successfully completing this course you will earn 2 WorldatWork recertification credits.

Learning Options

Exercises are included throughout each section of the course for hands-on practice.

Member Price

Non-Member

*Find a Global Course

Member Price

Non-Member

*Find a Global Course

Member Price

Non-Member

Please note: 120-day access to e-course material starts immediately on the day of purchase. Purchase includes course materials.

Member Price

Non-Member

Member Price

Non-Member

Course Schedules

{{getDate(product.cfs.Product_Start_Date_C, product.cfs.Product_End_Date_C)}}

{{getDelivery(product.cfs)}} -

                                                @
                                                {{getSponsor(product.cfs)}}
                                            

Unavailable To be placed on the waiting list or inquire about other sessions or products, please contact our Customer Experience Team.

Sold Out

Add to Cart

There are no classes scheduled at this time.

Please consider a different learning method or contact our Customer Experience Team to learn about other classes and schedules. Click here to check our global course schedule for availability. Click here to check our global course schedule for availability.

Phone
877-951-9191 (United States and Canada)
+1 480-951-9191 (other countries)

Monday-Friday: 8:00 a.m. - 7:00 p.m. EST

Email
Email our Customer Experience Team: customerexperience@worldatwork.org