Hello,
Could I get some help to develop a script which can calculate a normalized score. For example, in the attached sheet I have point scores for 5 people. It is difficult to compare them as is since each person's score seem to be on a different scale.
I would therefore normalize the data and compare. First, I compute the average score for each person and then divide each person's score with his average to come up with the normalized score, this is what is in the normalized points column. This is a tedious job if the size of the data set is large.
I was wondering if I can get some help to do this.
You can calculate the standard scores by the following:
This will create the standardized value for each persons data
Hi Thierry,
It doesn't give me what I want since the calculation considers the whole data set at one. For example, it computes the average for all the values and uses it to standardize the data. What I want to do is that the average be computed for each person individually and use it to standardize the data for that particular person.
-Raj
You can calculate the standard scores by the following:
This will create the standardized value for each persons data
Thank you Jim.