View original (French)

Get a score out of 20

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

  1.
    M-12 Posted messages 1349 Status Member 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
    1. Arnaudtherock Posted messages 7 Status Member
       
      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
  2. Raymond PENTIER Posted messages 58227 Registration date   Status Contributor Last intervention   17 490
     

    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
    1. Arnaudtherock Posted messages 7 Status Member
       
      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
    2. Arnaudtherock Posted messages 7 Status Member
       
      0
  3. via55 Posted messages 14393 Registration date   Status Member Last intervention   2 759
     
    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
    1. Arnaudtherock Posted messages 7 Status Member
       
      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