Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Brilliant minds,
Taking a look at the attached photo, two questions...
1. What's the best way to normalize all of these scores to a scale of 0-100 ?
2. I'm using Rangeavg([COMPEX Score], [OFTD Score], [Search], [Seizure Score], [Admissibility Score], [SIR Score], [Wait Time Score]) to get the number in the far-right column, i.e. Performance Rating. What's the best way to get a column average for the Performance Rating? Is it possible to get an average of a range average?
THANKS.
all those measures are calculated??
if not
just do
sum(TOTAL Score)/number of columns (8)