+ Reply to Thread
Results 1 to 4 of 4

Looking to calculate how many perfect surveys to hit the goal

  1. #1
    Registered User
    Join Date
    04-25-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    5

    Looking to calculate how many perfect surveys to hit the goal

    Need to calculate how many Customer Satisfaction Surveys with a score of 10 are needed to return to a goal of 9.75

    If a survey is received with a score of zero, thirty nine surveys at 10 are needed to reach a goal of 9.75






    The link below seems to have had this same question and/or answer, however it has been removed.
    http://www.excelforum.com/excel-form...-the-goal.html

  2. #2
    Forum Expert ben_hensel's Avatar
    Join Date
    01-26-2012
    Location
    Northeast USA
    MS-Off Ver
    Office 365
    Posts
    2,043

    Re: Looking to calculate how many perfect surveys to hit the goal

    This isn't really an excel question, but instead, middle-school algebra.

    Variables:
    Known:
    Nx = number of existing surveys
    Sx = sum of values of existing surveys
    G = goal for the average
    Unknown:
    N10 = number of perfect surveys (eg, result of 10)

    Expression:
    (Sx + 10 * N10) / (Nx + N10) = G
    ;; sum / count = average

    Rearranging:

    N10 = (G * Nx - Sx) / (10 - G)

    Replace the variables with cell references, and that's good-to-go for excel.

  3. #3
    Valued Forum Contributor
    Join Date
    09-01-2013
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2010
    Posts
    324

    Re: Looking to calculate how many perfect surveys to hit the goal

    Basically as stated above it's pretty basic math (for some) to get target #.

    1. In column A place each survey score.
    2. In B1 place your goal (9.75)
    3. In C1 paste the Formula below.

    Each time you add a score to coulmn A the number of 10's needed will update in C1.

    Please Login or Register  to view this content.


    Shelton A.
    If Helpful, Add Reputaion!

  4. #4
    Registered User
    Join Date
    04-25-2014
    Location
    Florida
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: Looking to calculate how many perfect surveys to hit the goal

    Thank you

    PHP Code: 
        A            B
    1    9.702380952   Current CSat average
    2    12            Number of surveys received
    3    9.75          Target Goal
    4    10            Max Score
    5    3             Max scores required to meet goal
    Entered into B5 
    =CEILING(B2*(B1-B3)/(B3-B4),1
    Last edited by Doc Science; 04-25-2014 at 03:55 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to calculate how many more perfect surveys to hit the goal.
    By carlodejesus in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-28-2017, 12:12 PM
  2. Replies: 0
    Last Post: 12-03-2012, 04:21 PM
  3. How to calculate a price using goal seek?
    By karo3440 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-25-2011, 03:26 AM
  4. Replies: 1
    Last Post: 09-20-2010, 07:06 PM
  5. Calculate Goal each day
    By [email protected] in forum Excel General
    Replies: 7
    Last Post: 06-22-2006, 03:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1