Average relative to quantity Not really sure how to ask my question. I have a list of average transaction wait times which are averaged over the count of the transactions for each zone, as shown in the list below which is sorted by the avg wait highest to lowest. When I look at the top entry I think "yuck, they waited 177 seconds and it was only 1293 transactions." When I look at the entry for zone:22 I think "wooHoo! This zone had 2600 transactions and only waited 47 seconds!" 
I want to give each row a score based on the number of transactions and the wait time that they experienced. What would be the bast way to do that? (I'm sure I learned how to do this 40 years ago when I was in High School, but I don't remember today what formula to apply. ;-) ) Maybe I'm overthinking this?? 


The question has many answers. It depends on what is important. I can give a score as number of transactions plus number of seconds wait time, but that is probably not what you want. I would suggest giving separate scores for wait time and number of transactions (how you score these is also subjective), then take an average (or some weighted average) of the scores. Here is an example:


*

*Score for transactions is #of transactions/2609 *100, where 2609 is the maximum number of transactions in a zone

*Score for wait times is 100*28.6/wait time, where 28.6 is the minimum wait time

*Weighted score is (2*Wait time score+transactions score)/3

