Quantitative Principles in Compensation Management | C3E – Ireland (two days)
Qualification Information

Master HR statistics with Excel

WorldatWork logo

This course focuses on general quantitative concepts, basic statistical tools, the mathematics of compensation design and administration, mathematical modelling and regression analysis. This course will demonstrate how to apply these concepts utilising 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, analyse 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 modelling and regression analysis.

This course requires you bring a fully-charged Windows PC laptop (not Mac), loaded with Microsoft Excel 2010 or later. We recommend that you bring a mouse to the course to help with extensive on-screen navigation. Participants will receive instructions to download the supplemental course material Excel files prior to attending the session.

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, organising, grouping and displaying data
  • Populations and samples
  • Frequency distributions
    • Organise, group and display data
Statistics – Lying with statistics, graphs and displays
  • Recognising 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 reward management and who have responsibility for designing compensation programmes.

All demonstrations will be undertaken in Excel 2010.

UK and Ireland TEACHING FACULTY

Our panel of instructors has been recruited from the world's most respected and qualified practitioners, consultants and educators. These highly-experienced experts have dedicated their careers to the total reward profession. They will provide you with the critical advantage of showing you how to apply the facts and theory to real-life business situations that affect your organisation's bottom line.

The members of the UK and Ireland teaching faculty providing our reward management classes are as follows:

Dianne Auld, GRP, CCP, CSCP
Dianne Auld, GRP, CCP, CSCP
Senior Consultant, Auld Compensation Consulting

Dianne Auld, GRP, CCP, CSCP, is the founding member of Auld Compensation Consulting, operating out of Cape Town, South Africa. Her consulting work around the world covers all areas of total rewards, including reward strategy, base pay management, job evaluation, pay structuring, incentive design and sales compensation. She has developed and taught Excel and rewards courses in Africa, the Middle East, Asia, Europe, and the United States.

As a WorldatWork faculty member, Dianne teaches the GRP reward qualification courses in Southern Africa. She is the author of Dianne Auld’s Excel Tips, 3rd edition. Dianne has developed and recorded several e-learning products for WorldatWork, including Excel Skills, Advanced Excel Skills and Pay Structures. She is an honorary life member of the South African Reward Association (SARA) and an accredited Master Reward Specialist.

Dr Duncan Brown
Dr Duncan Brown
Independent adviser, Visiting Professor University of Greenwich and Principal Associate IES

Duncan has worked at major HR consultancies and research institutes including Aon and Willis Towers Watson. He was Deputy CEO at the Chartered Institute of personnel and Development for five years.

Duncan’s recent clients have included Shell, Royal Holloway University, NHS Employers and Unicef UK. He has advised the UK government on a range of issues including pay determination for doctors and dentists and the judiciary; and the development of the gender pay gap reporting regulations in 2017.

He has just authored the CIPD’s new guide on ethnicity pay reporting and wrote their recent report on employment status. He is the joint author with Michael Armstrong of the UK’s best-selling Handbook of Reward Management.

Duncan has an MA from Cambridge University, an MBA from the London Business School, his PhD was in reward strategy and he is a Chartered Companion of the CIPD. He is also Board trustee at the High Pay Centre, the Involvement and Participation Association and at the Pensions Policy Institute.

Pat Gurren
Pat Gurren
Founder of Gurren Compensation Ltd

In 2004, Pat founded Gurren Compensation, a specialist reward consulting practice based in Ireland. Prior to starting his own consulting business, he held a number of senior HR and reward management positions for leading multinational companies, including Intel, Motorola and Digital. During his ten-year career with Intel, Pat worked in Ireland, Asia, Europe and the USA holding positions as C&B Manager for Ireland, C&B Director for the Asia region, C&B Director for the Europe region and Global Head of C&B Operations.

Since founding Gurren Compensation, Pat has worked with numerous clients across all industry sectors/geographies on the design and implementation of reward strategies/programmes that effectively align with business priorities and organisational culture.

Pat is a certified Global Remuneration Professional (GRP), a Certified Compensation Professional (CCP), and a Fellow of the CIPD (FCIPD). He has been a teaching faculty member at WorldatWork since 2008 and teaches all 10 classes on the GRP certification course.

In his consulting practice, he has a wide range of performance improvement and reward management interests and is viewed as an expert practitioner in the design of pragmatic reward strategies/programmes that improve organisational performance.

TERMS AND CONDITIONS FOR E-REWARD.CO.UK COURSES

THE FOLLOWING TERMS AND CONDITIONS APPLY TO THE DELIVERY OF EDUCATION COURSES BY E-REWARD.CO.UK LTD (INCLUDING MASTERING REWARD COURSES; WORLDATWORK GLOBAL REMUNERATION PROFESSIONAL CERTIFICATION [GRP] COURSES AND EXAMINATIONS [PROGRAM]; IN-HOUSE AND CUSTOMISED TRAINING COURSES).

These terms and conditions apply between the person, firm, company or other entity specified on your booking form and E-reward.co.uk Ltd (company number: 4281768). Registered in England and Wales. Registered office 33 Denby Lane, Heaton Chapel, Stockport, Cheshire SK4 2RA, United Kingdom for delegate registrations for the course (including Mastering Reward courses, GRP courses with exam and in-house training courses) specified on your booking form (‘Course’).

Please read these terms and conditions carefully as they contain important information.

By submitting your registration to attend the Course you agree to be bound by these terms to the exclusion of all other terms. If you do not agree to be bound by these terms E-reward.co.uk Ltd will be unable to accept your registration.

Delegate cancellations

Delegates who advise E-reward.co.uk Ltd of their cancellation in writing via email (to paul@e-reward.co.uk) 30 calendar days before the start of the Course will have their fees refunded – less an administration charge of 20% of the Course fees.

No refund will be made for cancellations received less than 30 calendar days before the start of the Course.

Failure to attend the Course will be subject to the same terms.

  • GRP courses featuring pre-recorded online videos – If your GRP course includes access to pre-recorded video training, once this access has been provided to you (at least four weeks prior to the accompanying virtual classroom day), no refund of delegate fees will be payable.
  • In-house training – You will not have any right to cancel a Contract for the booking of any customised/in-house training courses. For the avoidance of doubt, no refund will be payable

Delegate transfers

Transfers may be made to any other Course in the UK organised by E-reward.co.uk Ltd subject to space availability. All transfer requests must be made in writing via email (to paul@e-reward.co.uk) 30 calendar days or more before the start of the Course.

There will be no fee charged for such transfers. One free transfer can be made for each course booking after which there will be a £100 administration charge for each further request.

Please note: We are unable to accept any transfer requests received less than 30 calendar days before the start of the course and no refunds will be made.

We are unable to accept any transfer requests once you have received access to GRP pre-recorded learning videos.

Substitutions with employees from your organisation are welcome at any time at no extra charge. You must email any substitutions (to paul@e-reward.co.uk) prior to the date of the Course.

Please note: We are unable to accept any ‘substitutions’ once you have received access to GRP pre-recorded learning videos.

Payment

You will pay E-reward.co.uk Ltd any fees specified in your booking form for the Course. Payment to E-reward.co.uk Ltd in GBP British Pounds is by BACS, wire transfer, cheque or credit card. It is a condition of booking that payment must be received by E-reward.co.uk Ltd before the start of the Course or no later than 30 days from the date of invoice, whichever is sooner.

If payment of your fees in full is not received before the Course, E-reward.co.uk Ltd may (at its sole discretion) either require such payment as a condition of your entry to the Course or refuse you entry to the Course.

Prices for each Course, where applicable, are correct at the time of publication. We reserve the right to change the prices at any time but changes will not affect registrations which have already been confirmed by E-reward.co.uk Ltd.

Each ticket covers attendance for one person only for the duration of the Course, and includes coffees, teas and light snacks during the lunch hour, as well as course materials.

All bookings are subject to value added tax (VAT) at 20%. You shall, on receipt of a VAT invoice from E-reward.co.uk Ltd, pay to E-reward.co.uk Ltd such additional amounts in respect of VAT as are chargeable on the supply of the Course.

Late payments

We understand and will exercise our statutory right to interest and compensation for debt recovery costs under the late payment legislation if we are not paid according to agreed credit terms. Under the Late Payment of Commercial Debts [Interest] Act 1998 – as amended and supplemented by the Late Payment of Commercial Debts Regulations 2002 (to incorporate the features of European Directive 2000/35/EC) – we are entitled to charge:

  • Debt recovery costs – £40 on debt up to £999.99; £70 on debt between £1,000 and £9,999.99.
  • Statutory interest – 8% above the Bank of England reference rate (fixed for the six-month period within which date the invoices became overdue).

Joining instructions

Final Course details will be emailed to delegates at least three weeks before the Course.

Course documentation

You will receive your course materials by email ahead of the Course.

Hotel accommodation

Delegates are responsible for their own accommodation.

Course cancellations and amendments

The Course programme is correct at the time of going to press.

E-reward.co.uk Ltd reserves the right to change the format, tutors, venue location and programme or any other aspect of the Course at any time and for any reason, whether or not due to a Force Majeure event, in each case without liability/refund.

‘Force Majeure Course’ means any event arising that is beyond the reasonable control of E-reward.co.uk Ltd including (without limitation) speaker or participant cancellation or withdrawal, supplier or contractor failure, venue damage or cancellation, health scares, industrial dispute, governmental regulations or action, military action, fire, flood, disaster, civil riot, acts of terrorism or war.

E-reward.co.uk Ltd reserves the right to change the date or cancel a Course at any time and for any reason without notice. Where circumstances force E-reward.co.uk to cancel a Course, E-reward.co.uk Ltd shall offer you the option of attending any rearranged Course that E-reward.co.uk Ltd chooses to organise.

If you do not wish to accept this offer, then you will (as your sole remedy) be entitled, at your discretion, to receive either a credit note or a refund in respect of your fees received by E-reward.co.uk Ltd for that particular Course.

However, where the Course is postponed for reasons due to a Force Majeure event, any of your fees received by E-reward.co.uk Ltd shall be applied to any rearranged or rescheduled Course and all these Terms and Conditions shall apply to any such transferred booking.

To the fullest extent permitted by the applicable law, E-reward.co.uk Ltd shall not be liable to you for any loss, delay, damage or other liability incurred resulting from or arising in connection with the cancellation or date change of the Course howsoever arising or any venue change.

For the avoidance of doubt, you acknowledge and agree that should the Course date be changed or cancelled, E-reward.co.uk Ltd is not liable for any travel or accommodation costs you may have incurred.

How we use your registration information

E-reward.co.uk Limited is a registered data controller under number Z7317541.

Your Course registration information will be added to our marketing database but will not be given to third parties without your prior consent.

E-reward.co.uk Ltd uses email addresses for its own purposes of keeping customers informed about Courses and providing product, service and information announcements.

If you supply us with your postal address online, you may receive periodic mailings from E-reward.co.uk Ltd with information on new products and services and upcoming Courses.

If you do not wish to receive information about products and services, please let us know by email (to paul@e-reward.co.uk).

Disclaimers

To the fullest extent permitted by the applicable law, E-reward.co.uk Ltd excludes:

  • all liability for loss, injury or damage to persons or property at the Course;
  • all indemnities, warranties, representations, terms and conditions (whether express or implied); and
  • any actual or alleged indirect loss or consequential loss howsoever arising suffered by you or any loss of profits, anticipated profits, savings, loss of business revenue, loss of business, loss of opportunity, loss of goodwill, or any other type of economic loss (whether direct or indirect).

If E-reward.co.uk Ltd is liable to you for any reason, its total liability to you in relation to the Courses (whether under these terms or conditions or otherwise) is limited to the amount of your fees received by E-reward.co.uk Ltd.

Views expressed by the Course instructors are their own. All advice provided at this course is for general guidance only. Any course delegates relying on information or advice given in the course of such training do so at their own risk.

E-reward.co.uk reserves the right to amend these terms and conditions from time to time. However, you will be subject to the terms and conditions in force at the time you submit your registration.

Further information

If you have any questions, please email us at paul@e-reward.co.uk