In today’s edition of Sunday Skills I want to cover a little-used source of information for Compensation & Benefits professionals. With over 150 million members, LinkedIn is a great repository of knowledge and goodwill. An obvious source of information and expertise is to browse the Answers section and look if anyone has asked a question…
Understanding R-square value in compensation analysis
For this episode of Sunday Skills, I wanted to explain some statistical concepts used by many compensation consultants when they produce compensation analyses for their clients.Very often, the results are presented “raw”, with a nice graph and a R2 or R-square value (or a series of values) mentioned on the side. But many HR Generalists,…
Create the best rules in Outlook to boost your productivity
Beginning of the year, we all come back full of good intentions. In today’s Sunday Skills, I want to show you how to easily set up rules to manage the inflow to your Outlook inbox. The steps are very simple and explained in this presentation : What matters really, is how you can use these…
How to compare average and median salary information
I recently described how to calculate a percentile. Today I will clarify the difference between the average and the median. Technically, the average is the sum of all data points, divided by the number of data points. The median is the 50th percentile, or the value that splits the data points in two equal groups…
4 skills to master for influential Compensation and Benefits
One of my first posts was about the fact that we need to move from compensation data to compensation intelligence. This is really one of my areas of interest as I believe it is one of the main ways that we can get real attention from the business – by talking the same language as…
How to use vlookup in Excel
In today’s Sunday Skills I will cover one of the most useful functions in Excel for the Compensation Manager. Vlookup is like an advanced copy/paste function, which automatically copies for you only the information for data which is present in both files (the main file and the source file). For example, imagine you are participating…