Help to develop script for normalized calcualtion

[#1]

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.

 @txnelson 

[#2]

Hi Raj,
Assuming that you have JMP14, have you tried the "Standardize" option in the "New Formula Column > Distribution" menu (accessible by right-clicking on the columns containing your raw scores)?

[#3]

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

[#4 · Accepted solution]

You can calculate the standard scores by the following:

1. Create a summary data table 
   1. Tables==>Summary
      1. Specify to create the mean, standard deviation
      2. Group by the column that identifies each person
2. Once the new table is created, go back to the original data table and
   1. Tables==>Join
      1. Match based upon the column that identifies each person

1. In the new table that is created, create a new column
   1. use the formula  (:value-:mean)/:standard deviation

This will create the standardized value for each persons data

[#5]

Thank you Jim.