Can anyone please tell me How to normalize rating in a scale of 1 to 5?
In Yahoo! Movies dataset user has given a rating to a movie on the scale of 1 to 13 and 0 means there is no rating to that movie.
Please tell me how to normalize it.. original rating in scale of 1 to 13
the new rating that needed in the program is 1 to 5.
Best Answer
You can use the standard re-scaling formula, i.e. $value_{new} = \frac{max_{new} - min_{new}}{max_{old} - min_{old}}\times (value_{old} - max_{old}) + max_{new}$.
In your case, that would be $\frac{5-1}{13-1} \times (value_{old} - 13) + 5$. And $value_{old} = 0 = value_{new}$.