Statistical Methods for HR Professionals Using Microsoft Excel

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.

Learning model

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.

Target audience

The workshop is aimed at compensation, benefits, and training professionals, and their managers.

Program duration

Available in formats from one hour to one day.

Follow Rick

Send email or subscribe to one of my newsletters Follow me at LinkedIn Follow me at X, or share a tweet Subscribe to RSS feeds Subscribe to RSS feeds
Technical Debt for Policymakers BlogMy blog, Technical Debt for Policymakers, offers resources, insights, and conversations of interest to policymakers who are concerned with managing technical debt within their organizations. Get the millstone of technical debt off the neck of your organization!
Spreadsheet Models for ManagersA stand-alone Web site you read with your Web browser — is packed with tips, techniques, and dozens of worked examples for people who want their spreadsheet projects to be more reliable, more flexible, and most important: done on time.
What People Say About Rick's Programs
  • "Rick is a dynamic presenter who thinks on his feet to keep the material relevant to the group."
    — 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
Ebooks, booklets and tip books on project management, conflict, writing email, effective meetings and more.
If your teams don't yet consistently achieve state-of-the-art teamwork, check out this catalog. Help is just a few clicks/taps away!