Complex Average in Excel
If I have a list of 80,000+ animals and their home adresses, how do I get an
average of how many animals there are per household? I have a unique animal
identifier and addresses for the animals, but there are 80,000 entries. Some
addresses may have 10+ animals, some may have 1. Also some animals may be
listed one to three times. The problem I have is how to find out how many
animals there are per address (average). I am using Excel 2003. Thank you.
|