I need to normalize the math scores that are stored as a property on the node and then update the same property with a normalized value. I have tried this:

MATCH (r:MathScore)

WITH COLLECT(r.score) as myScores

UNWIND myScores as x

WITH myScores, min(x) as n, max(x)-min(x) as den

WITH den, myScores, [val in range(0, size(myScores)-1) | round((myScores[val]-n)*100/den)/100] as g

RETURN g, myScores

The above query gives me the correct results in two lists but I am not able to find a way to update r.score with the values in list g.

Please, can someone help?

Thanks!