how to make cumulative probability plots in JMP?

[#1]

How can I make cumulative probability plot like the one below? Appreciate your help.

[#2]

These two topics might be helpful:

• Updating the Graph Builder's Element statement 
• Graph Builder JSL commands on Elements 

You might be able to use similar methods with Variables (search Graph Builder Box from Scripting Index).

[#3]

"remove variable" - just in front of my eyes, but I did not see it.

Many thanks

Names Default To Here( 1 );


dt = Current Data Table();


updatePlot2 = Function( {},
	If( Length( clb << get selected ) == 0 | Length( clb2 << get selected ) == 0,
		Print( "value missing" ),
		gbr = Report( gb );
		gbb = gbr[Graph Builder Box( 1 )];
		var = (clb << get selected)[1];
		groupByvar = (clb2 << get selected)[1];

		allVariables = (gbb << get variables);
		For Each( {var, idx}, Reverse( allVariables ),
			gbb << remove variable( {var[1] , Role(  Arg( var[2] ) )} )
		);

		gbb << add variable( {Column( var ), Role( "X" )} );
		
		Eval(
			Eval Expr(
				gbb << add variable(
					{Transform Column(
						"Cumulative Probability[1=100%]",
						Formula(
							Col Rank( Expr( Name Expr( As Column( var ) ) ), Expr( Name Expr( As Column( groupByvar ) ) ),Excluded() ) / (
							Col Number( Expr( Name Expr( As Column( var ) ) ), Expr( Name Expr( As Column( groupByvar ) ) ),Excluded() ) + 1)
						)
					), Role( "Y" )}
				)
			)
		);
		
		gbb << add variable( {Column( groupByvar ) , Role( "Overlay" )} ) ;
		
// SendToReport( Dispatch( {}, "Cumulative Probability[1=100%]", ScaleBox, {Scale( "Normal Probability" ), Format( "Best", 12 )} ) )
		yAxis = ((gb << xpath( "//ScaleBox" ))[2]);
		yAxis << {Scale( "Normal Probability" ), Format( "Best", 12 ), Title};
		
		gb << getXML();
		

		
		
	)
);


gbWindow = New Window( "Grouped Cumulative Probability",
	hlb = H List Box(
		V List Box(
			Panel Box( "Value", clb = Col List Box( all, <<Set Data Type( "numeric" ), max selected( 1 ), updatePlot2() ) ),
			Panel Box( "group by", clb2 = Col List Box( all, max selected( 1 ), updatePlot2() ) )
		),
		gb = dt << Graph Builder(
			Size( 724, 560 ),
			Show Control Panel( 0 ),
			Elements( Points( X, Y, Legend( 7 ) ), Smoother( X, Y, Legend( 8 ), Method( "Savitzky-Golay" ), Lambda( 2 ) ) ),
			SendToReport( Dispatch( {}, "Cumulative Probability[1=100%]", ScaleBox, {Scale( "Normal Probability" ), Format( "Best", 12 )} ) )
		)
	)
);

updates: 
- remove & add variable (Y) deletes the normal probability setting on this axis
->  send the normal probability   command again

- new problem: when running the "transform column" a second time and more often, jmp adds a counter to the name on the y axis: Cumulative Probability[1=100%] XX -> Y axis no longer accessible by its original name
-> get the y axis title via xPath

- Excluded() added in the Col... functions to force jmp to ignore excluded() rows in the calculation.

[#4]

-

[#5]

//librecall:storeRoles( "CDF", verbose );

I had to mute the librecall function since I get an error in JMP17. But it seems it works without it just fine.

Can we mark this as solved @r30363 ?

[#6]

Thanks, I removed it.

[#7]

Thanks for this great JSL code.

[#8]

Ouch -  sorry, unfortunately, the code doesn't do what it should do.

Cumulative Percent sounded like Cumulative Probability [%] , but unfortunately, it doesn't sum ONES and dive by N, it sums the individual values and divides by the sum of all values:

If the values are "similar", it's a quick hack to get something similar to CDF, but e.g. if the values start from 0 - or are even negative, the plot differs significantly from a CDF.

So close - but too far to fix it, right?

dt = Open( "$SAMPLE_DATA/Airline Delays.jmp" );
dt << Graph Builder(
	Variables( X( :Arrival Delay ), Y( :Arrival Delay ), Overlay( :Airline ) ),
	Elements(
		Points( X, Y, Legend( 6 ), Summary Statistic( "Cumulative Percent" ) )
	)
);

[#9]

I posted a wish to add Cumulative Probability as an additional option for summary Statistics in Graph Builder:
Summary Statistics: add Cumulative Probability 

So, perhaps in Jmp18 it will be THAT EASY to generate a grouped Cumulative Probability Plot in Graph Builder.

The huge advantage compared to https://community.jmp.com/t5/Discussions/how-to-make-cumulative-probability-plots-in-JMP/m-p/607570/... :It would be compatible with the Column Switcher Feature of Graph Builder. No need to generate a GUI around the plot.

[#10]

@hogi :

[#11]

@Mauro Thanks a lot for the Kudo - an also for the other 3.
With 4 Kudos this feature should be kind of save to appear in a future Jmp version