Get a score out of 20

Solved
Arnaudtherock Posted messages 7 Status Membre -  
Arnaudtherock Posted messages 7 Status Membre -
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

3 réponses

M-12 Posted messages 1349 Status Membre 285
 
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.
0
Arnaudtherock Posted messages 7 Status Membre
 
Thank you M-12, but I forgot to mention that 9/39 is equivalent to my average, which is 10/20. There is no such thing as 20/39 = 9/20, for example. Sorry for the public statement.
0
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 

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)
0
Arnaudtherock Posted messages 7 Status Membre
 
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 :-(
0
Arnaudtherock Posted messages 7 Status Membre
 
0
via55 Posted messages 14730 Registration date   Status Membre Last intervention   2 755
 
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
0
Arnaudtherock Posted messages 7 Status Membre
 
Great, thanks, it works even though a 20 should be closer to 0 than to 6, but it remains coherent. Thanks again to all of you for your advice :-)
0