Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
tbps
Level II

Bubble Plot showing proportionate data

Hi community, 

 

I have got the following problem and maybe someone can help out: I have a dataset which contains several tests (X4) and the according engine speed and power values. Now I would like to create a bubble plot showing the retention time for speed and power for each single test. The data should be binned for X2 in bins of 500 and X3 in bins of 10. This would then give me an overview of the exact portion in relation of the total testtime. 

First question: Is something like this possible? Second question: how do I do it?

 

Thanks for your help.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Byron_JMP
Staff

Re: Bubble Plot showing proportionate data

I couldn't help myself, this data set is just too tasty.

 

Add these two formulas to your table:

 

Batch Change Flag

If( Row() == 1,
	1,
	If( :Time == 0, 1, . )
)

Batch ID

If( Row() == 1,
	1,
	If( Is Missing( :Batch Change Flag ) == 1,
		Lag( :Batch ID, 1 ),
		Lag( :Batch ID, 1 ) + 1
	)
)

 

This will let you run this script

Bubble Plot(
	X( :X__3 ),
	Y( :X__2 ),
	Time( :Time ),
	Coloring( :X__6 ),
	ID( :Batch ID ),
	Speed( 220 ),
	Bubble Size( 10.89 ),
	Time Index( 30432 ),
	Color Theme( "Yellow to Blue" ),
	Color Levels(
		[-0.872 8.32714285714286 17.5262857142857 26.7254285714286 35.9245714285714
		45.1237142857143 54.3228571428571 63.522 72.7211428571429 81.9202857142857
		91.1194285714286 100.318571428571 109.517714285714 118.716857142857 127.916]
	),
	Title Position( -70.25, 3900 ),
	SendToReport(
		Dispatch(
			{},
			"1",
			ScaleBox,
			{Format( "Fixed Dec", 12, 0 ), Min( -100 ), Max( 75 ), Inc( 50 ),
			Minor Ticks( 1 )}
		),
		Dispatch(
			{},
			"2",
			ScaleBox,
			{Format( "Fixed Dec", 12, 0 ), Min( 500 ), Max( 4500 ), Inc( 500 ),
			Minor Ticks( 0 )}
		)
	)
)

Turn the speed up to 100%

JMP Systems Engineer, Pharm and BioPharm Sciences

View solution in original post

6 REPLIES 6
Highlighted
Byron_JMP
Staff

Re: Bubble Plot showing proportionate data

the rounding/binning part can be done with a formula like this

Floor(:X__2 / 500) * 500

You might also need to bin the 15 or so experiments so they can be overlayed (ID role in bubble plot)

JMP Systems Engineer, Pharm and BioPharm Sciences
Highlighted
Byron_JMP
Staff

Re: Bubble Plot showing proportionate data

one minor thing. this is a pretty tall table, the formula will take a few sec to update the table
JMP Systems Engineer, Pharm and BioPharm Sciences
Highlighted
Byron_JMP
Staff

Re: Bubble Plot showing proportionate data

I couldn't help myself, this data set is just too tasty.

 

Add these two formulas to your table:

 

Batch Change Flag

If( Row() == 1,
	1,
	If( :Time == 0, 1, . )
)

Batch ID

If( Row() == 1,
	1,
	If( Is Missing( :Batch Change Flag ) == 1,
		Lag( :Batch ID, 1 ),
		Lag( :Batch ID, 1 ) + 1
	)
)

 

This will let you run this script

Bubble Plot(
	X( :X__3 ),
	Y( :X__2 ),
	Time( :Time ),
	Coloring( :X__6 ),
	ID( :Batch ID ),
	Speed( 220 ),
	Bubble Size( 10.89 ),
	Time Index( 30432 ),
	Color Theme( "Yellow to Blue" ),
	Color Levels(
		[-0.872 8.32714285714286 17.5262857142857 26.7254285714286 35.9245714285714
		45.1237142857143 54.3228571428571 63.522 72.7211428571429 81.9202857142857
		91.1194285714286 100.318571428571 109.517714285714 118.716857142857 127.916]
	),
	Title Position( -70.25, 3900 ),
	SendToReport(
		Dispatch(
			{},
			"1",
			ScaleBox,
			{Format( "Fixed Dec", 12, 0 ), Min( -100 ), Max( 75 ), Inc( 50 ),
			Minor Ticks( 1 )}
		),
		Dispatch(
			{},
			"2",
			ScaleBox,
			{Format( "Fixed Dec", 12, 0 ), Min( 500 ), Max( 4500 ), Inc( 500 ),
			Minor Ticks( 0 )}
		)
	)
)

Turn the speed up to 100%

JMP Systems Engineer, Pharm and BioPharm Sciences

View solution in original post

Highlighted
tbps
Level II

Re: Bubble Plot showing proportionate data

Thanks Byron, just worked out fine for me.
Highlighted
tbps
Level II

Re: Bubble Plot showing proportionate data

Hi Byron,

one more question: if I now want to compare the various batches, seeing batch 1 as the "normal" - how do I do this? Or putting this question more general: In a dataset with various batches, how can I normalize the values (seeing batch 1 as the normal?)
Highlighted
Byron_JMP
Staff

Re: Bubble Plot showing proportionate data

To do an ANOVA with a control, use Dunnett's in the compare means option.

Here's an example.

https://www.jmp.com/support/help/en/15.1/index.shtml#page/jmp/example-of-the-with-control-dunnett-te...

 

If you google JMP, Dunnett's or Dunnett test you'll find a ridiculous number of references and youtube videos too

JMP Systems Engineer, Pharm and BioPharm Sciences
Article Labels