Problem with ‘Tied scores”

  • Resolved binutz

    (@binutz)


    4 years, 11 months ago

    This refers to my earlier question regarding administering a personality traits questionnaire to classify people into 6 categories (A,B C,D,E,F) based on their most dominant trait.My questionnaire has 42 questions? with a maximum of 7 points allotted to each category. The test result will indicate the specific category of the test taker, based on the highest points scored.

    The formula I used for achieving that is :
    a > b AND a > c AND a > d AND a > e AND a > f?? ( Category A )
    b > a AND b > c AND b > d AND b > e AND b > f?? ( Category B )
    c > a AND c > b AND c > d AND c > e AND c > f?? ( Category C )
    d > a AND d > b AND d > c AND d > e AND d > f?? ( Category D )
    e > a AND e > b AND e > c AND e > d AND e > f?? ( Category E )
    f > a?AND f > b AND?f > c AND f >?d AND?f > e? ( Category F )

    This worked perfectly for me.
    However ,I confront with an issue of dual scores (Tie-score) ,when a test taker gets same scores (Highest) in more than one category.( For example, the test taker gets 6 points out of 7 in Category A as well as Category B )
    In such cases the above formula doesn’t display any result,except scores.
    Is it possible to show more than one category as results when there is a tie in the maximum points scored?
    If yes,what changes should I make in the current formula?

    OR
    Does it make sense to add a 7th category (G) to display the specific Categories?that ended up in a tie, based on the highest scores? If it works ,what formula should i use?
    Thanks for your attention

    Zach

    • This topic was modified 4 years, 11 months ago by binutz.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Thread Starter binutz

    (@binutz)

    Hi Alexander,
    As a work around,I added a 7th category named G to show tied scores.
    4 points out of 7 has been fixed as a condition for being regarded a dominant trait in this case.
    The formula that i worked out is as follows:(Category G)

    a => 4 AND ( a = b OR a = c OR a = d OR a = e OR a = f ) OR b => 4 AND ( b = a OR b = c OR b = d OR b = e OR b = f ) OR c =>4 AND ( c = d OR c = e OR c = f ) OR d => 4 AND ( d = e OR d = f ) OR e =>4 AND ( e = f ) OR f => 4

    With this ,I am able to show the result with ” Multiples Traits” as the label for category G.

    Though this is not the perfect solution,it just serves my purpose.

    Thanks for this wonderful plugin.

    Zach

    • This reply was modified 4 years, 11 months ago by binutz.
    Plugin Contributor ustimenko

    (@ustimenko)

    Zach, you can use compuvars addon to minimize code duplication.

    So if you have for example three results, you will have 3 vars: is_result_a, is_result_b, is_result_c.

    Which you will use in your results’ formulas.

    And for tied result you can use this formula: (is_result_a + is_result_b + is_result_c) > 1

    Thread Starter binutz

    (@binutz)

    Thanks a lot for checking my post and responding with the right solution!
    I will check that out later.
    Zach

    In short
    Simple Formulas

    Details
    Hi, I am just lost as to how to do these formulas and I am looking for a list of example formulas on your site, but cannot seem to find anything.
    I have a very simple depression scale test I am trying to do.
    If the answer is 5, 6, 7, 8 or 9, it is mild depression.
    How do it put it in the result box?
    Scale is Depression.
    I have tried to use several things.
    depression > 4 AND < 10
    or
    depression = 4, 5, 6, 7, 8, 9
    or
    depression = 4 OR 5 OR 6 OR 7 OR 8 OR 9
    or
    depression =<4 AND =>9
    but nothing seems to work. How do you do this? and do you have list of formulas like these to help some of us who do not know what they are doing. lol

    • This reply was modified 4 years, 11 months ago by docwesley.

    Okay, so I figured out what I was doing wrong. I needed to restate “depression” in the formula. For anyone else who is looking for this answer. The correct formula, in my case, was “depression => 4 AND depression <= 9”

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Problem with ‘Tied scores”’ is closed to new replies.