Relative Content

Tag Archive for excelrangeaverage

How to spread a narrow range of values into a wider “score range”?

I have generated a series of percentages to summarize the performance of various counties across the country based on a few metrics. I’d like to use these “County Percentage” values to give each county a “Final Score” (1-100). However, the range of these values is only ~25, and the max/min is 53/78 respectively.