General Question
What's the mathematical formula to solve the following problem?
I’m going to pick as example the data of the goodreads page “The Girl with the Dragon Tattoo” as example. I have:
total of ratings: 3,270,453
total of reviews: 79,459
total of ratings for 1 star: 1,526,429
total of ratings for 2 star: 1,082,249
total of ratings for 3 stars: 443,450
total of ratings for 4 stars; 128,614
total of ratings for 5 stars: 89,711
I want to know the weighted average for:
ratings from reviewers of 1 stars: ?
ratings from reviewers of 2 stars: ?
ratings from reviewers of 3 stars: ?
ratings from reviewers of 4 stars: ?
ratings from reviewers of 5 stars: ?
Basically, the ratings per star I know (1,526,429, etc.) include both reviewers and non-reviewers alike. From that, I want to know what’s the weighted average of reviewers’ ratings for every star from 1 to 5. I want to exclude the ratings of non-reviewers. Don’t know if it makes sense.
1 Answer
Answer this question
This question is in the General Section. Responses must be helpful and on-topic.