JMP User Community

Latest Discussions

How to use a validation column in normal JMP15 (not JMP Pro)

Hi, I would like to build predictive models using Partition, Logistic Regression and Neural Networks for my categorical response Y (Pass or Fail) in JMP 15. I do not have the JMP Pro version. I was able to create a validation column containing Training, Validation and Test sets. How can I use the validation column in the normal version of JMP when building and evaluating the models? Partition and ...
JMPPRO

Discussions |
Apr 11, 2021 10:51 AM

2939 views | 3 replies
deployment model

Hito everybody.In attached 2 jmp files. The one named Training-validation-test was used to build a RF model with the following results.The file contains one numeric response and 20 different predictors with one of them categorical, The predictors are sensors values. As you can see the Bias is very good while the variance is slightly high (92-69=23%).Then a new database with examples never seen...
FR60

Discussions |
Apr 11, 2021 6:11 AM

11011 views | 13 replies
How to Create a Subset Table of the Final Row of Data per Group

Hi!

Is there a way to automate the creation of a subset table such that this is the starting data table

GroupData1Data 2A1AA2TA3CB8FB2RC1EC4GC1OC5E
And this is the subset table (the final row of each group)GroupData1Data 2A3CB2RC5E
Any help appreciated! Thanks!
user8421

Discussions |
Apr 10, 2021 4:33 PM

1335 views | 1 replies
Help getting rows to populate after renaming columns

HelloI am trying to create a JMP script that will rename column names that are in another language to English text and create a new datatable with the new column names. In the script below the column names get renamed below the original column names and the rows of data are lost. Any suggestions? Please help with scripting answers if you have them! Thanks, Eve
Chan

Discussions |
Apr 9, 2021 7:28 PM

1365 views | 2 replies
Graph Builder > Multiple Frame Plots > Retrieve Number of Frames for JSL scripting?

Hi JMP Community, Is there a command to retrieve the number of frames in a multi-frame plot in Graph Builder? I tried the "Get N Frame" command but that's not it, it seems to be only for images (GIF). Thanks for your help. Best, TS
Thierry_S

Discussions |
Apr 9, 2021 2:17 PM

1390 views | 1 replies

Previous
Next

Latest Discussions

deployment model

Hito everybody.In attached 2 jmp files. The one named Training-validation-test was used to build a RF model with the following results.The file contains one numeric response and 20 different predictors with one of them categorical, The predictors are sensors values. As you can see the Bias is very good while the variance is slightly high (92-69=23%).Then a new database with examples never seen...
FR60

Discussions |
Apr 11, 2021 6:11 AM

11011 views | 13 replies
Help getting rows to populate after renaming columns

HelloI am trying to create a JMP script that will rename column names that are in another language to English text and create a new datatable with the new column names. In the script below the column names get renamed below the original column names and the rows of data are lost. Any suggestions? Please help with scripting answers if you have them! Thanks, Eve
Chan

Discussions |
Apr 9, 2021 7:28 PM

1365 views | 2 replies
How to analyse factorial design with an outcome having two types of variance?

Hello I have a dataset from a 2-level factorial design with 2 factors.The dataset contains purchase amount per each user.Each row is a unique user. Purchase with 0 value means user didn't purchase. A and B are treatments. I want to calculate the effect of treatments A and B on average purchase per user (sum of purchase in USD divided by number of users). However, I assume we need to account for ...
gustavjung

Discussions |
Apr 9, 2021 12:06 PM

1732 views | 2 replies
Calculate rolling correlation between two variables in a time series

Hi I have a data set which is in the form of a time series with daily averages of data (the first column is the date). I am currently looking at what correlates with one specific variable in the data set (call it column X). I'd like to check if the correlation is time dependent, e.g. if there are periods with OK correlation and other periods with no/low correlation ("switched" on and off for diffe...
JensD

Discussions |
Apr 9, 2021 5:56 AM

4520 views | 3 replies
Data table - If one column has empty value, then use other column value to fill in,other row keep no change

Names Default To Here( 1 ); //If the original data table is like below, // there are 2 empty value(:sex[3] and :sex[4] )in column sex: dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); dt:sex[3 4] = black; I want the function is: when search all values in column :sex, if find column sex have empty value, then fill the column :name value into the empty position in :sex while keep other value in :sex w...
Theresa

Discussions |
Apr 9, 2021 2:33 AM

1884 views | 1 replies

Previous
Next

Latest Discussions

JSL Syntax Change is coming: Name() is being deprecated

Hi All, I just read here that the JSL syntax for referencing a column using the Name() parser is going away. The new syntax is currently in use and at some point the old syntax will be removed entirely. There's a lot of people here who script, so thought it would be good to post something here. I know I have a lot of code I'll need to change! Better to be ahead of the curve and change it befor...
SDF1

Discussions |
Apr 7, 2021 10:14 AM

897 views | 0 replies
Workflow ideas for new projects

Hi all,

After a year of playing around with JMP, I'm extremely satisfied with using it as my main data exploration platform. However, I'm overwhelmed about the tremendous amount of ways I can begin to explore my data. When starting a new project, let's say a biomonitoring study for instance, where does one begin their workflow? Are there any literature on JMP for starting a project from beginning ...
MikeDereviankin

Discussions |
Mar 30, 2021 1:41 PM

1180 views | 0 replies
Manipulating data table properties (cell width/height) INSIDE application module

Hello! I have created and Application consisting of data from multiple data tables, plotted it into few separate cross-linked graph builders and hosting one preview of data table (which has images, which is kind of the point). I would like to manipulate the cell width / height of the data table cells included into this application/dashboard, but the task seems impossible. For only the data table, ...
plotMaster

Discussions |
Mar 27, 2021 3:54 PM

1423 views | 0 replies
What does it mean when the solution path for Elastic Net is not single-valued?

Dear JMP Community, (W10, 64-bit, JMP Pro 15.2.1) I am running a model to assess the active predictors. I am doing this by using the Autovalidation add-in to generate a Null Factor for my data. I then use the GenReg platform to find estimates for each possible X-factor and then Bootstrap those estimates to get a better assessment of the contributions to the response. I came across a very stran...
SDF1

Discussions |
Feb 15, 2021 12:35 PM

1350 views | 0 replies
Return number from specified row of calculation column in either a text edit box or number edit box in an add in

Hello, I'm attempting to build an application in application builder. I have two modules currently. The first module is a series of number edit boxes and lists that allow the user to input values and make selections.After pushing a button, the inputs and/or list selections update table variables in a data table that subsequently updates column equations. The data table opens in the background so ...
tys5384

Discussions |
Feb 15, 2021 7:33 AM

1204 views | 0 replies