|
June 08, 2019, 05:59:49 PM Last edit: June 09, 2019, 01:20:25 AM by TimtheYoutuber |
|
How do I compare data that has different totals and create a benchmark? For example, look at the below problem.
2019 data
Problem X: Preventable times it occurs: | Non Preventable times it occurs | % of Preventable times 10 5 66.67%
Problem Y: Preventable times it occurs: | Non Preventable times it occurs | % of Preventable times 15 7 68.18%
Problem z: Preventable times it occurs: | Non Preventable times it occurs | % of Preventable times 2 9 18.18% 2018 data:
Problem X: Preventable times it occurs: | Non Preventable times it occurs | % of Preventable times 20 7 74.07%
Problem Y: Preventable times it occurs: | Non Preventable times it occurs | % of Preventable times 49 150 24.62%
Problem z: Preventable times it occurs: | Non Preventable times it occurs | % of Preventable times 18 49 26.87%
With this example, how could you create a benchmark with the different problem sets? Like for example, Problem X in 2019 was less preventable than in 2018. However, in 2019 there were more instances of problems so the data isn't 1:1 comparable. So what algorithm would I need to use in order to compare the data and create an appropriate benchmark that would accurately depict the different categories? Any help would be appreciated.
|