Calculating 2 weighted averages in one equation

[rifaiii]

Hello Everyone,

this is my first post in your topic, am having a big time problem calculating the weighted average in my below sample of Data:

Lifetime Users # Occurrences
1 Month 50000 24
2 Months 10000 24
3 Months 5000 24
4 Months 2500 24
5 Months 1500 24


As you can see the sample includes data about the lifetime of users and the number of users as well as the occurences of each lifetime period. the question is how can i calculate the average of user lifetime according to this sample.

Note: Am sorry, if this topic is not posted in the right section, but am not really an expert at statistics.

Waiting for your replys.

Thanks.

 

[Valkarie]

The formula for calculating the weighted average is: Weighted Average = (Sum of (Number of Occurrences * Lifetime of Users)) / Sum of Number of Occurrences In this case, the weighted average would be:Weighted Average = (50000*24 + 10000*24 + 5000*24 + 2500*24 + 1500*24) / (24 + 24 + 24 + 24 + 24) Weighted Average = 9500