Welcome to the JMP User Community!

Latest Discussions

• DoE Model issues Augmentation

  Dear JMP community, currently we are setting up DoE models based on two experimental blocks.The first block was a Custom DoE Design with 22 runs containing main effects and quadratic effects from 7 factors. The second block was an augmented design containing main effects, quadratic effects and all possible two factor interactions with 16 runs (for a total of 38 runs separated in 2 blocks).In the s...

  I-love-jmp

  Discussions |

  Oct 9, 2023 5:34 AM

  3541 views | 9 replies

• How do I filter categorical data that does not meet my location restriction?

  Hi, I am doing a project that involves getting a model ready from airbnb listing data to the predict price of Broward County airbnb listings. I am trying to exlude and hide rows within my data that are not in Florida as there are many listings that are from different countries and states. Is there a way to do this without having to go row by row? This is categorical character data.

  jmessina944

  Discussions |

  Oct 8, 2023 6:37 PM

  1653 views | 4 replies

• Newb Question - Basic Sequencing in a column

  I'm a beginner in JMP and coding as a whole. I'm trying to figure out how I can make sequence of 0, 25, 50, 100, to repeat 8 times.   I tried Sequence(0,100,25,8) and obviously 75 shows up as well.    And I cannot for the life of me figure it out.    Chatgpt gave me the following code:    If(Mod(Row(), 4) == 0, 0, If(Mod(Row(), 4) == 1, 25, If(Mod(Row(), 4) == 2, 50, If(Mod(Row(), 4) =...

  ControlAlpaca51

  Discussions |

  Oct 8, 2023 1:06 PM

  1475 views | 3 replies

• How to get non-duplicate column names from the "leaf label formula" of decision tree model?

  For example, use the following JSL to get the Leaf Label Formula.Extract the column names from the formula in the first 10 rows.Thanks!d0 = Open( "$SAMPLE_DATA/Equity.jmp" ); p=Partition( Y( :BAD ), X( :LOAN, :MORTDUE, :VALUE, :REASON, :JOB, :YOJ, :DEROG, :DELINQ, :CLAGE, :NINQ, :CLNO, :DEBTINC ), Validation Portion( 0.3 ) ); p<<go;Wait(2); p << save leaf label formula;

  lala

  Discussions |

  Oct 7, 2023 8:02 AM

  1262 views | 3 replies

• for each group find out which value is missing in a specific column, then create a new row with the missing value for that group with 0 in the count column as a corresponding value for that row

  I have 4 columns in the mock data set (File attached below). The column "Companys" is grouped by column "Month-Year" and "State". Each "Companys" column value is associated to a value in column "Sectcor". I want find what values are missing in each group of Month-Year and State Column for example Sector "DK" has Companys "C" and "D" Associated to it but for group Jan-2021, CA we have 2 rows associ...

  j0rg

  Discussions |

  Oct 6, 2023 1:54 PM

  1357 views | 1 replies