Welcome to the JMP User Community!

Latest Discussions

• 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

  3289 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

  3074 views | 2 replies

• How do I add error bars to bivariate fit (y by x)?

  I am plotting line graphs using analyze>fit y by x. I get a series of points that I then group by treatment and fit each value. I have been unable to get a nice line graph with error bars. I am currently exporting the data back into excel in order to get this graph. Any advice??

  

  Discussions |

  Sep 14, 2009 10:17 AM

  5081 views | 4 replies

• How do I make cells blank>

  Hi,
  
  I'm new to jmp, so please forgive me if this is a dumb question...
  
  How do I replace numerical values in a cell with blanks if they do not meet a certain criteria or otherwise exclude them? If I set a filter, it ends up filtering out the entire row, which is not what I want to do (there's other useful data in that row).
  
  Thanks!

  

  Discussions |

  Sep 11, 2009 7:15 PM

  3380 views | 2 replies

• Using Row Subscript

  How can I use the row subscript function to get the maximum value from another column for all rows preceding the current row?
  Here is what I would like to do:
  (current row value)/(Max row value from only the rows above current row)

  coolmccool

  Discussions |

  Sep 10, 2009 12:57 PM

  4255 views | 2 replies