+ Reply to Thread
Results 1 to 4 of 4

Calculating needed responses

Hybrid View

  1. 11-14-2008, 03:58 PM #1
    brian01tj
    brian01tj is offline
    Registered User
    Join Date
    10-10-2007
    Posts
    10

    Calculating needed responses

    I have a worksheet where I need to figure out how many more responses I will need to obtain the desired score (percentage).

    I have seven columns:
    a) "x number" of responses earning 100% score
    b) "x number" of responses earning 75% score
    c) "x number" of responses earning 50% score
    d) "x number" of responses earning 0% score
    e) total number of responses
    f) average percentage of all responses

    g) Desired score


    The idea is to manually input the desired percentage in column G. Then I would like it to calculate the amount of 100% responses (column A) that are needed to achieve that desired percentage.

    Thanks for any input you may have.
    Reply With QuoteRegister To Reply
  2. 11-14-2008, 04:18 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    Maybe like this:
          ---A--- ----B---- -----------------------------------C------------------------------------
  1    Score  Responses                                                                         
  2      100%       49  B2 =ROUNDUP( (SUMPRODUCT(A3:A5*B3:B5) - B7 * SUM(B3:B5) ) / (B7 - 1), 0)
  3       75%       17                                                                          
  4       50%        3                                                                          
  5        0%       10                                                                          
  6                                                                                             
  7   Desired    80.00%                                                                         
  8    Actual    80.06% B8 =SUMPRODUCT(A2:A5 * B2:B5) / SUM(B2:B5)
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 11-14-2008, 05:20 PM #3
    brian01tj
    brian01tj is offline
    Registered User
    Join Date
    10-10-2007
    Posts
    10
    That would work. But, in my case I cannot change the initial amount of 100% responses. The problem Im having is that I need to figure out how many additional 100% responses that I will need to achieve the desires score.
    Reply With QuoteRegister To Reply
  4. 11-14-2008, 06:03 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
          ----A----- ----B---- --------------------------------------C--------------------------------------
  1     Score    Responses                                                                              
  2   Add'l 100%       75  B2 =ROUNDUP( (SUMPRODUCT(A4:A6*B4:B6) - B8 * SUM(B4:B6) ) / (B8 - 1), 0) - B3
  3         100%       10                                                                               
  4          75%       14                                                                               
  5          50%       14                                                                               
  6           0%       15                                                                               
  7                                                                                                     
  8      Desired    80.00%                                                                              
  9       Actual    80.08% B9 =SUMPRODUCT(A2:A6 * B2:B6) / SUM(B2:B6)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1