Assessment Methods

Question

Mathematics

It seems simple, but what is expected to be the result does not come out. The task is next. There is a twenty-question questionnaire; The question is evaluated on a ten-point scale. Each question has a “weight”, that is, for example, a question that is rated 7 points can be equivalent in importance to a question that is rated 10 points.

How can I make a formula for the correct and competent calculation of the result? What to read, maybe? If you sum up the product of points by their weight and divide by the number of questions, this is not true, is it?

Also, the result should be displayed on a ten-point scale. The coefficients (weight) for the questions are still unknown to me.

Answer 1

I would consider it as a weighted arithmetic mean

Answer 2

I tried to use. The formula is probably suitable, only my programming skills are now lacking. I seem to have implemented it, I write in PHP, but if all questions are given 10 points, then the final result is less than 10.
Here is the code:

$summa_weight = mysql_query("SELECT SUM(answer_weight) as answer_weight FROM answers"); // Считаю сумму всех весов
$summa_weight = mysql_fetch_array($summa_weight);

$value = mysql_query("SELECT answer_value, answer_weight FROM answers");

while ($row = mysql_fetch_array($value)) {
  $result += $row['answer_weight'] * $row['answer_value']; // Это числитель дроби (сумма произведений весов и значений)
}

$result = $result / $summa_weight[0]; // Делю сумму произведений весов и значений на сумму весов

Is this a weighted average formula, or am I doing something wrong?

Answer 3

You can use the convolution criteria
crypto.hut2.ru/svertka.html