Get a score out of 20
Solved
Hello everyone.
I would like to find the calculation to convert a risk score into a score out of 20.
Risk score: 0 is the best score (0 if okay, 0.5 for partial mastery, 1 for non-mastery). I have 39 questions. So, 0 out of 39 = 20/20.
I forgot to mention that 9/39 equals the average, which is 10/20 :-(
Thank you in advance for your help
Arnaud
I would like to find the calculation to convert a risk score into a score out of 20.
Risk score: 0 is the best score (0 if okay, 0.5 for partial mastery, 1 for non-mastery). I have 39 questions. So, 0 out of 39 = 20/20.
I forgot to mention that 9/39 equals the average, which is 10/20 :-(
Thank you in advance for your help
Arnaud
3 answers
-
Hello,
Take the sum of the scores (0, 0.5, 1) from the 39 questions and divide by 1.95
you will have the score out of 20. -
Contributor
Oh no, Arnaudtherock!
If 0/39 is equivalent to 20/20,
then 39/39 will be equivalent to 0/20
and 9/39 is equivalent to 15.38/20!
It's 19.5/39 that gives an average of 10/20...
M-12's answer was almost right:
If R is the risk score out of 39, then the "classic" score out of 20 will be obtained with the formula =20-NR/1.95
--
Retirement is great! Especially in the Caribbean...
Raymond (INSA, AFPA)-
Thank you, Raymond. But as I added in my POST, the subtlety is to place the 10/20 at the risk score level of 9. I had found a formula that suited me well, but the fewer questions there are in my audits, the more I move away from the benchmark value of 9 risk points = 10/20. I’m not sure if I’m being clear :-(
-
-
-
Hello everyone
With the score out of 39 in B2, try this formula in C2 to see if it meets your expectations:
=IF(B2<10;ROUND(B2*(-10/9)+20;1);ROUND(B2*(-1/3)+39/3;1))
Best regards
Via
--
"Imagination is more important than knowledge." A. Einstein
