I have a question about calculating correlations with aggregated data and I would be really happy if someone could answer my question.
I have a population (not a sample) composed by more than 100.000 tickets of a customer care service. These tickets contain several information, however I focus on:
1) the keywords added by the user when submitting the ticket (a ticket can be tagged with not more than 10 keywords)
2) the time needed to close the ticket
I'm trying to check whether there exists a correlation between the number of keywords used and the time needed to close the tickets. Thus, I've grouped the tickets according to the keywords used, I've calculated the median of each group (since it is more robust to extreme values) and finally I've calculate the correlation (Spearman) between the number of keywords and these median values, finding a high positive rho.
Since I know that this result cannot be used to infer something about the single tickets (http://en.wikipedia.org/wiki/Ecological_fallacy), I would like to know if what I did make sense and how I could interpret this correlation.