Capability Analysis:Count of samples beyond Upper & Lower Limit instead of PPM or Percetage

chewchan0

Hi,

I am trying to get the Count of samples that are fall above Upper limit and Lower Limit in Capability Indices。

（http://www.jmp.com/support/help/Capability_Platform_Options.shtml）

However, in the capability indices report table it only able to show PPM.  In my case I cannot use PPM because I am stacking few columns with same limit in one single column.  This will make the PPM calculation wrong

Is there any way that can use script the to retrieved the count so that I can recalculate in another data table?

txnelson

The Count of the Samples can be indirectly calculated.  The count is not specified, but the Portion is specified.  So if the N is multiplied by the Portion value, you will get the Count of the Samples.

Interactively, this can be done by right clicking on the table and selecting Make into Data Table.  Then simple create a new column in the new data table, and specify the formula

      % Actual * xxxxx

where xxxxx is the value of N from the Summary Statistics paragraph

The following is an example of scripting what you want:

Names Default To Here( 1 );

dt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );

dt << dis = Distribution(

       Continuous Distribution( Column( :PNP3 ) ),

       SendToReport( Dispatch( {"Distributions", "PNP3", "Capability Analysis"},

       " Long Term Sigma", OutlineBox, {Close( 1 )} ) )

);

// Create the new data table

dtstats = Report( dis )["Capability Analysis"][1] << make into data table;

// Strip off the N value from the Summary Statistics table

Count = (Report( dis )["Summary Statistics"][1][1][2] << get)[6];

// Create the new column

dtstats << New Column( "Count of the Samples", formula( :Name( "% Actual" ) * count ) );

// Delete the formula to convert the results from virtual values to real values

dtstats:Count of the Samples << delete property( "Formula" );