cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
lala
Level IX

Can JMP achieve a ready quantile at 115 weight?

Can JMP achieve a ready quantile at 115 weight?

2024-01-23_17-00-48.png

2 REPLIES 2
lala
Level IX

回复: Can JMP achieve a ready quantile at 105 weight?

Thanks!

dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
d2 = dt << Summary(
	Quantiles( 25, 5 ),
	Quantiles( 50, 5 ),
	Quantiles( 75, 5 ),
	Freq( 0 ),
	Weight( 0 ),
	Link to original data table( 0 )
);

回复: Can JMP achieve a ready quantile at 105 weight?

You could do trial-and-error, but that would be tedious. The only other way that I can see to do this is to fit a distribution to the data, and then use the Quantile Profiler with a desirability function to find the quantile level. For the situation you proposed, I fit a smooth curve to the data and the results looked like this:

Big Class - Distribution of weight.png

Of course different distributions will give slightly different results, but it is the only way that I can see to determine the proper quantile level. 

Since you had results in a script, here is the script to match my results:

Distribution(
	Continuous Distribution(
		Column( :weight ),
		Fit Smooth Curve(
			Quantile Profiler(
				1,
				Confidence Intervals( 1 ),
				Desirability Functions( 1 ),
				Smooth Curve Quantile <<
				Response Limits(
					{Lower( 38.2411401370744, 0.0183 ), Middle( 115, 1 ),
					Upper( 200, 0.0183 ), Goal( "Match Target" ), Importance( 1 )}
				),
				Term Value(
					Probability(
						0.685484294268159,
						N Levels( 200 ),
						Lock( 0 ),
						Show( 1 )
					)
				)
			)
		)
	),
	SendToReport(
		Dispatch( {"weight"}, "Quantiles", OutlineBox, {Close( 1 )} ),
		Dispatch( {"weight"}, "Summary Statistics", OutlineBox, {Close( 1 )} )
	)
);
Dan Obermiller

Recommended Articles