Welcome to the JMP User Community!

Latest Discussions

• Function of STDEVP in Excel

  Hello
  I tried to use the same function as STDEVP in Excel and I didn't find an exact analog in JMP where I could receive the same result.
  For example, if I will take four numeric numbers as well as 1,6,8,9, the STDEV should be 3.08but if I'm using formula SDT DEV in JMP I'm receiving result of 3.56I will appreciate it if you could direct me to the right place in the formula where I can receive the s...

  Dennisbur

  Discussions |

  Dec 27, 2022 6:19 AM

  12776 views | 6 replies

• pulling information with date condition: put filename into list if it is greater than a specified date and time

  Hi,I m trying to  get the list of files name in a directory with given condition if it is 1) zip archive and also the 2) creation date greater than yyyy/mm/dd. Below is my script. My question1) it ran without error but not return empty list. I 'm not sure what is the issue (perhaps the date).
  2) how can I set the creation date () output format to yyyy/mm/dd hh:mm:ss? 3) it take long time to loop th...

  dadawasozo

  Discussions |

  Dec 24, 2022 2:10 PM

  2031 views | 3 replies

• Why are my fit models showing different factor significance? In "model 1", Random Block is a Random Effect rather than a Fixed Effect, whereas "model 2" lists all the factors as Fixed Effects.

  When I clicked Fit Model, "model 1" popped up, including "Random Block & Random" as a factor, which means "Random Block" is a Random rather than Fixed Effect. However, When I run "model 2" with just "Random Block" as a factor, everything becomes less efficient. Which is more correct and why? Also, I'm used to the Model 2 output, in which I can click on Scaled Estimates. And I was taught at a JMP t...

  evtran

  Discussions |

  Dec 23, 2022 8:45 PM

  1854 views | 3 replies

• JSL question: Update missing column entries from another column

  Hi all, I need to update missing column entries in a data table, with entries from another older column. Using JSL code, and on JMP 14.Here is the code I am trying to work, but it keeps on throwing error "attempting to assign to an object... L-value access.."Any help will be appreciated.. dt=current data table(); Newcols={ "anew", "bnew", "cnew"}; oldcols={ "a", "b", "c"}; //---Update entrie...

  JazzlikeMag

  Discussions |

  Dec 20, 2022 10:49 AM

  1494 views | 2 replies

• Group data in one column but sort by another

  Hi!  I have been trying to organize a set of data to group by the device column (ie all the a's are together, b's, etc), but sort them by the percent failed (ie c, F2 would be first followed by the rest of the c rows, then b, F3, and so on) similar to the picture below. When I sort by percent I get the left most table, by device I get the middle table, but I am not sure how to combine the filterin...

  SampleIguana839

  Discussions |

  Dec 20, 2022 8:18 AM

  2009 views | 3 replies