Calculating a numeric score from a qualitative score

  • Hi All,


    I have a table where cars are evaluated across multiple categories qualitatively. The qualitative scores have numeric score mappings. I want to find how much did each car score numerically across all categories based on the summation of the representative numeric score for each of the qualitative scores. I want to find the "Sum" column score. You may refer to the attached file for more clarity. Thanks for the help

  • la_coyote

    Changed the title of the thread from “Calculating a score from a qualitative score using a representative range” to “Calculating a numeric score from a qualitative score”.