Whether your specialty is compensation, training/development or benefits, statistical analysis tools offer powerful methods for measuring and monitoring organizational performance. Much of what you need is available in Microsoft ® Excel, but finding it is another matter. And even when you do find it, some of Excel's built-in statistical capabilities can be much more effective when you couple them with a few well-chosen additions. This workshop shows human resources professionals how to use Excel to calculate and present statistics on benefits usage, compensation, evaluations, and a host of other data sets that you deal with every day. And it includes a set of macros that make Excel's built-in capabilities much more convenient to use.
Participants learn what Excel has to offer in support of statistical analysis:
- Frequency distributions and histograms
- Linear and non-linear regression
- Weighted averages
- Average, mode, median
- Percentiles, deciles, P90/P10, the Lorenz Curve and the Gini Coefficient
- Standard deviation and coefficient of variation
These techniques are powerful, but when we us them in a straightforward manner we create worksheets that can be difficult to maintain when changes are required. Using Excel's Naming facility, together with a few macros that are provided, makes statistical analysis with Excel much easier.
This is a hands-on workshop. Participants are encouraged to bring their laptop computers, with Microsoft Excel 2010 (or later) installed. All examples and macro utilities will be distributed during the workshop by means of a link to a downloadable file archive.
We demonstrate all principles and techniques using simple but realistic examples that enable participants to apply what they learn easily when they return to work. Attendees also receive one hour of email coaching after the workshop.
The workshop is aimed at compensation, benefits, and training professionals, and their managers.
Available in formats from one hour to one day.
- "Rick is a dynamic presenter who thinks on his feet to keep the material relevant to the
— Tina L. Lawson, Technical Project Manager, BankOne (now J.P. Morgan Chase)
- "Rick truly has his finger on the pulse of teams and their communication."
— Mark Middleton, Team Lead, SERS