Forum Discussion
Reverse Calculate Weighted Average Scores
I'm trying to reverse calculate the average for year 2024 I want to be 3.75 of 9 concepts weighted differently. More of a maths question I suppose but the formula would help as well as mathematical f...
Apologies, I should have mentioned I'm looking for the minimum score needed per weighted concept to achieve 3.75 overall average score. Please advise
How do you define minimum score?
- Each concept can score between 0-4 with some concepts weighed differently
For example concept 7 in 2023 is weighed at 18% with a score of 3.71
And concept 8 in 2023 in 2023 is weighed at 15% with a score of 3.71
Because they're weighed differently they're not the same scores
If they were all weighted the same it would be a more simple solution of
Adding together the sum of each concept score divided by number of concepts.
However, they're not all weighted the same and this is my issue
For the desired 2024 trying to reverse calculate, I've tried
3.75 / 100% = .0375 (1%)
But if I were to x 10 = .375 (10%)
It doesn't add up unless for some reason I need to move the decimal point
To 3.75 which would then make sense but not sure why
Please advise
