topic Re: Help to develop script for normalized calcualtion in Discussions

Help to develop script for normalized calcualtion

raj138 — Tue, 13 Aug 2019 19:10:01 GMT

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

Re: Help to develop script for normalized calcualtion

Thierry_S — Tue, 13 Aug 2019 21:26:09 GMT

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)?

Re: Help to develop script for normalized calcualtion

raj138 — Tue, 13 Aug 2019 22:15:42 GMT

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

Re: Help to develop script for normalized calcualtion

txnelson — Wed, 14 Aug 2019 00:57:43 GMT

You can calculate the standard scores by the following:

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
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

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

Re: Help to develop script for normalized calcualtion

raj138 — Mon, 19 Aug 2019 21:30:22 GMT

Thank you Jim.