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

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

Discussion in 'How To...' started by Dan Sayer, Mar 27, 2019.

This forum sponsored by...
  1. Dan Sayer

    Dan Sayer
    Expand Collapse
    Getting Refreshed

    First Name:
    Dan
    Dealer or Company Name:
    Anderson Auto Group, LLC
    Twitter Handle:
    @whostheman_dan
    Joined:
    Dec 4, 2009
    Messages:
    59
    Likes Received:
    35
    Location:
    Lincoln, NE
    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?
     
    Collapse Signature Expand Signature
  2. This forum sponsored by...
  3. joe.pistell

    joe.pistell
    Expand Collapse
    Uncle Joe

    First Name:
    Joe
    Twitter Handle:
    JoePistell
    Joined:
    Apr 7, 2009
    Messages:
    3,953
    Likes Received:
    1,369
    Location:
    New York
    Hi dan. IMO, you'll never find that out because if that data was out, everyone would be gaming the ratings (like you are).

    Idea: Consider a reward to get the most 5 stars in April... and let the review algos take it from there.
     
    Collapse Signature Expand Signature
  4. joe.pistell

    joe.pistell
    Expand Collapse
    Uncle Joe

    First Name:
    Joe
    Twitter Handle:
    JoePistell
    Joined:
    Apr 7, 2009
    Messages:
    3,953
    Likes Received:
    1,369
    Location:
    New York
    Oh, and take a look around at dealer reviews your market. Almost everyone is 4 stars and higher.

    #ThinkAboutIt
    #ItsTheCommentsNotTheStars
     
    Collapse Signature Expand Signature
  5. jon.berna

    jon.berna
    Expand Collapse
    D.R. Truth

    First Name:
    Jon
    Dealer or Company Name:
    Driven Data
    Twitter Handle:
    Jon_Berna
    Joined:
    Nov 14, 2011
    Messages:
    126
    Likes Received:
    104
    Location:
    Indianapolis, IN
    exactly 270 new 5 star reviews :)
     
    Collapse Signature Expand Signature
    • Like Like x 3
  6. Jason

    Jason
    Expand Collapse
    Refresher

    First Name:
    Jason
    Dealer or Company Name:
    Launch Digital Marketing
    Twitter Handle:
    jasonstum
    Joined:
    Dec 22, 2009
    Messages:
    105
    Likes Received:
    48
    Location:
    Detroit
    Dan, I'm no rocket surgeon, but just going on the math alone it would take 271 consecutive five star reviews to go from a 4.3 to 4.6 based on the info you shared. I think. Lol. Maybe someone else can confirm or deny that

    Edit: Looks like @jon.berna@jon.berna answered as I was figuring this out. Confirmed?
     
    • Like Like x 2
  7. jon.berna

    jon.berna
    Expand Collapse
    D.R. Truth

    First Name:
    Jon
    Dealer or Company Name:
    Driven Data
    Twitter Handle:
    Jon_Berna
    Joined:
    Nov 14, 2011
    Messages:
    126
    Likes Received:
    104
    Location:
    Indianapolis, IN
    I rounded 4.599525 to 4.6 haha
     
    Collapse Signature Expand Signature
    • Funny Funny x 1
  8. jon.berna

    jon.berna
    Expand Collapse
    D.R. Truth

    First Name:
    Jon
    Dealer or Company Name:
    Driven Data
    Twitter Handle:
    Jon_Berna
    Joined:
    Nov 14, 2011
    Messages:
    126
    Likes Received:
    104
    Location:
    Indianapolis, IN
    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
     
    Collapse Signature Expand Signature
    • Useful Useful x 2
    • Like Like x 1
  9. Dan Sayer

    Dan Sayer
    Expand Collapse
    Getting Refreshed

    First Name:
    Dan
    Dealer or Company Name:
    Anderson Auto Group, LLC
    Twitter Handle:
    @whostheman_dan
    Joined:
    Dec 4, 2009
    Messages:
    59
    Likes Received:
    35
    Location:
    Lincoln, NE
    @joe.pistell@joe.pistell not gaming the system, just casting a vision. Sales guys need a vision. I can give them the process but just needed that math to streamline the vision. @jon.berna@jon.berna and @Jason@Jason it doesn't surprise you figured that out. What is the formula?
     
    Collapse Signature Expand Signature
    • Like Like x 1
  10. jon.berna

    jon.berna
    Expand Collapse
    D.R. Truth

    First Name:
    Jon
    Dealer or Company Name:
    Driven Data
    Twitter Handle:
    Jon_Berna
    Joined:
    Nov 14, 2011
    Messages:
    126
    Likes Received:
    104
    Location:
    Indianapolis, IN
    For the non-math types you can cheat and just create a bunch of values in Excel from A1 down of 4.3 and add a bunch of 5s till you get close :itsok:
     
    Collapse Signature Expand Signature
    • Like Like x 1
  11. jon.berna

    jon.berna
    Expand Collapse
    D.R. Truth

    First Name:
    Jon
    Dealer or Company Name:
    Driven Data
    Twitter Handle:
    Jon_Berna
    Joined:
    Nov 14, 2011
    Messages:
    126
    Likes Received:
    104
    Location:
    Indianapolis, IN
    Collapse Signature Expand Signature
    • Like Like x 3
Verification:

(CustomImgCaptcha By Surrey Forum)

Draft saved Draft deleted

Share This Page

This forum sponsored by...