Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

- JMP User Community
- :
- Discussions
- :
- Bubble Plot showing proportionate data

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Highlighted

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Jun 18, 2020 4:47 AM
(798 views)

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Created:
Jun 18, 2020 9:29 AM
| Last Modified: Jun 18, 2020 10:56 AM
(763 views)
| Posted in reply to message from Byron_JMP 06-18-2020

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

6 REPLIES 6

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Created:
Jun 18, 2020 9:29 AM
| Last Modified: Jun 18, 2020 10:56 AM
(764 views)
| Posted in reply to message from Byron_JMP 06-18-2020

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

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Re: Bubble Plot showing proportionate data

Thanks Byron, just worked out fine for me.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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?)

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
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

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.

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