Welcome to the JMP User Community!

Latest Discussions

• How to combine two columns (with missing data)?

  got a table with missing data like this:Column1Column21••5•73• Need to combine it it to one column Column31573 I used sum but it didn't work. The only way I can do is using If and is Missing() formual. Any fast way to combine it? Thanks! 

  jasongao

  Discussions |

  May 29, 2019 9:53 PM

  2219 views | 1 replies

• Help understanding how Lift curves are calculated

  Dear JMPers,   (computer details: I have JMP Pro 14 on a W7 Enterprise, 64-bit computer.)   I am trying to better understand how JMP actually calculates a Lift curve. I understand conceptually the ROC and Lift curves, but I'm having a hard time calculating a Lift curve myself. The JMP help/support page (https://www.jmp.com/support/help/14-2/lift-curve.shtml#1276958) isn't all that helpful in under...

  SDF1

  Discussions |

  May 29, 2019 11:10 AM

  1946 views | 0 replies

• discrete numeric factor good choice?

  I have 4 factors with 3 settings:- time- 5, 10, 20water- 100, 200, 300speed1- 2500, 3000, 4000speed2- 5000, 6000, 7000 my response is viscosity and trying to figure out at what setting can I get my desired viscosity. I am trying to set up a design. Since I have 3 settings of each factor I was thinking of using discrete numeric factor but I read in JMP documentation that "Not all levels of a discre...

  billi

  Discussions |

  May 29, 2019 11:09 AM

  5079 views | 4 replies

• How to calculate moving average of column with more than 10000 million entries in JMP 11?

  I am trying to run the below formula on a column with 100 million rows to calculate the moving average.Could you please suggest an JMP11 alternative for  Col Moving Average  Col Moving Average( :x, 1, 9999999, 0 ) is not supported by JMP11. Please find below the code I have tried: NamesDefaultToHere(1); // Use a function to open a .CSV file: Given the path to such a file, returns a reference to t...

  jojmp

  Discussions |

  May 29, 2019 3:48 AM

  3592 views | 5 replies

• Customize Oneway analysis

  Hi guys! 
  I'm wondering if there is a way/script to move the minimum, median and maximum in to the Means and Std Deviations area.
  Thank you ! 
  
  dt = Open( "$SAMPLE_DATA\Big Class.jmp",invisible(1) );

ow= dt<<Oneway( Y( :Eval(colListY<<GetItems) ), X( :Eval(colListX<<GetItems) ), All Graphs( 0 ), Quantiles( 1 ), Means and Std Dev( 1 ), Plot Quantile by Actual( 1 ), Line of Fit( 0 ), Points( 0 ), Box Plo...

  Jax

  Discussions |

  May 29, 2019 1:28 AM

  3876 views | 2 replies