<iframe src="//www.googletagmanager.com/ns.html?id=GTM-KC3JWW" height="0" width="0" style="display:none;visibility:hidden">

Blog

    Filter by month
    Filter by Category

    How to Calculate Net Promoter Score

    Business team analyzing market research results together

    Calculating a Net Promoter Score can seem daunting at first, but in this blog, we’ll explain a little of the methodology behind the score, and show you an excel formula for calculating it.

    The Three Groups.

    Net promoter scores are based by grouping respondents into three groups, based on their answer to the question “How likely is it that you would recommend [this company] to a friend or a colleague”, on a scale of one to ten.

    People who answer between one and six are “detractors”, seven and eight are “neutral” and those who answer nine or ten are “promoters”.

    The Calculation

    Firstly, the total numbers of promoters and detractors need to be identified.

    With those numbers determined, you subtract the number of detractors from the number of promoters. It’s fine if this number is positive or negative.

    Divide the answer to that by the total number of responses, then multiply it by 100.

    The number you get, rounded to the nearest whole number, should be between 100 and -100. If it isn’t, you’ve gone wrong somewhere and need to do the calculation again. If it is, then this is your score.

    NPS Excel Formula

    If you’ve got a large data set, then doing things manually via the above method can be time-consuming, but it can be done with a single spreadsheet formula.

    Here it is:

    =ROUNDUP((100*((COUNTIF([Data],">8")-COUNTIF([Data],"<7"))/COUNT([Data]))),0)


    Paste this into Excel or Google Sheets (or other spreadsheet), and just replace [Data] with the data range in your response spreadsheet that has the NPS answers in it.

    Run the formula and there you are. Your score should be right there looking at you from the spreadsheet cell.

    But here’s the best part – SmartSurvey makes even this method unnecessary. Our built-in Net Promoter Score question will collect data that’s automatically processed to show you the correct score via our reporting tools.

    All you need to do is create a survey, add the question, and choose what you want to ask about, it couldn't be easier.

    NPS®, Net Promoter® & Net Promoter® Score are registered trademarks of Satmetrix Systems, Inc., Bain & Company and Fred Reichheld.

    Matter of Focus Choose SmartSurvey
    Measuring Your Net Promoter Score

    About Author

    Default Author Image
    Rich Tysoe

    Related Posts
    How To Deploy A Post Purchase Survey To Boost E-Commerce Sales
    How To Deploy A Post Purchase Survey To Boost E-Commerce Sales
    6 Ways to measure customer satisfaction
    6 Ways to measure customer satisfaction
    5 Surveys That Can positively impact your bottom line
    5 Surveys That Can positively impact your bottom line

    Comment

    Subscribe To Blog

    Subscribe to Email Updates