topic Re: Simple Script to create distribution for all columns in a data table in Discussions

Simple Script to create distribution for all columns in a data table

Djtjhin — Fri, 09 Jun 2023 22:07:40 GMT

Is there a simple script that creates distribution of all the columns in a data table ?

Re: Simple Script to create distribution for all columns in a data table

dale_lehman — Sat, 06 Mar 2021 14:09:48 GMT

I'm sure someone will give you such a script - but why isn't the display that appears just below the variable name sufficient? And, if you want the statistics (e.g., means, standard deviations, etc.) you can use either the Column Viewer - summary or select all distributions and then make a combined data table. Of course, those scripts can be saved to the data table, so JMP will write the scripts (sorry, but I'm allergic to writing scripts if I can avoid them).

Re: Simple Script to create distribution for all columns in a data table

jthi — Sat, 06 Mar 2021 14:28:13 GMT

One way to do it:

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
//dt = Open("$SAMPLE_DATA/Semiconductor Capability.jmp");
colNames = dt << Get Column Names("String");
dist = Eval(EvalExpr(dt << distribution(Column(Expr(colNames)))));

But I would think @dale_lehman suggestion would be better in most cases. At least JMP15 provides distributions below column names

or use Column Viewer as it gives additional information in easy to see format and allows quick creation of distributions.

Re: Simple Script to create distribution for all columns in a data table

Djtjhin — Sun, 07 Mar 2021 08:32:53 GMT

Thanks @jthi & @dale_lehman.

A little bit of background before I explain why I'm going the scripting route. So I made a script which execute unique monte-carlo simulation for each row in a data table. But instead of saving the exact table of random samples created, I saved the script which generates the samples as strings which can be parsed in the future if needed. Though I lose the ability to save the exact table, but at least I avoid having to manage large datasets.

Now with the step above completed, what's missing is generating the distribution and that's the reason why I'm asking for a way to script the distributions. It's mainly to straightaway review the monte-carlo samples distribution.

Having that said, I am aware of the functionalities you mentioned and I agree that those approach are more ideal. However, I'm also building JMP tools which can help more folks within my organization to adopt JMP (which is admittedly so, still not much). Hopefully, as other users become more experienced, they realize other available JMP in-build tools which can help them analyze the data better.

Re: Simple Script to create distribution for all columns in a data table

Raaed — Tue, 09 Mar 2021 00:45:48 GMT

PLEASE, HOW TO GET THIS OUTPUT WITH OUT SCRIPTS.

Re: Simple Script to create distribution for all columns in a data table

Mark_Bailey — Tue, 09 Mar 2021 10:19:56 GMT

Open the data table.
Select Analyze > Distribution.
Select all the columns in the list on the left side.
Click Y.
Click OK.

Please see Distribution chapter in the Basic Analysis guide.