Control Chart Builder with source data from multiple columns

sbiedrzycki

I like the visualization provided by the Control Chart Builder.  In particular I like the stacked Xbar-R plots in one figure, the built-in distribution with normal distribution fit overlay, and automatic control limits calculated overlaid on the charts.  Unfortunately, many different data sources I'm working with aren't entered in full to our JMP tables.  Mean, range and standard devivation are calculated at the source and only these final values are entered into our tables due to limitations in automation at the moment. 

 

I would like to use this data in building the control charts so that I can have a full Xbar-R or Xbar-S chart with the data from these source columns.  I've not had luck figuring out a way to do this - I can only get it to plot as an individual measurement with a moving range.  Is there a way that I can point it to the mean and range/standard deviation data columns to construct the charts from these sources?  Or will I have to write a custom script to mimic these plots?

 

I am somewhat familiar with JSL and could work through a script for this but it seems like it would be far more involved especially given the need to support many different data sources.  Being able to assemble the charts in the builder would be more user friendly for everyone on the team to work with.

 

Thanks,

Steve

cwillden

Hi @sbiedrzycki,

That's an interesting question.  I don't think that is an existing capability, but you can probably twist JMP's arm into doing what you want if you know how to compute the control limits yourself.  I imagine you have the means and standard deviations in separate columns.  You could do separate individuals charts on the means and standard deviations with custom control limits that you input into a control limits column property.  You just need to make sure to set the control limits for an individuals chart for both the mean and the standard deviation column.

Here's an example where I generated some individuals in groups of 5.  I created the control chart on the right with that data.  Then I did a summary to compute the mean and standard deviation for each subgroup.  In the summary table I input the correct control limits (again, you'll need to know the formulas to compute these on your own).  I was able to then create the control chart shown on the left from this table.  The charts are effectively the same.

I'm attaching the summary table so you can see how I input the control limits in column properties.  In Control Chart Builder, you'll need to remove the moving range chart (right-click in the mR chart area > Remove, not "Remove Graph").  To add the individuals chart for the standard deviation column, select it and press  "New Y Chart".

Example Xbar S.jmp