JMP User Community

Latest Discussions

How to get a formula column by row sub group

Hi there, I d like to create a formula column (sum or mean etc.) with sub groups. The sub groups should be selected by rows, for example all 5 following rows drom a data table or in general all N rows. Any ideas to solve this with row()?Attache a file to add the formula column.
Thomas1

Discussions |
Feb 11, 2019 4:28 AM

11726 views | 12 replies
Randomised complete block deisgn 2 x 2 factorial

Hi there, I am new to JMP so am hoping you can help! My experiment was a randomised complete block 2 x 2 factorial design with two levels of supplementary additives. A total of 480 individuals were blocked into pens of 5 (pen acts as the experimental unit, not individual), and pens within a replicate were alloacted to one of the 4 dietary treatments. I had 24 replicates in total, but the experimen...
Tegan2404

Discussions |
Feb 10, 2019 11:40 PM

14329 views | 7 replies
Newb JSL Question: How to get the content of a Text Edit Box into a variable?

Hi, I'm a beginner in JSL (JMP 13.1) and I'm struggling with the interactive dialog logic especially how to extract the content of a Text Edit Box into a variable. Here is a snippet of a JSL script that does not work (i.e. the variable "prefix" is not updated with the content of the Text Edit Box "tt1).prefix = ""; win = New Window (" TEST ", << Modal, << On Validate ( if (Is Missing (p...
Thierry_S

Discussions |
Feb 10, 2019 5:56 AM

11620 views | 5 replies
Importing an Excel Worksheet using JMP on MAC

So maybe I'm just tired on a Friday afternoon, but I'm seeing a strange problem when scripting the Open function using JMP (14.2) on MAC. Here is a simple script that does what you would expect - it creates a JMP table containing the contents of the sheet1 of the test spreadsheet. Open( "/Users/docs/test.xlsx", Worksheets( "sheet1" ) ) But when I call it from a class method it launche...
David_Burnham

Discussions |
Feb 9, 2019 11:03 AM

5399 views | 2 replies
Need help understanding parameters and table variables

Hi! I have a practical problem that I think I could solve using some kind of parameter or table variable.Let's say I have multiple processes, each having a row. Which are characterized by few parameters, A, B, C... Those are columns.Let's say for each parameter I have a threshold after which it is considered risky. So I created columns bit-A, bit-B etc. If parameter is grater than some number, I g...
miguello

Discussions |
Feb 8, 2019 3:35 PM

6382 views | 2 replies

Previous
Next

Latest Discussions

DF Dens for repeated measures ANOVAs

Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
mu

Discussions |
Feb 6, 2019 8:10 AM

4099 views | 0 replies
JMP and Dynamic SQL queries

Does anyone know if JMP supports some form of Dynamic SQL queries? I want to do some special querying that is easier to dynamically generate the sql query than directly writing it.
cookiedough

Discussions |
Feb 6, 2019 4:50 AM

4245 views | 2 replies
How to re-size a report table in JSL?

For example, I have made a report from a table as shown below:op1 = tbl1 << Get As Report; But the default display for the report table is too small (yes, I can use the scroll bars to move around). Is there any way in JSL so that I can re-size or maximize the display window for the report? I tried the followings, but none works :-(. <<Set Window Size
<<Maximize Window<<Maximize Display<<Get Max Si...
zxu11

Discussions |
Feb 3, 2019 6:49 PM

5313 views | 3 replies
Huge DF denominators for repeated measures ANOVAs with JMP 14

I used to run repeated measures ANOVAs with JMP 13 with no proglems. But now I got JMP 14 and ran an ANOVA with the same data and somehow got "4326" as a DF Den under "Test Denominator Synthesis". This used to be "42" with JMP 13, and ovbiously the new F ratio got so much larger. I do not think there is anything different I did (data, how to set up), other than I am now using JMP 14 instead of ...
mu

Discussions |
Feb 1, 2019 8:45 AM

17261 views | 15 replies
How to change mosaic plot graph order?

Hey Folks, I was just wondering how to change the order of the data displayed in the mosaic charts. In the picture below, say I would like to change the order of the data to be displayed as blue at the top, or orange goes to the bottom. Thanks in Advance, Thomas
ThomasLovesRedV

Discussions |
Jan 31, 2019 9:28 PM

6091 views | 1 replies

Previous
Next

Latest Discussions

DF Dens for repeated measures ANOVAs

Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
mu

Discussions |
Feb 6, 2019 8:10 AM

4099 views | 0 replies
Partition and Pruning

I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
NG

Discussions |
Jan 30, 2019 8:25 AM

3417 views | 0 replies
I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2557 views | 0 replies
Contingency table and mosaic plot are not same orientation

// For a contingency table report, swap the x and y // currently can swap the mosaic plot only Names Default to Here(1); dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); myr = Contingency( Y( :Age ), X( :sex ) ); // Have to have a Contingency Analysis report open // Can add test to make sure it is open in the future myr = Current Report(); // taking apart CrossTabBox was easier using XML than JSL...
Vball247

Discussions |
Oct 29, 2018 2:18 PM

3234 views | 0 replies
how to change the type and color of lines in graph

I am trying to show line of fit in graph builder for several sets of data. The data table have many columns, I want to show the column(i) vs column(1).Every column can be grouped by A1 & a, also can be grouped by B1 & b, but except column(1). The follow is the chart about column(2) vs column(1): I use the follow script to change the type of lines:Dispatch( {}, "400", ScaleBox, {Legend Model( 8,...
Yu

Discussions |
Sep 25, 2018 2:34 AM

3636 views | 0 replies