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  |  Test Your Knowledge  |  More Info  |  Who Should Register   |  How to Register  |  What is Blended Learning?


Learning Options


 

Course Schedules
Oct 14 - Dec 13
C3E - Quantitative Principles in Compensation Management - Blended Learning
Your live web sessions will be held on 11/6/2014 and 12/4/2014 at 10:00am - 12:00 pm PST
Self-Paced
Course & Exam
Course Only
May 26 - Jul 24
   2015  
C3E - Quantitative Principles in Compensation Management - Blended Learning
Your live web sessions will be held on 6/18/2015 and 7/16/2015 at 10:00am - 12:00 pm PST
Self-Paced
Course & Exam
Course Only
Aug 25 - Oct 23
   2015  
C3E - Quantitative Principles in Compensation Management - Blended Learning
Your live web sessions will be held on 9/17/2015 and 10/15/2015 at 10:00am - 12:00 pm PST
Self-Paced
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

WorldatWork Society of Certificed Professionals, an affiliate of WorldatWork, administers the exams required for attaining the prestigious Certified Compensation Professional® (CCP®), Global Remuneration Professional® (GRP), Advanced Compensation Professional (ACCP)™, Master Certified Compensation Professional (MCCP)™, Certified Executive Compensation Professional (CECP)®, Certified Sales Compensaiton Professional (CSCP)®, Certified Benefits Professional® (CBP) and Work-Life Certified Professional® (WLCP) designations. The Society is a separate not-for-profit legal entitity with its own Board of Directors appointed by the Worldatwork Board of Directors and was formed to provide a focus on certification. Certification exams are administered and designations are issued by the Society; all educational courses/self study are administered by WorldatWork.

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 $165 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.

Access to the e-learning product lasts for the specified amount of time (30, 60 or 120 days).  Your e-learning product begins the day you purchase it, not the day you start it. Be sure to download any class materials prior to product expiration.

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/prep 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?  

Components of Blended Learning  |  How Much Study Time Planning  |  Course Duration Matrix  |  Frequently Asked Questions
Sample Facilitator-Led Class Syllabus  |  Sample Self-Paced Class Syllabus  |  Take An In-depth Tour  |  How to Adjust My Screen Size

Blended learning is the perfect hybrid solution for those individuals or teams who want interaction with the facilitator and peers while having the convenience and control of accessing the content at the time and place which work best for the individual. Depending on the course, the facilitator and peer interaction may be in person or through online web meetings and tools.

  • A learner-centric approach: moves beyond the one-size-fits-all classroom in favor of an on-demand, personalized learning environment
  • Greater skills practice and coaching: activities can focus on interaction, skill building, and rich feedback
  • Social and peer-based learning: keeps the emphasis on practical solutions to workplace challenges and makes the learning more engaging
  • Self-paced opportunities: allows access to content anytime, anywhere at the learner’s fingertips

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

How Much Study Time Should I Plan For?

A: Blended Learning classes are either led by a facilitator or self-paced. The course duration varies depending on the depth of knowledge shared within the particular class.

Facilitator-Led Blended Learning:  All participants in these courses begin on the same day. You may access course materials any time—day or night—for 60 days after date of purchase.

  • If there is a course book, the entire book is available starting on the first day. The e-learning modules, activities and discussion boards are divided into sections that are released weekly over a 4-8 week period, depending on the amount of content. View Course Matrix

  • You will be able to view the course syllabus and course book (if applicable) starting on the first day. These are valuable tools to help you plan how much time you will want to spend in the course each week. It is recommended that you go through the materials carefully to gauge how long each e-learning module, case studies, activities, etc. will take you each week. (See sample class syllabus for facilitator-led classes).

  • All facilitator-led courses include at least one live event where students and the facilitator come together in an online environment to discuss course material, group exercises, questions and answers, etc. Live web sessions are scheduled from 10 a.m. to 12 p.m. Pacific. Although these sessions are scheduled for two hours, they may or may not run that long. These sessions are recorded and are available for review soon after the event.

  • Discussion boards are included in every course and are monitored by the facilitator. You can access the discussion boards at any time. These are a great way to interact with your facilitator and other course participants. You can post questions, read threads from other participants and the facilitator, and respond to what others have to say.

Self-Paced Blended Learning:  You can access your self-paced course shortly after you register. Some participants may have started before you, and others will start after you, based on their individual registration dates. You may access course materials any time—day or night—for 60 days after date of purchase.

  • All course materials are available starting on the first day. The e-learning modules, and activities divided into sections so that you can easily determine how you want to allocate your time over the duration of your access. View Course Matrix

  • You will be able to view the course syllabus and course book (if applicable) starting on the first day. These are valuable tools to help you plan ahead. It is recommended that you go through the materials carefully to gauge how long to spend in each e-learning module, case study, activity, etc. (See sample class syllabus for self-paced classes).
Discussion boards are included in every course and are monitored by a subject matter expert. You can access the discussion boards at any time. These are a great way to interact with your facilitator and other course participants. You can post questions, read threads from other participants and the facilitator, and respond to what others have to say.

How Do I Adjust My Screen Size?

 

 

 

 

 

 

 

 
Certification Exam: C3E
Exam Requirements
Certified Compensation Professional
Global Remuneration Professional
This is a required exam to obtain a CCP and GRP.
 
 
Share
 
Compensation Institute
Compensation Institute
Providing a comprehensive professional development framework that guides you through every stage of your career. Learn more now!