I have a data frame that has various capital and metropolitan cities with various economic, market and performance data. One set of variables is each total annual non-domestic visitor volume and the recent annual growth rates in that volume.
As you might expect cities with smaller annual total volumes tend to see larger annual growth percentages; and as cities grow to see larger total visitor volumes their annual growth rate tends to get smaller and flatten.
A sample of the dozens of cities might be: - City 2014-intl-arr-000s Travel-%incr-13-14 - Abu Dhabi 2200.3 5.9 - Bangalore 856.6 31.1 - Hanoi 3000 29.9 - Istanbul 11871.2 13.2 - London 17383.9 3.6 - NYC 12230 3.2
Running correlations and regressions on various other data variables I have in the dataset have worked fine for drawing some insight, but my stats experience isn't deep enough for how best to make a fair comparison in visitor growth (%) performance between these cities.
Is there a stats process(es) I can/should follow to 'normalize" these particular data so I make a fairer judgement of comparative significance of performance between the different growth rates, since they are obviously at different stages of any potential growth curve by which I might compare or model them?
I was thinking I could geographically subgroup them and compare a city's performance vs the median (and/or mean) of the region. Or possibly subgroup by tiers of visitor totals, and do the same. And then maybe attribute a score based on an ANOVA result. But I wonder how I might consider comparing all cities against the performance of each of the others -- unless this is a fool's errand.