Results 1 to 3 of 3

how to find weightage of a percentage score

This is a discussion on how to find weightage of a percentage score within the Excel Questions forums, part of the Question Forums category; Hi, I am not sure how to explain this. Let me put this in simple terms. I have three areas ...

  1. #1
    New Member
    Join Date
    Jun 2007
    Posts
    5

    Default how to find weightage of a percentage score

    Hi,

    I am not sure how to explain this. Let me put this in simple terms. I have three areas where an employee is scored a percentage score. Say for employee A could be reviewed 10 times in process 1 and he could score 90% on it, could be reviewed 2 times in process 2 and be scored 80% on it, and could be reviewed 20 times in process 3 and be scored 50%. I want 50% of the scores of process 1, 40% scores of process 2 and 10% scores of process 3. how do i go about getting the final scores based on these weightages?

    Thanx
    aarosh.

  2. #2
    Board Regular
    Join Date
    Aug 2005
    Posts
    712

    Default

    Code:
    Test          : A   B   C
    Weights       : 50% 40% 10%
    Times Reviewed: 4   3   1
    Score         : 80% 90% 60%
    From the best of my understanding you want:
    (4*.8*.5+3*.9*.4+1*.6*.1)/7
    So that a more reviewed test is also weighted more?

    If this is the case than use Sumproduct in the following way

    Code:
    SUMPRODUCT(A$2:C$2,A3:C3,A4:C4)/SUM(A3:C3)
    If you don't want the number of times a test has been taken to factor in simply use
    [code]SUMPRODUCT(A$2:C$2,A4:C4)[code]

    HTH,
    ~GoldFish

  3. #3
    New Member
    Join Date
    Jun 2007
    Posts
    5

    Default

    Thank you..that helped.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com