cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Thomas1
Level V

JSL Dialog Box Modal window for Oneway analysis

Goal

Getting a summary data table from reports of statistical tests with the Oneway analysis platform.

 

Question

How to create a  dialog box - via JSL - to transfer data into the Oneway analysis platform. The dialog box should contain the yellow marked fields in the screenshot. The „Y, Response“ should be able to get more than one column.

DialogBox.JPG

@martindemel

10 REPLIES 10
Byron_JMP
Staff

Re: JSL Dialog Box Modal window for Oneway analysis

here's an example that might be useful to work from

 

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Consumer Preferences.jmp" );
cd=Column Dialog(
	exy =
	ColList( "Y",
		Min Col( 1 ),
		Max Col( 10 ),
		Data Type( "Numeric", "Continuous" )
	),
	exx =
	ColList( "X",
		Min Col( 1 ),
		Max Col( 10 ),
		Modeling Type(
			{"Nominal"}
		)
	),
	exby =
	ColList( "By",
		Min Col( 1 ),
		Max Col( 10 ),
		Modeling Type(
			{"Nominal"}
		)
	)

);

show(cd);
eval(cd[1]);eval(cd[2]);eval(cd[3]);
  //evaluate the variables from the list of things that came from the dialog
yyy=expr(y());
xxx=expr(x());
ebyby=expr(By());
for (i=1, i<=nitems(exy), i++,
insert into(yyy, exy[i]));
for (i=1, i<=nitems(exx), i++,
insert into(xxx, exx[i]));
for (i=1, i<=nitems(exby), i++,
insert into(ebyby, exby[i]));

ow=expr(Oneway());
insert into(ow, evalexpr(yyy));insertinto(ow,evalexpr(xxx));insertinto(ow,evalexpr(ebyby));
show(ow);ow;
JMP Systems Engineer, Health and Life Sciences (Pharma)
Thomas1
Level V

Re: JSL Dialog Box Modal window for Oneway analysis

 

Hi Byron_JMP, Thanks for your reply, which was almost as fast as the speed of light. Your suggested Code looks very promising.

One question is remaining. Is it possible to change the „By“ field from required to optional by changing the statement  = ColList( "By", Min Col( 1 ),  to = ColList( "By", Min Col( 0), ?

 

Regards

Thomas

Byron_JMP
Staff

Re: JSL Dialog Box Modal window for Oneway analysis

I'm not sure, Id have to dig around a little for that.  Since it's a modal window, I think it's going to want something before you can pass.  Maybe it would work to have a radio box in the dialog to append a by column row if its needed.

 

Maybe the bigger question I should ask is, Why do you want to remake the Fit Y by X launch dialog?

JMP Systems Engineer, Health and Life Sciences (Pharma)
Thomas1
Level V

Re: JSL Dialog Box Modal window for Oneway analysis

I 'd like to remake the Fit Y by X launch dialog to get from a starting table like:

 

GroupData1Data2Data3
A0,51328808180,74230249380,4106620047
A0,18018312710,401593810,9915244431
A0,79319573350,42330107320,3309875351
A0,30915372250,33528191760,2196420115
A0,38433301930,17740215780,7153274983
A0,29847677020,80725659080,4388054716
B0,21015190760,96757798210,0814124624
B0,95914693070,88013806620,2855633474
B0,94099545630,9975017950,5214475685
B0,21493542270,46450884790,3818163048

B

0,39278845770,29598166530,333390039

 

A statistical summary table like:

 

Data

Mean

Group A

Std. Dev

Group A

Mean

Group B

Std. Dev

Group A

P-Value

t-Test

P-Value

F-Test

Data1      
Data2      
Data3      
Thomas1
Level V

Re: JSL Dialog Box Modal window for Oneway analysis

I have to reply my answer, because the table format looks messy. 

 

I 'd like to remake the Fit Y by X launch dialog to get from a starting table like the attached data.xls in order to get a statistical summary table like the attached StatisticalSummary.xls file.

Byron_JMP
Staff

Re: JSL Dialog Box Modal window for Oneway analysis

Is the goal to make a dialog to generate  a table like this (see result of script)

open the table and then run the scrip. Its not very dynamic 

 

BTW, the script might look impressive if you are newer to JSL, but its like 5 min of copy and paste

I started with your table, stacked it then ran the platform to get the stats, then made the report into some tables and formatted them together.

JMP Systems Engineer, Health and Life Sciences (Pharma)
Thomas1
Level V

Re: JSL Dialog Box Modal window for Oneway analysis

Yes, the goal is to get a table similar to your table from your "first table grinder.jsl" script. I did create an other script "StatisticalSummaryTable.jsl" which delivers also a summary table from the "First Table.jmp"

However my final goal is to combine the summary script with the column dialog script above, in order to select column from a raw data table and getting a statistical summary reported as a final table.

I’m trying to achieve this with your column dialog script.

But I don't whether this will work or fell into pieces in case it is applied to different data tables.

Byron_JMP
Staff

Re: JSL Dialog Box Modal window for Oneway analysis

Ah, I see where you're going.

 

in the example I sent, the first step was to stack the columns with the "Data1.." labels.

That way I can use the new column label for "Data1.." in the report without prior knowledge of how many levels of "Data1.." exist in the original table. 

 

Maybe in your dialog, you could have the user select the group, data and "Data1.." columns. Then the workflow could run through a single path.  Iterating the report for each level of (or column of) "Data1.." could potentially add a lot of complexity to your script. (IMHO)

JMP Systems Engineer, Health and Life Sciences (Pharma)
SpannerHead
Level III

Re: JSL Dialog Box Modal window for Oneway analysis

Very helpful script.  Is there a way to have the exby input be optional?  Also, how difficult is it to add the recall feature to this?