BookmarkSubscribeRSS Feed
Choose Language Hide Translation Bar
juliaaline

Occasional Contributor

Joined:

May 18, 2018

Standardize reaction time data by participant

Dear community,

 

how do I standardize a variable (in this case reaction time data) by another variable (participant)? I tried by looking at the distribution of the first variable by the second variable but did not find such a function and the normal standardize function does not give the option to do it by another variable. Every help would be very much appreiciated!

 

Thanks in advance and kind regards,

 

juliaaline

1 REPLY 1
txnelson

Super User

Joined:

Jun 22, 2012

Re: Standardize reaction time data by participant

All you need to do to solve this issue, is to use the formula for standardizing the data.  The formula for the standardization contains column functions that have the "By" calculation.  So here is an example script that does what you want.  It is standardizing to a mean of 100 and and std of 10

 

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );

dt << New Column( "standard by sex",
	formula(
		new mean = 100;
		new STD = 10;
		((:height - Col Mean( :height, :sex )) / Col Std Dev( :height, :sex )) * new STD
		+new mean;
	)
);
Jim