Welcome to the JMP User Community!

Latest Discussions

• Group Age Column into Categories

  Hello.. I'm new to JMP and I have a basic question.I would like to create a new column that groups customer's ages into age groups:Age range 0 <34.9 should be labeled <35Age range 35.0-44.9 should be labled 35-44Age range 45.0-53.9 shoulf be 45-54How do I write the formula and reflect the labels?Thanks!

  kassidy_lillard

  Discussions |

  Apr 6, 2015 6:32 AM

  11673 views | 1 replies

• Error: Cannot set value for the column '' because the row number (-1) is not valid

  I have a data table with 2 rows from an import from Excel and am trying to extract some data. Reticle1name = :Reticle[1];//Reticle is a column Reticle2name = :Reticle[2]; Reticle1X= :Closest DUT# X[1];//Closest DUT# X is a column Reticle2X= :Closest DUT# X[2]; Reticle1Y= :Closest DUT# Y[1];//Closest DUT# Y is a column Reticle2Y= :Closest DUT# Y[2]; AlignmentBump= :Alignment Bump[1];//Alignment Bum...

  Hegedus

  Discussions |

  Apr 3, 2015 6:06 PM

  14278 views | 1 replies

• Control Chart & 3 Sigma

  With reference to the table attached: I have about 30 observations. The values have a std deviation of 0.534121. The average is: 73.93235. Now if I want to calculate the control limits based on the thumb rule of ± 3 sigma, the limits come out to: 72.3 LCL and 75.5 UCL.However if I plot a control chart with the table in the attachment, the UCL and LCL are calculated to be:  72.852 to 75.01. I am un...

  none1

  Discussions |

  Apr 3, 2015 11:52 AM

  48801 views | 14 replies

• Is there a way to extract columns used in a formula?

  Hello folks-I'm trying to create a new button in my platform which would extract selected columns from a step-wise analysis and then build up univariate distributions of each selection. The limitation is that the extraction of columns selected and building the distribution is held to the specific column names in the list. I would like to be able to dive into the column to check if it is a formula,...

  andrew_j_parker

  Discussions |

  Apr 3, 2015 8:19 AM

  17594 views | 5 replies

• text to columns but in a neat way

  Hello all,I have a column of character data set which consist of codes of discounts we give our agencies. Also there are rows with empty data (no discount)I would like to get a result as below without generating any additional row:

  saitcopuroglu

  Discussions |

  Apr 3, 2015 7:17 AM

  13241 views | 6 replies