I'm taking a data analysis course and decided to work on a customer analysis project. In the data, I have three countries:
- USA (539 unique users)
- BRA(385 unique users)
- TUR (129 unique users)
I'm trying to analyze the country that brings in the most income, so I've decided to look at the mean revenue for each country. However when I do that I get the following result:
It's not possible for Turkey to generate the most mean, because it has the lowest number of users and the lowest sum. I think it's showing the highest mean because the denominator when calculating the average is small.
How would you go about solving this issue? Should I randomly sample data from each country and then calculate the mean?
I'd really appreciate any pointers you could give or direction on how this would be solved in a real scenario. Thank you in advance! :)