WorldatWork, the Total Rewards Association
 
 
Password:  Change  |  Forgot  |  Help   
Email   Print
C3E: Quantitative Principles in Compensation Management
New!
Quantitative Principles in Compensation Management

Master HR Statistics with Excel

This course focuses on general quantitative concepts, basic statistical tools, the mathematics of compensation design and administration, mathematical modeling and regression analysis.  This course will demonstrate how to apply these concepts utilizing Excel so all participants must have access to Excel while completing the course.  Participants will learn to consider data from numerous sources with an emphasis on problem solving and decision making.

  • Learn basic quantitative concepts and the four levels of measurement
  • Learn how to define and compare percents, market index and compa-ratios
  • Study the time value of money  - including compound interest and the compound salary growth rate
  • Learn how to collect, analyze and accurately display statistical data
  • Learn how to determine central tendency and measures of central location
  • Discuss  measures of variability
  • Explore shapes of distributions
  • Gain an understanding of modeling and regression analysis
What You Will Learn  |  More Info  |  Who Should Register   |  How to Register  |  New! What is Blended Learning?


Learning Options

 

Course Schedules
Sep 11 - Nov 10
Online
Course & Exam
Course Only
 

 

What You Will Learn  

Statistics – Data, Information and Levels of Measurement

  • Why compensation professionals collect and use data
  • Five key questions to ask about the variable of interest
  • Levels of measurement

Percents and Related Issues

  • Percents
  • Individual compa-ratio
  • Department compa-ratio
  • Market index
  • Percent difference
  • Developing salary ranges
  • Percents in compensation management

Time Value of Money

  • Time value of money
  • Present and future value
  • Compound interest and compound salary growth rate
  • Constant midpoint progression
  • Annuity payments

Statistics – Collecting, Organizing, Grouping and Displaying Data

  • Populations and samples
  • Frequency distributions
    • Organize, group and display data

Statistics – Lying with Statistics, Graphs and Displays

  • Recognizing distorted data
  • Avoiding mistakes that distort data

Statistics – Measures of Central Tendency and/or Location

  • Measures of central tendency
    • Mode
    • Median
    • Mean
  • Measures of location
  • Percentile bars

Measures of Variability

  • Measures of variability
    • Range
    • Interquartile range
    • Standard deviation
  • Z-scores
    • 2-sigma and 3-sigma rules

Statistics – Shapes of Distributions

  • Interpreting distributions
  • Normal distributions

Regression Analysis

  • Regression models in a compensation environment
  • Developing a regression model
  • Cautions in the interpretation of correlations
  • Multiple regression
Who Should Register  

This course is intended for those individuals who are pursuing CCP or GRP.  It is also applicable for practitioners who are seeking a basic treatment for applying statistics in compensation management and who have responsibility for designing compensation programs.

  • Participants will have to have access to Excel while taking this course.  All demonstrations will be done in Excel 2007.
 
How to Register  
 
More Information  
 Course Credits

CCP: Required
GRP: Required
Recertification: 2 course, .5 Exam
CEUs: 1.5 Course, .3 Exam

 Terms and Conditions

Please note: If you are purchasing an exam option, you must schedule and complete the computer-based exam within 120 days from the first day of a live instructor-led class or from date of purchase for all self-paced learning packages. Your eligibility expires after 120 days; however, 30-day exam extensions are available for a $150 USD fee when purchased before the original access expires. It is recommended that you complete your exam in a timely manner as exams may be updated without notification. Instructions for scheduling your computer-based exam will be provided at purchase. Learn more at www.worldatwork.org/cbt. Self-study materials and all e-learning product purchases are nonreturnable.

WorldatWork classroom locations offer e-course materials technology to participants. Your certification course materials (and BAII calculator, if applicable) will be available for pick up on site the day of the course. For two-day courses, you may access the e-course materials PDF two weeks prior to the course start date or upon registration if you register within two weeks of the course.

E-learning course purchasers now have the option of print or e-course materials. Those who choose the e-course materials option will receive the materials electronically for the length of your e-learning program. Those who choose the print version of the course materials will receive it  5-7 days after date of purchase. 30-day extensions of e-learning access are available for a fee if purchased before original access expires.

Blended Learning e-course materials can be found within the product and will be available for the length of the course.

Please visit www.worldatwork.org/seminars to download course material amendments, view class rosters and to find out what to bring to your class.

*Join now and receive the best value. This includes both a one-year WorldatWork Premier membership and course registration. Add the course to your cart and then click "Join Now" before proceeding to check out.

 
What is Blended Learning?  

Frequently Asked Questions  |  Course Duration Matrix  |  Sample Class Syllabus

Blended  Learning — Take An In-depth Tour

Get the best of both worlds and more! Combining learning and study preferences, Blended Learning leverages independent e-learning and collaborative traditional classroom experiences with access to additional resources.

  • 24/7 access provides greater convenience and flexibility
  • Class discussion board allows access to peers and subject matter expert
  • Study when time allows
  • Integration of group and independent study
  • No “out of office” time needed
  • No travel expense.

Components of Blended Learning

All Blended Learning classes include a class discussion board, other components available within Blended Learning will vary in order to deliver the best learning experience possible. Classes may include access to components such as:

  • Live online session(s) with facilitator and peers
  • Audio files
  • Video files
  • Articles and/or white papers
  • Tools and templates
  • Online quizzes

 

 

 

 

 

 

 
Certification Exam: C3E
Certification Paths
Certified Compensation Professional
Global Remuneration Professional
This is a required exam to obtain a CCP and GRP.
 
Share

 

 

 

 

 

CONNECT WITH US 

Copyright  |  Privacy Policy  |  Site Map  |  Advertise with Us  |  Community Terms and Conditions

WorldatWork