View Single Post
  #1   Report Post  
Randy Mis Randy Mis is offline
Junior Member
 
Posts: 6
Default Distribution between two limits

Does anyone know how to write a formula to distribute automatically a set of results between two limits?

Example:
66.02
20.3
70
38.605
37.87
79.835
74.33
41.455
103.525

I would like the above answers to be distributed between 1 and 100 based on how far they are from the mean of the group or some other variable, which does not really matter.

Any thoughts? Thanks