SUM_PRODUCTtakes two lists, multiplies the values in one list with values that are on the same index in the other list. It then adds up those multiplications, resulting in a single new value.
SUM_PRODUCTwill operate on all values with the same index and ignore all the values of the larger list that exceed the largest index of the smaller list.
1*10 + 2*20 + 3*30and would return
999of the first list will therefore be ignored and, just as in the example before,
140will be returned as result.
SUM_PRODUCT, each individual risk factor score will be multiplied by its weight. The results are then summed up and returned as a single value.
Person phas a set of
risk_factorswith the following corresponding values 3, 6, 2, 8, and 5, the returned result would be 57.