- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
How to save custom quantiles to a table
Hello,
I have a continuous variable which I broke down using a custom quantile (instead of normal quantile, default in JMP). My custom quantile is 0%, 25%, 50%, 75% and 100%. The distribution platform shows the output but how can I save this to a table? If I click the red triangle --> save, I only see the option to save default JMP normal quantiles only.
Any ideas about how I can save the custom quantiles rather than the default JMP normal quantiles?
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to save custom quantiles to a table
Right-click on the table with the quantiles and select Make Into Data Table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to save custom quantiles to a table
Mark, Appreciate the reply. I was looking for a solution to add quartiles to the main data table. This was I can work on the base dataset along with quartiles. I can definitely use your solution and then create a formula column.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to save custom quantiles to a table
How do you write this action into a script?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Report Inappropriate Content
Re: How to save custom quantiles to a table
Let JMP script it for you (if you have JMP16+ even easier)
1. Open your table
2. Create your distribution
3. Right click on the Quantiles table box and Make into Data table
Slightly Script from Enhanced log:
Names Default To Here(1);// Open Data Table: Big Class.jmp
// → Data Table("Big Class")
Open("$SAMPLE_DATA/Big Class.jmp");
// Launch platform: Distribution
Data Table("Big Class") << Distribution(Continuous Distribution(Column(:weight)));
// Make TableBox into a Data Table
// → Data Table("Untitled")
Local({obj},
obj = Data Table("Big Class") << Distribution(
Continuous Distribution(Column(:weight))
);
Report(obj)["weight", "Quantiles", Table Box(1)] << Make Into Data Table;
obj << Close Window;
);
The script can be "auto"built without enhanced log but you have to collected the scripts from different places (from distribution platform and from result tables table script)