Hi folks,
I am not a student, but am trying to make better sense of data. I am very familiar with R for a number of purposes, but am not sure of the technical name for what I am trying to calculate here.
The background:
I am measuring metrics on how a group of people are completing a task. Multiple of these tasks are put into a request system with a due date. The request system measures time and manages state of the tasks. We are ultimately focused on "days past due" bucketed by each group of people for a variety of reasons not worth getting into.
The data points:
The numbers vary, but generally could be summarised like the numbers below (though we have the raw data and can measure other data points if necessary):
The raw data gets thrown together to tell us that our average days past due is something like 56.23082361 days past due
The problem/question:
I want to measure the relative impact of all of these numbers, but am having trouble finding the actual name for what I want to figure out. Sure, a basic weight could be calculated by saying that Group A is 20/5658, but weight is not what I am going for, rather "impact" (which is probably not the real name for what I am thinking of).
In other words, what really moves the needle? What is the term I am looking for to determine the relative impact of each group on the numbers (focused on high ones)? In the example above, C might have a large number of total issues, but the days past due is relatively low, so they likely provide downward pressure on the mean. Group A might have a mean days past due that is higher, but their total is lower.
Am I overcomplicating these things and should just stick to looking at weight or issues individually? Is there a term that I can research more and add to the summary to make better sense of these numbers?
I am not a student, but am trying to make better sense of data. I am very familiar with R for a number of purposes, but am not sure of the technical name for what I am trying to calculate here.
The background:
I am measuring metrics on how a group of people are completing a task. Multiple of these tasks are put into a request system with a due date. The request system measures time and manages state of the tasks. We are ultimately focused on "days past due" bucketed by each group of people for a variety of reasons not worth getting into.
The data points:
The numbers vary, but generally could be summarised like the numbers below (though we have the raw data and can measure other data points if necessary):
Code:
+------------+-----------------------+---------+
| Group Name | Average Days Past Due | Total # |
+============+=======================+=========+
| A | 98 | 20 |
+------------+-----------------------+---------+
| B | 64 | 39 |
+------------+-----------------------+---------+
| C | 36 | 3885 |
+------------+-----------------------+---------+
| D | 24 | 548 |
+------------+-----------------------+---------+
| E | 14 | 64 |
+------------+-----------------------+---------+
| F | 145 | 1102 |
+------------+-----------------------+---------+
The problem/question:
I want to measure the relative impact of all of these numbers, but am having trouble finding the actual name for what I want to figure out. Sure, a basic weight could be calculated by saying that Group A is 20/5658, but weight is not what I am going for, rather "impact" (which is probably not the real name for what I am thinking of).
In other words, what really moves the needle? What is the term I am looking for to determine the relative impact of each group on the numbers (focused on high ones)? In the example above, C might have a large number of total issues, but the days past due is relatively low, so they likely provide downward pressure on the mean. Group A might have a mean days past due that is higher, but their total is lower.
Am I overcomplicating these things and should just stick to looking at weight or issues individually? Is there a term that I can research more and add to the summary to make better sense of these numbers?