how to find weightage of a percentage score

Thanks:  0
Likes:  0

# Thread: how to find weightage of a percentage score

1. ## 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. 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.
Thank you..that helped.

## User Tag List

#### Posting Permissions

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