Welcome to the JMP User Community!

Latest Discussions

• Creating formulas in a new column. JMP script

  Hello all. I am needing to create a new column that will subtract the contents of consecutive rows and insert that value into the new column.  Essentially I want to say: In column X, subtract row 1 from row 2 and place that value in column Y. I want this to continue for the entirety of Column X. Therefore: Column Y = X(i+1) - Xi; i being the row number. Anyone know how to do this? Seems simple eno...

  handerson89

  Discussions |

  Jul 8, 2021 6:24 AM

  3242 views | 3 replies

• Demonstrating Pareto's Law with JMP graph

  Hi everyone, I will like to create a graph to show that 80% of the revenue comes from the top 20% of the customers in a store. My current data columns are:1. CustomerID (around 4000+ data points)2. Revenue Would there be a way to build this graph in JMP? I've tried the Pareto Plot but have not been too successful.
  Thank you! Cheers.

  PearlyQuek

  Discussions |

  Jul 8, 2021 5:48 AM

  1516 views | 3 replies

• Maintaining "empty spaces" in resulting column after using if formula

  Hey everyone,
  
  I'm pretty new to jmp, so I might seem a little off with what I am asking and probably I won't use the correct terminology, but anyways I m rather despaired because I cannot think of a solution to my problem: 
  Let me describe my situation shortly: So I am a student and I am currently working on a set of data. I am looking at adverse drug effects of certain medication and the effect I'm...

  mmkaz

  Discussions |

  Jul 8, 2021 1:12 AM

  2050 views | 4 replies

• How to compare baseline data from Derivation and Validation Cohorts?

  I am assigned by my supervisor to independently perform an analysis for risk and score models for my study outcome. After cleaning my data and assigning two-third of my sample size as the Derivation cohort and the other as the validation cohort, the next step is to compare the baseline characteristics if they are statistically significant or not. At the moment these two sample sizes of cohorts are...

  AnwarSalim

  Discussions |

  Jul 7, 2021 6:29 PM

  4125 views | 8 replies

• How do write a JSL that implements one of the conditions for selecting a subset using cell values?

  For example, in "Big Class.jmp": add" add" column,And change the value of the first row of the "add" column to "&:height<65". How do code JSL to add the condition in the first row of the "add" column?  Make the JSL function of this combination the same as that of the following code:dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt << Select Where( sex == "F" & :age > 14 & :height < 65 ); d3 = dt << Su...

  lwx228

  Discussions |

  Jul 7, 2021 5:22 PM

  1593 views | 4 replies