Welcome to the JMP User Community!

Latest Discussions

• JMP10: Col Max() and Col Min() functions returned the data from excluded row

  Hello,I used Col Max() and Col Min() function to return the Max/Min value of my specific columns.Somehow I disabled the unwanted rows but the Col Max() and Col Min() still returned those excluded value.Is this normal? Do you guys have any idea? Thank you so muchPichan

  pichan_p

  Discussions |

  Sep 24, 2015 1:02 AM

  19068 views | 3 replies

• What is the easiest way to count the number of occurrences in a column when rows duplicate?

  What is the easiest way to count the number of occurrences in a column when rows duplicate based on another column?I can of course create a new table without duplicate rows or a script, but can this be done with say Tabulate?Example: I want to know how many men and women.  F(n=3) and M(n=2).Person    Sex   1               F2               F2               F3               M3               M4      ...

  mri

  Discussions |

  Sep 23, 2015 12:03 PM

  26612 views | 4 replies

• Check if multiple column values fall within range

  Sample table:PartTest 1Test 2Test 3Test 4A0.20.40.30.1B0.20.30.40.6C0.70.10.20.4I would like to add a column to this table that evaluates every value in columns Test 1-Test 4, and if all fall within a range to output "Yes".For example, if my range was 0 < values < 0.5, the output would look like this (I've highlighted failing values in red)PartTest 1Test 2Test 3Test 4Yes/NoA0.20.40.30.1YesB0.20.30...

  hooshies

  Discussions |

  Sep 23, 2015 8:45 AM

  12886 views | 4 replies

• Using colour/markers for better multivariate visualisation

  I am exploring the best ways to present multivariate data for further exploration. Experience has shown it can be difficult for people to grasp what scores and loadings plots in PCA are telling them and how similar different clusters are to each other. I can get T2 values from the multivariate control chart platform (after specifying a training group), and the critical value using the formula in t...

  stephen_pearson

  Discussions |

  Sep 23, 2015 2:52 AM

  8488 views | 1 replies

• Calculations using the Tabulate function

  I've been using the Tabulate function to provide summaries of data tables. I'm trying to compare the % change between two sums for multiple groups.
  
  Is there a way to add a simple calcuation of two columns summed in Tabulate, like column A / column B? I know I can make this into a data table, but I wanted to include it in a presentation and the formatting looks much better in the Tabulate window...

  rossmiller

  Discussions |

  Sep 22, 2015 7:31 AM

  18321 views | 9 replies