Welcome to the JMP User Community!

Latest Discussions

• Comparing multiple rows in a large table & keeping row with largest value

  Hi Guys-
  
  I am somewhat new to JMP...I have a large 1,000,000+ row table (13 columns) that I need to consolidate in the following way:
  
  I have multiple rows for observations on a single case- (not each case is observed the same number of times- some have 3 observations, some 10). I want to construct a summary table, keeping the observation with the largest values for each unique case.
  
  Thanks!
  
  -t

  leapfrog

  Discussions |

  Jan 8, 2010 3:19 PM

  5519 views | 6 replies

• applying formula to entire jmp data table

  Hi,
  
  I am new to using jmp and sas, so I apologize that this may be a simple question. I have a table with values in it, and I would like to create a new table with the same columns and rows, but with a formula applied to the entire new table. I have thousands of columns, so it is not practical to apply the formula column by column. I would really appreciate any suggestions that anyone could offer.
  
  T...

  

  Discussions |

  Jan 5, 2010 1:10 PM

  5142 views | 6 replies

• Multiple range tests: How can I change the cutoff level from alpha=0.05?

  When I run a multiple range test from the “Fit Model” on the “Analyze” main menu of either JMP 7 or JMP 8 (which can be done by running the model, expanding the “Effect Details” section of the output and then clicking on “LS Means Student’s t” or “LS Means Tukey HSD” depending on the type of test I want), I get a set of pairwise comparisons performed at the 5% significance level.
  
  I need to change t...

  

  Discussions |

  Jan 4, 2010 8:33 AM

  9394 views | 2 replies

• Order of display on box plot

  Hi Guys,
  
  I have data that is arranged as follows in my table, I have shown only one column but each of a, b,c,d has a data column associated with it.
  
  Category
  a
  b
  c
  d
  
  When I plot the box plots from left to right, I get a,c,b,d on my X axis.
  
  How can I make my box plots with the category X axis as a,b,c,d?
  
  Thanks.

  

  Discussions |

  Dec 23, 2009 9:09 AM

  4269 views | 2 replies

• How do I use Neural Net model to predict data?

  I have got the Neural net modeling estimated parameters:
  
  X1, X2, X3, X4 are input
  Y is output:
  
  H1:intercept
  H1:X1
  H1:X2
  H1:X3
  H1:X4
  H2:intercept
  H2:X1
  H2:X2
  H2:X3
  H2:X4
  
  My first question: when I calculate the H1 as H1=1/(1+exp(-(intercept + Sum(H1:Xi*Xi)) is not the H1 value JMP provided.
  
  My second question; I assume the H1 and H2 values from JMP calculation are correct and using the linear combination of t...

  

  Discussions |

  Dec 9, 2009 8:55 AM

  4554 views | 3 replies