Welcome to the JMP User Community!

Latest Discussions

• Previous and next non-missing values in a column

  I’m fairly new to JMP, and I’ve come across a problem with which I’m really struggling. I use JMP Pro 17. I have a data sheet with one column with distance from a starting point (“Distance”) and one column with a signal intensity value at that distance (“Signal”). I’ve found signal local maxima (peaks) by making a formula column which yields a 1 if the signal value at that distance is the largest ...

  PathReindeer523

  Discussions |

  May 9, 2024 1:37 PM

  3520 views | 4 replies

• Begin Data Update

  HelloI have a table and would like the empty volume to be updated to 0I have written the script to update the column "19-04-2024"the problem is the name of the column can be changed and I prefer to use column (3) or column (4)but it doesn't work. can you please correct the script? dt << Begin Data Update;
                                      dt << Recode Column (
                                      d...

  Dennisbur

  Discussions |

  May 9, 2024 10:51 AM

  8367 views | 12 replies

• Fishers Exact Test Interpretation

  Hello! I am analyzing an experiment that I conducted which was made using JMP DOE.  I am interested in using the Fishers Exact Test results (pictured below). I was doing some reading on the JMP help site and it says that values in the tables are not to be considered as P-Values, can these values be taken has regular probability values or is there another way to interpret the data.    

  MedianPuppy4982

  Discussions |

  May 9, 2024 5:29 AM

  5984 views | 5 replies

• Averaging with the Summary command. How can I use the mean column of the generated table to keep a significant number?

  I have seen Big Class.jmp's table with the same JSL get a mean column that already retains a significant number, but my own table does not.dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt = Current Data Table(); d2 = dt << Summary( Group( 2 ), Mean( 4 ), Freq( 0 ), Weight( 0 ), Link to original data table( 0 ), statistics column name format( "column" ) );Thanks!

  lala

  Discussions |

  May 8, 2024 8:00 AM

  6194 views | 10 replies

• How can count the number of consecutive Spaces at the beginning of each line?

  It can be implemented with a formula or a regex
  I only know how to use this formula, but it's definitely not right.I don't want to do it in a circular way.Length(txt)-Length(Substitute(txt, " ", ""))Thanks!

  lala

  Discussions |

  May 8, 2024 7:45 AM

  2172 views | 3 replies