Choose Language Hide Translation Bar
raj138
Occasional Contributor

Help to develop script for normalized calcualtion

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 

0 Kudos
1 ACCEPTED SOLUTION

Accepted Solutions
txnelson
Super User

Re: Help to develop script for normalized calcualtion

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

Jim

View solution in original post

4 REPLIES 4
Thierry_S
Community Trekker

Re: Help to develop script for normalized calcualtion

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)?
Thierry R. Sornasse
0 Kudos
Highlighted
raj138
Occasional Contributor

Re: Help to develop script for normalized calcualtion

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

0 Kudos
txnelson
Super User

Re: Help to develop script for normalized calcualtion

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

Jim

View solution in original post

raj138
Occasional Contributor

Re: Help to develop script for normalized calcualtion

Thank you Jim.

0 Kudos