Basic maths question - calculating Trustpilot score.

SideWinder

SideWinder

SideWinder

Consigliere
Joined
12 Jun 2004
Posts
151,029
Location
SW17
Hello!

I want to calculate how many more 5* stars review a company will need to go from 4.6 to 4.7 on Trustpilot. It would be great to know how many would be required to hit 4.8 and 4.9 too.

4.6 currently:

270 reviews
5 star = 223
4 star = 19
3 star = 7
2 star = 7
1 star = 14

I am aware this is easy maths and the figure I came up with just seemed quite high (3 figures)...so I wanted to double check. :o

Can anyone help with this easy maths?
 
Assuming that they just take the pure arithmetic mean, round to 2 significant figures and you get no other reviews. You need 45 5* reviews to reach 4.7.

Assuming the above, the formula is

270y-1253.5/5.05-y<n

Where y is the desired score and n is the number of 5* reviews you need to reach y

170 5* reviews for 4.8
464 5* reviews for 4.9
1930 5* reviews for 5.0
 
Disco_P said:
Assuming that they just take the pure arithmetic mean, round to 2 significant figures and you get no other reviews. You need 45 5* reviews to reach 4.7.

Assuming the above, the formula is

270y-1253.5/5.05-y<n

Where y is the desired score and n is the number of 5* reviews you need to reach y

170 5* reviews for 4.8
464 5* reviews for 4.9
1930 5* reviews for 5.0
Click to expand...

Yeh 45 is correct if they round up and assuming he gets no other lower reviews.
 
Hi - I have the same issue, if anyone is able to help that would be very helpful.

We are currently on 4.6 and trying to get to 4.7. We currently have:

403 reviews
5 star = 346
4 star = 15
3 star = 1
2 star = 2
1 star = 39

Maths is NOT my strong point!
 
I know this doesn't help the most recent post but since I created this thread in August, my business was 4.6 and now its just hit 4.8. :cool:

@Catherine Gabriel - Will wait for someone to help as I was also stuck but a variable that Trustpilot also include is the amount of recent 5* reviews as they are worth more than the older ones. Just thought I'd mention it. :)
 
Catherine Gabriel said:
Hi - I have the same issue, if anyone is able to help that would be very helpful.

We are currently on 4.6 and trying to get to 4.7. We currently have:

403 reviews
5 star = 346
4 star = 15
3 star = 1
2 star = 2
1 star = 39

Maths is NOT my strong point!
Click to expand...

Your average is 4.55

5 * 346 = 1730
4 * 15 = 60
3 * 1 = 3
2 * 2 = 4
1 * 39 = 39

Gives a total of 1836 stars from 403 reviewers so 4.55 average.
 
If you got 109 consecutive 5* reviews in a row you'd have:

5 * 455 = 2275
4 * 15 = 60
3 * 1 = 3
2 * 2 = 4
1 * 39 = 39

Giving a total of 2381 stars from 512 reviews and an average of 4.65 which would round up to 4.7
 
kindai said:
The score isnt just based on the star rating of the reviews, there is some weighting applied to each review also.
Click to expand...
so like older reviews lose weight to keep the score relevant with fresh reviews?

does anyone check these places anyway? I always google the company and check what people are saying on forums or reddit
 
arknor said:
so like older reviews lose weight to keep the score relevant with fresh reviews?

does anyone check these places anyway? I always google the company and check what people are saying on forums or reddit
Click to expand...

Correct. The newer reviews are worth more as they are simply recent so a true reflection of the service at the moment. Whereas reviews from a years ago would be less relevant. Also take into account a company would (almost definitely!) want to improve on their standards so there could be additional employees/people leaving etc.

People do refer to Trustpilot a lot. We also use reviews.co.uk as our official partner.
 
You must log in or register to reply here.
Back
Top Bottom