MHB How Do You Calculate Average Event Attendance?

[ryakaki]

Hello all! :D

I have a very basic (not basic enough for me apparently) problem. I'm trying to find out on average how many times people have attended an event. There's a total of 12 events. Below is a simplified version of my table with number of events in the first column and number of people who attended one, two,..., twelve events in the second column. I'm not entirely sure how to do this, but would it just be $$(1*100 + 2*200 + ... + 12*1200) / (100 +200 + ... + 1200) $$? Any help for this new guy would be appreciated! Thank you!

1 100
2 200
3 300
4 400
5 500
6 600
7 700
8 800
9 900
10 1000
11 1100
12 1200

 

[Jameson]

Re: Average attendment problem

Hi ryakaki, (Wave)

Welcome to MHB!

Does the first column refer to the event number, like the first event, the second event, etc.? Or does it refer to the number of total events visited? If the latter that would mean that 100 people visited just 1 event but 1200 people visited all 12 events. Can you clear that up for me?