General Question

luigirovatti's avatar

What's the mathematical formula to solve the following problem?

Asked by luigirovatti (2942points) 1 hour ago

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.

Observing members: 0 Composing members: 0

1 Answer

luigirovatti's avatar

I’d like to ask the moderators to delete this question. The problem i posed has no real solution with this data.

Answer this question

Login

or

Join

to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
or
Knowledge Networking @ Fluther