Welcome to the JMP User Community!

Latest Discussions

• Determine the correct sampling rate for SPC data

  Hello, I have an SPC data with UCL = 12.015 and LCL = 12 (target is 120.007) - see attached.My OOC (Out Of Control) values are too high and I want to check that my sampling rate is correct.Current sample rate is 0.1 (1 out of 10 parts are measured) and we are missing OOC measurements (there are 2 groups of SPC values with same limits: "Measure Depth 7" and "Measure Depth 1"). I tried using the sam...

  yoni-b

  Discussions |

  Jun 29, 2018 3:59 AM

  10882 views | 4 replies

• Exact match and Nearest Match for updating a table with another table

  I have a big data table (1M rows).  One column is serialNumber, one column is dateTime, one column is elapsedTime.  Another much smaller table also has these columns, but the dateTime is earlier by an small amount (5-20 minutes) and the elapsedTime is a much more accurate value.  The small table also has lots of extra rows associated with other events at other dateTimes (I do not have an 'event' c...

  mann

  Discussions |

  Jun 28, 2018 11:01 AM

  3812 views | 3 replies

• normalcy test for residuals

   I am plotting Y vs X (see attachment). The regression line apperas to be quite good. R seq > 0.99. However when I make a residul plot, I get an inverted U. Some people say that such a residual plot point to that the Regression line is not good enough. My question is:  1. Is there some way to improve the residual plot and the Leniar regression (may be by changing intercept ?).  2. I performed a te...

  peerr12

  Discussions |

  Jun 28, 2018 2:30 AM

  7137 views | 8 replies

• Is there any way that I can remove the label numbers in the graph?

  Hello all,   I am using label in my script to help me filter data. The script is showing bellow:     dt_daily << New Column( "Outliers Exclusion (Energy % from Controls)", Numeric, Continuous, Formula( If( !labeled( Row State() ) , "Clean Bad Data", "Show Bad Data" ) ), eval formula ); Close( dt_subdaily ); Close( dt_dailysplit ); Wait( 0 ); New Window( "Energy % from Controls", dt_daily << Grap...

  Anonymous

  Discussions |

  Jun 26, 2018 6:12 AM

  6049 views | 2 replies

• Passing Date value to Oracle SQL

  I have a frustrating problem. I want to write a script to use a JMP date code, to query an Oracle database.For instance:StDt = today() - in weeks(4);.If I manually do it using Query Builder, I get something like the code below. What syntax do I need to replace the integer date code with to do this? The documentation is pretty sparse on this topic. Query1 = New SQL Query(
   Version( 130 ),
   Connection...

  mwechtal

  Discussions |

  Jun 25, 2018 2:27 PM

  5860 views | 3 replies