nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to plot Count of values of Nominal data vs. Continuous data

Jakedahsnake

Hi there, I have a question on how to model some data I am looking at (JMP 11).

End goal: Display a Chart that shows Count of values of a Nominal Data Column (X) Vs. Continuous Data Column (Y).

Further in the weeds:

I have a Nominal Data Column: DieNumber.

And a Continuous Data Column: ResDelta.

I want to display the count of each DieNumber (ex: 1, 2, 3) displayed on the X axis instead of each DieNumber value, but in Graph Builder switching the summary statistic to N when ResDelta (Continuous) is plotted on the Y axis is summarizing Y and not summarizing the counts of each value of X.

The only workaround I've found is using the Overlay Plot function, associating ResDelta as \[Y\], associating DieNumber as \[By\], but this splits out each chart individually when I want the data all in one chart.

Really struggling with this so any help would be appreciated, thanks!

Accepted answers

Aah, thank you ask this example clarifies your use case! If I understand correctly, you want all of the individual track times plotted as separate points, not just a single point representing both of Tim's runs. I would approach this by making a column counting the number of times each person ran around the track so far, and then just plotting that against Calories Burned.

The formula for the times around track column could look like this (note how it just sums the number instead of having a column reference in the first argument):

Script to recreate chart:

Names default to here(1);

dt = New Table( "Count Table",
	Add Rows( 11 ),
	New Column( "Name", Character, "Nominal",
		Set Values( {"Tim", "Tim", "Alex", "Alex", "Alex", "Alex", "Sara", 
			"Sara", "Sara", "Sara", "Sara"} ) ),
	New Column( "Calories Burned", Numeric, "Continuous", Format( "Best", 12 ),
		Set Values( [75, 155, 60, 130, 195, 240, 65, 125, 180, 235, 280] ) ),
	New Column( "Times around Track", Numeric, "Continuous", Format( "Best", 12 ),
		Formula( Col Cumulative Sum( 1, :Name ) ) )
);

g = dt << Graph Builder(
	Size( 534, 456 ),
	Show Control Panel( 0 ),
	Variables( X( :Times around Track ), Y( :Calories Burned ), Overlay( :Name ) ),
	Elements( Points( X, Y, Legend( 13 ) ), Smoother( X, Y, Legend( 15 ) ) )
);

Names default to here(1); dt = New Table( "Count Table", Add Rows( 11 ), New Column( "Name", Character, "Nominal", Set Values( {"Tim", "Tim", "Alex", "Alex", "Alex", "Alex", "Sara", "Sara", "Sara", "Sara", "Sara"} ) ), New Column( "Calories Burned", Numeric, "Continuous", Format( "Best", 12 ), Set Values( [75, 155, 60, 130, 195, 240, 65, 125, 180, 235, 280] ) ), New Column( "Times around Track", Numeric, "Continuous", Format( "Best", 12 ), Formula( Col Cumulative Sum( 1, :Name ) ) ) ); g = dt << Graph Builder( Size( 534, 456 ), Show Control Panel( 0 ), Variables( X( :Times around Track ), Y( :Calories Burned ), Overlay( :Name ) ), Elements( Points( X, Y, Legend( 13 ) ), Smoother( X, Y, Legend( 15 ) ) ) );

txnelson

If you sort your data by "Name" (Using @ih example), the following formula will give you the Column Cumulative Sum in JMP 11

If(Lag(:Name) != :Name | Row() == 1, x = 0); 
x++; 
x

All comments

statman

First, welcome to the community. I'm not sure I understand the issue, but I have attached a fake data set with fake numbers for two variables Die and ResDelta. I have saved a script for Graph Builder (green arrow). Just click on it. Is this what you are looking for? BTW, I'm on V17 so not sure it will work on V11... so here is the script:

Graph Builder(
	Variables( X( :Die ), Y( :ResDelta ) ),
	Elements( Points( X, Y, Legend( 5 ) ) )
)

dieexample.jmp

Jakedahsnake

Thank you for the warm welcome and I appreciate your time looking in to this! I plotted the variables on X and Y how I think it should be, and here is what I see:

This is almost correct, except for each X (ChipDieNum) there can be multiple Y values (ResDelta). Instead of plotting the X values, I want to plot the counts of each X (ChipDieNum) value.

As mentioned previously, X is set to Nominal and Y is Continuous.

Under Points, try changing the summary statistic to 'N':

I think this gives what you are looking for:

Script to recreate:

Names Default To Here( 1 );

dt = Open( "$Sample_data/big class.jmp" );

win = New Window("Example",
	H List Box(
		Graph Builder(
			Size( 503, 256 ),
			Show Control Panel( 0 ),
			Variables( X( :age ), Y( :height ) ),
			Elements( Points( X, Y, Legend( 3 ), Summary Statistic( "N" ) ) )
		),
		Tabulate(
			Show Control Panel( 0 ),
			Add Table( Row Table( Grouping Columns( :age ) ) )
		)
	)
);

Names Default To Here( 1 ); dt = Open( "$Sample_data/big class.jmp" ); win = New Window("Example", H List Box( Graph Builder( Size( 503, 256 ), Show Control Panel( 0 ), Variables( X( :age ), Y( :height ) ), Elements( Points( X, Y, Legend( 3 ), Summary Statistic( "N" ) ) ) ), Tabulate( Show Control Panel( 0 ), Add Table( Row Table( Grouping Columns( :age ) ) ) ) ) );

Jakedahsnake

I've tried doing that, but for some reason JMP is summarizing Y (I guess since it is continuous data) instead of summarizing N for X, so I end up getting a different graph:

While this is showing the counts of the ChipDieNumber, it's now plotting on the Y in place of ResDelta.

Victor_G

Hi @Jakedahsnake,

Like other members have tried to find solutions to your problem, I will try another one, based on the discussions.

In order to create the graph attached, here are the steps :

Create a new column "Count" by Die ID :

// New formula column: Count
Data Table( "dieexample" ) << New Formula Column(
	Operation( Category( "Aggregate" ), "Count" ),
	Columns( :ResDelta ),
	Group By( :Die )
);

Create a graph showing the distribution of ResDelta depending on the number of points, with the information of Die ID in "Overlay" and boxplots to facilitate the comparison (optional, and might be messy if you have a large dataset):

Graph Builder(
	Size( 984, 474 ),
	Show Control Panel( 0 ),
	Variables( X( :Count ), Y( :ResDelta ), Overlay( :Die ) ),
	Elements( Points( X, Y, Legend( 10 ) ), Box Plot( X, Y, Legend( 12 ) ) ),
	SendToReport(
		Dispatch(
			{},
			"400",
			LegendBox,
			{Legend Position(
				{10, [0, 1, 2, 3, 4], 12, [-1, -1, -1, -1, -1, -3, -3, -3, -3, -3]}
			)}
		)
	)
);

Once this is done, you should get to the graph attached (I added boxplots in the graph and script, but you can remove them if this is not useful for your objective):

I also attached the dataset I used for demonstration with graph script attached.

Hope this will help you,

dieexample.jmp

Community_graph.png

Jakedahsnake

Thanks for the help everyone, if this clarifies things I would like to present a similar problem that might be easier to understand.

Example Problem:

Tim, Alex, & Sara run around a track. After each lap, a measurement is taken of Calories burned.

Tim ran around the track 2 times with Calories Burned: 75, 155 resepectively.

Alex ran around 4 times with calorie measurements of: 60, 130, 195, & 240 cal.

Sara ran around 5 times with measurements of: 65, 125, 180, 235, & 280 cal.

How do I plot (# of times ran around) vs. (Calories Burned)?

To relate this back to my problem:

(Nominal) Names = ChipDieNum,

(Nominal) # of times ran around = Count of ChipDieNum,

(Continuous) Calories Burned = Delta Res.

For the record I have 8,000+ data entries that I would like to model.

The formula for the times around track column could look like this (note how it just sums the number instead of having a column reference in the first argument):

Script to recreate chart:

Names default to here(1);

dt = New Table( "Count Table",
	Add Rows( 11 ),
	New Column( "Name", Character, "Nominal",
		Set Values( {"Tim", "Tim", "Alex", "Alex", "Alex", "Alex", "Sara", 
			"Sara", "Sara", "Sara", "Sara"} ) ),
	New Column( "Calories Burned", Numeric, "Continuous", Format( "Best", 12 ),
		Set Values( [75, 155, 60, 130, 195, 240, 65, 125, 180, 235, 280] ) ),
	New Column( "Times around Track", Numeric, "Continuous", Format( "Best", 12 ),
		Formula( Col Cumulative Sum( 1, :Name ) ) )
);

g = dt << Graph Builder(
	Size( 534, 456 ),
	Show Control Panel( 0 ),
	Variables( X( :Times around Track ), Y( :Calories Burned ), Overlay( :Name ) ),
	Elements( Points( X, Y, Legend( 13 ) ), Smoother( X, Y, Legend( 15 ) ) )
);

All comments

Quick Links