Welcome to the JMP User Community!

Latest Discussions

• Calculating Percentage difference for a big amount of data

  Hi everyone! 
  I have attached a example file under this post.
  I'm currently trying to calculate the percentage of difference,
  which is given by (New Value- Original Value)/Original Value
  In this case, Time 0 is taken as the reference ( Original Value).
   For example:
  Time: 0, Part: 1 Value 1: 690.2
  Time: 50, Part:1, Value1: 690.52
  (690.52-690.2)/(690.2) = 0.046%
  Time: 100, Part:1, Value1:689.25
  (689.25-690.2...

  Jax

  Discussions |

  Jun 19, 2019 1:44 AM

  7608 views | 4 replies

• How do I Create a Column using "IF" and "Contains"

  Hello,   I have a date and time column with "AM" and "PM" in the format. Using JSL, I wand to add a new column that will indicate it its a day or night. Row with "PM" in the date will input "Day" Row with "AM" in the date will input "Night"   I try using the following:    For( i = 1, i <= N Rows( dt ), i++, If( Contains( :Date[i], "PM" ) , :Day/Night[i] = :Day[i] )   But it wont work. Thanks in ad...

  ileshem

  Discussions |

  Jun 18, 2019 6:54 PM

  8886 views | 3 replies

• Markup and Set Wrap in the same text box

  I'm running JMPPro 14.3. I've tried the same thing in JMP12, and in JMP11 (I think) as well. Can someone please show me how to simultaneously use markup (bold, underline, etc.) and set wrap in the same text box? Try running the script below and I think you will understand what I am talking about. nw = New Window("Example of markup in text box",
  Text Box("<b>This is in bold but wraps awkwardly</b>",...

  drew_baumgartel

  Discussions |

  Jun 18, 2019 3:34 PM

  4125 views | 4 replies

• Transforming distributions to highlight spread of values

  Dear JMP Community,   Machine info: W7 Enterprise 64-bit, JMP Pro 14.1.0   I am interested in transforming a column of data to help highlight the distribution in values within binning ranges. The original data are integers and more or less normally distributed (see Y3 distribution below), but I'd like to transform the data in such a way that it takes the data in a bin range and spreads it out so a...

  SDF1

  Discussions |

  Jun 18, 2019 1:41 PM

  5687 views | 5 replies

• Identify "important variables" for partition trees regression

  I am developing an analysis of partition trees regression, with JMP 13, I have 83 variables, I am identifying the variables that do not have colinearity with VIF, with the aim of being able to identify the most "representative" variables to develop the analysis of partition trees regression (The example I use is Bank Revenues
  Multiple Linear Regression with Transformation / From Building Better Mod...

  H_arn

  Discussions |

  Jun 18, 2019 11:54 AM

  6442 views | 4 replies