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; } } }

Obtaining Statistics out of Statistics

bgeaibreyi

Hi,

I have a group of process performance data and distribution grouped by condition. I am looking for an efficient way to calculate min, max, mean and std dev of the range of each condition group of data. Is there any platform in JMP that can do this?

Thanks,

Gary

Process Capability Study.jmp

Accepted answers

KarenC

How about tabulate?

Analyze>Tabulate for the interactive version.

For your data:

Tabulate(
	Add Table(
		Column Table(
			Analysis Columns( :Performance ),
			Statistics( Mean, Std Dev, Min, Max, Range )
		),
		Row Table( Grouping Columns( :Condition ) )
	)
);

All comments

txnelson

You can easilty use the Summary platform to calculate the various ranges, and then the Distribution platform to give you the Mean, Min, etc. on the ranges.

Here is a simple example, using the Semiconductor Capabiltiy data table

names default to here( 1 );
dt = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp" );

dtSummary = dt << Summary(
	invisible,
	Group( :lot_id ),
	Range( :NPN1 ),
	Freq( "None" ),
	Weight( "None" )
);

dtSummary << Distribution(
	Continuous Distribution(
		Column( :Name( "Range(NPN1)" ) ),
		Customize Summary Statistics(
			Std Err Mean( 0 ),
			Upper Mean Confidence Interval( 0 ),
			Lower Mean Confidence Interval( 0 ),
			N( 0 ),
			Minimum( 1 ),
			Maximum( 1 )
		)
	)
);

KarenC

How about tabulate?

Analyze>Tabulate for the interactive version.

For your data:

Tabulate(
	Add Table(
		Column Table(
			Analysis Columns( :Performance ),
			Statistics( Mean, Std Dev, Min, Max, Range )
		),
		Row Table( Grouping Columns( :Condition ) )
	)
);

bgeaibreyi

Thanks Karen, the tabulate format does what I want. Can I bypass the scripts and just use the front-end platform to create this?

@KarenC wrote:
How about tabulate?

Analyze>Tabulate for the interactive version.

For your data:
Tabulate(
	Add Table(
		Column Table(
			Analysis Columns( :Performance ),
			Statistics( Mean, Std Dev, Min, Max, Range )
		),
		Row Table( Grouping Columns( :Condition ) )
	)
);

Thanks,

Gary

KarenC

Most definelty you can skip the JSL!!!

Go to Analyze>Tabulate.

Drag the condition into the left drop zone, drag the preformance into where you now see the 423s, then select the measures you want and drag them to where you now see "Sum". There are options to update the format, etc. Tabulate has a bit of learning curve - explore and you will figure it out. The documentation is here:

https://www.jmp.com/support/help/14/tabulate.shtml

bgeaibreyi

Got it to work! Thanks a lot Karen!