Help with a formla of weighted average

Question

Hello!&nbsp;I kindly ask your help to create formulas for an evaluation board. I have an evaluation of criterias, which have different weight percentage.&nbsp; How to calculate the final score of evaluations, according to these percentage weights?Big thanks in advance!&nbsp;&nbsp;&nbsp;&nbsp;Person APerson BPerson C&nbsp;&nbsp;&nbsp;CRITERIAS for group 1Percentage system&nbsp;EvaluationEvaluationEvaluation&nbsp;Evaluation legend&nbsp;Criterias&nbsp; weight75%&nbsp;xxx&nbsp;1poorCriteria A30%&nbsp;421&nbsp;2neutralCriteria B20%&nbsp;421&nbsp;3goodCriteria C25%&nbsp;421&nbsp;4excellent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Criterias for group 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Criterias weight25%&nbsp;xxx&nbsp;&nbsp;&nbsp;Criteria A8%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Criteria B8%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Criteria C9%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;TOTAL100%&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

hansvogelaar · Answer

HelenHi&nbsp;
Why do the weights for A, B and C in group 1 add up to 100% while the total weight for group 1 is 75%, and the weights for A, B and C in group 2 add up to 25% which is also the total weight for group 2?

helenhi · Answer

Hi&nbsp;HansVogelaar&nbsp;Thanks for bringing this out! I have corrected the table.&nbsp; The criterias weight adds up from the criterias A, B and C,&nbsp; so the 75% comes from the criterias below and same logic for the 25%.&nbsp;

Forum Discussion

Help with a formla of weighted average

2 Replies

Resources

		Person A	Person B	Person C
CRITERIAS for group 1	Percentage system	Evaluation	Evaluation	Evaluation	Evaluation legend
Criterias weight	75%	x	x	x	1	poor
Criteria A	30%	4	2	1	2	neutral
Criteria B	20%	4	2	1	3	good
Criteria C	25%	4	2	1	4	excellent

Criterias for group 2
Criterias weight	25%	x	x	x
Criteria A	8%
Criteria B	8%
Criteria C	9%

TOTAL	100%