Normalizing and averaging ranges

[cm]

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.

[Channa]

all those measures are calculated??

if not

just do

sum(TOTAL Score)/number of columns (8)

[cm]

Channa,

Yes, all measures are calculated. Far right column is a Rangeavg function of all other columns.

[Channa]

Why don't you use column1 + column 2+ column 3.../8

[cm]

Channa,

I’ve already got a Rangeavg for the columns. That average is found in the far right column. I don’t need to average to columns, rather the rows in a single column (far right).