Hi, I have this table, then I have the variable: "metas.ponderadas" with numbers like: 5.78, 5.50, etc.

I need to ubicate this numbers beetween ranges and assign them a value in a new colum:

My final result would be like this
after putting them beetween ranges
I have no idea how to finish this work, please if someone could help me.