Welcome to the JMP User Community!

Latest Discussions

• JSL: How do I Group Columns with JSL?

  Hello community:
  
  One can group columns by selecting them in the columns window and choosing "Group columns" in the context menu. Is there a JSL statement doing the same thing? I found nothing in the operators index or scripting guide.
  
  Thanks,
  Dahla

  

  Discussions |

  Oct 12, 2009 6:48 AM

  19765 views | 14 replies

• Exclude selected rows

  OK, I know this is simple, but I can't work out how to do it.
  
  What is the JSL script for excluding rows that are selected?
  
  Currently, I am excluding rows by creating an additional column called IgnoreRow, with a value of 1 for rows to be excluded and 0 for all other rows (this calculation is based on the contents of other columns). I then use:
  
  For Each Row( Excluded( Row State() ) = :IgnoreRow );
  
  whic...

  matthewh

  Discussions |

  Oct 6, 2009 7:25 AM

  10101 views | 2 replies

• Looking for advice on LD50/ED50 calculation with JMP

  Hi JMP users,
  I've tried to figure this out but the statistics guide is vague enough that I can't quite get to the answer that I need to make this work.
  
  I'm trying to get JMP to work for computing LD50 values based on observed mortality proportions.
  
  The documentation and routines in JMP seems to rely on a logistic regression and imply that inverse prediction at 0.5 will yield an LD50. The problem is...

  

  Discussions |

  Sep 30, 2009 2:23 PM

  5987 views | 1 replies

• Finding minimum value within each repeating sequence of column values

  What formula will find a minimum value within each repeating sequence of column values?
  
  I have a large database in which I wish to report the minimum (maximum) value within each 7-member, repeating sequence in a column of real values.
  
  Thanks for any help.

  defcon

  Discussions |

  Sep 21, 2009 2:00 PM

  3285 views | 2 replies

• importing from Excel

  I have JMP v8 on a Macintosh with OS 10.5.8
  
  When I try to import data from Excel, the files with xls extension are selectable while those with xlsx are not. Is there any way to select xlsx files?

  

  Discussions |

  Sep 17, 2009 8:44 PM

  3070 views | 2 replies