• Stop being a LURKER - join our dealer community and get involved. Sign up and start a conversation.

Math Problem - If we have 361 Reviews with a 4.3 Average how many...

Dan Sayer

Boss
Staff member
Dec 4, 2009
476
517
Awards
7
First Name
Dan
If you clicked on this because you saw "Math Problem" then I applaud you. I'm pretty sure I peaked mentally at 38 and all new information I take in replaces one piece of information that I probably needed...

I'm looking for an excel formula to figure how many 5-Star reviews would be needed to move a 4.3 average, from 361 reviews, up to a 4.6 average. I thought I had it figured out but it didn't work as other known volumes of existing reviews and average stars changed. I would like to just apply a formula to a sheet for all of my stores and all review sources. Input fields would contain the current number of reviews and current average stars (per review source). Result field would give the stores an idea of how many 5-Star reviews they need (per source) to bring up their score to my benchmark.

Yes, I did Google it. I didn't find anything that would fit this particular scenario. Can you assist?
 
Here is the formula:

'current reviews' of 361 x 'current rating' of 4.3 = ' current rating sum' of 1552.3

In order to average 4.6 you need a rating sum of 1660.6

So 'desired rating sum' of 1660.6 - 'current rating sum' of 1552.3 = 108.3 then you divide that by the difference between 'desired rating average' of 4.6 and 5 = .4

108.3 / 0.4 = 270.75