273456_en-US

liliconcom

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.

 

GraphicsRe: 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)

Re: Bubble Plot showing proportionate dataone minor thing. this is a pretty tall table, the formula will take a few sec to update the tableRe: 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%

Re: Bubble Plot showing proportionate dataThanks Byron, just worked out fine for me.Re: Bubble Plot showing proportionate dataHi 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?)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-test.shtml#ww854167

 

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