Choose Language Hide Translation Bar
Highlighted

## Obtaining Statistics out of Statistics

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

## Re: Obtaining Statistics out of Statistics

Analyze>Tabulate for the interactive version.

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

## Re: Obtaining Statistics out of Statistics

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 )
)
)
);`````` Jim
Highlighted

## Re: Obtaining Statistics out of Statistics

Analyze>Tabulate for the interactive version.

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

## Re: Obtaining Statistics out of Statistics

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:

Analyze>Tabulate for the interactive version.

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

Analyze>Tabulate for the interactive version.

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

Gary

Highlighted

## Re: Obtaining Statistics out of Statistics

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

Highlighted

## Re: Obtaining Statistics out of Statistics

Got it to work! Thanks a lot Karen!