Purpose
The AddIn provides a GUI to automatically create normalized columns.
e.g.: weight normalized by weight of a typical 15year old boy/girl.
How to Use
Open the GUI via Cols/normalize , adjust all settings as you like, then click Apply.
GUI
Details
- Click on Explain the GUI to get a tour of the available features.
- Recall populates the GUI entries with the previous settings.
Columns can be used as:
- columns to normalize: generate a new, normalized column for each column in the list
- group by: different items are normalized separately, e.g. sex: different normalization values for male and female
- subset selection: to pick a "reference subset", e.g. normalize by values of 15 year old students
alternative applications: normalize by 0h data, by reference data, ...
Settings
- normalize via divide or subtract
- how to aggregate multiple values: median, mean, first value ... new: N-1 = Diff (with grouping option)
The new column can be produced by (just) calculating the values or by generating a Formula Column.
Default setting: Formula which is calculated once and then deactivated.
System Configuration
Add-in developed and tested using the following system configuration:
Developed with JMP 17.1.
Tested with JMP 16-17.2.
This AddIn was triggered by a comment from @mia_stephens in a reply to a Wish List entry:
known restriction:
- subset selection doesn't work for columns with value labels (will be fixed with the next release)
to do:
- add lag option