Performance Reporting Measures vs Performance Management Measures – Part 2
05/12/2019
Another Problem with % Measures
You may have read my blog from last week comparing Performance Reporting Measures vs Performance Management Measures.
Performance reporting is littered with measures that may appear to carry meaning for some people, but in our observations, have been misleading and impenetrable to many. And certainly don’t help understanding nor how to improve!
Here are some examples of reporting measures that we introduced previously:
- % items completed: % implies a ratio – with a numerator and denominator. E.g. % Repairs Completed defined by (Number of Repairs Completed / Total Number of Repair Calls) * 100
- % completed within some timeframe: E.g. From a previous blog’s A&E Figures, we saw % A&E attendants seen in 4 hours or under.
- Complicated Measure Combinations: E.g. % Forecast Accuracy in Supply-chain
- Applying sophisticated statistical treatment to raw performance measures that only stats specialists can read: E.g. Exponentially weighted moving averages
- Statistical representation of a population of people or things: E.g. Electric Car Use by Country
There’s one more critical problem with % measures I didn’t mention last time. And this one is particularly mind-bending, even to some of those who have studied Maths!
You start to stumble across the problem when you start drilling down into sub-sets of the data to “better understand what is going on”. So, for example, regarding A&E data, you may want to drill down by hospital and by age-group. You do this at your peril!
But, to keep this light, we’ll select an alternative example from Wikipedia that you can all go take a look at – batting percentages over two years for two baseball players. We could have picked a cricketing example, but who knows what’s happening in the Test in New Zealand right now – well I said I wanted to keep this light!
So here are the baseball figures – the figures are (number of hits) / (number of “at bats”):
So looking at the individual year’s batting % in each of 1995 and 1996, you’d want to bet on David Justice. BUT! When you look at their combined % for the 2 years, you’d want to go with Derek Jeter. Confused?
I won’t explain this paradox here, since Wiki does a very good job of it – but it is well-known (to some mathematicians and stats guys) as Simpson’s Paradox. It happens because both the numerator and denominator can vary independently.
The ONLY way to resolve this is to have a clear PURPOSE for the business process (Wiki refers to STORY), which will guide the reader on whether to use the aggregated % or the component %s, OR to use an alternative measure altogether.
And I’m pretty sure Dilbert would encourage you to look at the underlying raw data – i.e. number of “at bats” and the “hits” separately (instead of, or, worst case, as well as %’s) if you really want to understand what’s happening!
Categories & Tags:
Leave a comment on this post:
You might also like…
Come to a virtual study session in May
What are virtual study sessions? These are online study sessions facilitated by Library staff, where you can study independently alongside other students via Teams. They are a great way for you to dedicate specific time ...
Getting started on your School of Management thesis
Writing a thesis, business plan, internship project or company project can be a daunting task, and you might have some uncertainty or questions around how to get started. This post will share some ideas and ...
Sustainability by royal request: Managing an event fit for a King
The Coronation of King Charles III on May 6th 2023, was watched by millions of people around the world with tens of thousands of people travelling to Central London to witness the pageantry firsthand. ...
Getting started on your Master’s thesis
Please note: This post is intended to provide advice to all students undertaking a thesis in the Schools of Aerospace, Transport and Manufacturing; Water, Energy and Environment, and Defence and Security. There is separate advice ...
Finding your tribe: “Joining the sustainability community was the best decision”
For students on Cranfield’s Sustainability Business Specialist Apprenticeship, community and camaraderie is a vital component for success. Designed in consultation with industry, the part-time Level 7 apprenticeship aims to deepen participants’ knowledge of the ...
“My sustainability studies gave me the confidence to take on Amazon”
Not everyone would have the confidence to challenge a big global power like Amazon but, for Colin Featherstone, Senior Technology Manager and Tech Sustainability Lead at Morrisons, his Cranfield studies equipped him with the ...