normalizing data from 1 to 4

[Ronak Parekh]

hey guys,

I had a spreadsheet where I want to normalize data from 1 to 4 where data with higher number should be given weight of 4 and data with least number should be given weight of 1.

I tried one formula which is normalizing data from 0 to 4 but I would like that to happen from 1 to 4. Is that possible?

See attached file for example

 

[eibi]

Ronak,

I'm not a statistician - forgive me if I've misunderstood your post.

Are you asking how to normalize the data from 0 to 3 and then translate it up the scale by a value of 1?

I've tried to follow the model in the file you provided.

See attached.