cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

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

Normalize across trials using controls

I have a datasets of populations with a response. I triplicated the experiment, so I have 3 trials of data, but the response rate likely varies between trials. It is a hypoxia response rate, which is sensitive to things like humidity/temperature that I can't perfectly control. 

 

Each trial consists of a population with different treatments, plus empty vector controls. 

 

So like this, but with like 50 entries for each treatment/control per trial:

Trial                             Response

1 TreatmentX               999

1 Control                        576

2 TreatmentX               1111

2 Control                        700

3 TreatmentX              700

3 Control                        350

 

So for this example the treatment is always above control, but control varies alot. I was thinking of using Dunnetts test to see which treatments are different from control, but I want to normalize the data to account for the trial day differences. The population sizes vary so I can't just use the total average for each day, but I should be able to use my controls to normalize each trial. How do I do this in JMP?

1 REPLY 1
hogi
Level XIII

Re: Normalize across trials using controls

If it's just about calculating the ratio (or difference) per trial , you  can use the Normalization AddIn from https://marketplace.jmp.com/appdetails/Normalization+GUI 

 

e.g. with the settings:

- column to normalize : Response

- function: ratio or difference

- grouping: by trial

- subset: Control

[The default aggregation is median, which works well even with just a single control and is much faster than the other modes.]

hogi_0-1758002547114.png

 

Recommended Articles