Hi,
I have a list of countries with 2 columns of count values that I have calculated the percent change between.
Similar to the attached.
I am interested in creating a metric to draw attention to the largest differences. For instance, GBR shows a change of only 2.6% but the overall change is an additional 135,550 records. I'd like to draw attention to the fact that although the percent change is comparatively low, there is a large addition of data that needs to be checked (this is a QA task).
Does it seem reasonable to simply multiple the Difference column by the Percent Change column and then perform a sort.
Is there some other known statistical method for achieving 'importance' of change?
Thanks!
I have a list of countries with 2 columns of count values that I have calculated the percent change between.
Similar to the attached.
I am interested in creating a metric to draw attention to the largest differences. For instance, GBR shows a change of only 2.6% but the overall change is an additional 135,550 records. I'd like to draw attention to the fact that although the percent change is comparatively low, there is a large addition of data that needs to be checked (this is a QA task).
Does it seem reasonable to simply multiple the Difference column by the Percent Change column and then perform a sort.
Is there some other known statistical method for achieving 'importance' of change?
Thanks!