Hello everyone, I have a question with a large number of precentages being compared.
We are working on calculating precent increases of account volumes over time in each of the 50 states (and a few additional countries codes/etc).
The problem I am having is that when we hav a small starting volume (say between 1 and 100) precent changes can go throug the roof really fast (1 to 2 is a 100% increase).
What I want to do is find a way to compare all 50 states and determin which has the most signifigant increases in volume. A state where the volume moves from 500 to 1000 is signifigatly more important than one who goes from 1 to 2.
Any suggestions on how to calculate a number, say between 0 an 100, to classify each state on a scale of how signifigant the change is?