cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
statslearner
Level II

Normalizing the Idata in second data sheet using Data in first Data sheet

Hi

 

This is regarding normalizing one dataset and applying the same normalization to other dataset.

Either i apply z score or min-max on one dataset or z score standardization. After normalizing the first dataset, I apply the same formulas to the second dataset using Excel's cell referencing and fill handle.

 

here are the two JMP datasets for example. How can i do this in JMP?

 

please help

Thanks

 

 

 

1 REPLY 1
txnelson
Super User

Re: Normalizing the Idata in second data sheet using Data in first Data sheet

You can turn the recording on for a workflow as you normalize the first data table, and then simply run the workflow on the second data table.

 

If this does not meet your needs, please provide more specifics and I am sure the Community will be able to help you.

Jim

Recommended Articles