JMP User Community

Latest Discussions

use a value to find the correct column to use in a formula

Hi,I have a summary table where I'd like to create a new column 'Rate' with a formula. The column MAXRESULT gives the name of the column I want to use in the formula. unfortunately, I'm getting 'missing arguments' error when I create the formula based on column name.Column 'Rate' formula: (100 * Column Name( Parse( "N(" || Char( :MAXRESULT ) || ")" ) )[]) / :N Rows What's wrong ?
cyrilmichelland

Discussions |
Sep 27, 2022 7:16 AM

2034 views | 5 replies
stepwise regression on nonlinear data

Hi, I have a datasets with a research question: Is X contributing additional variance in Y in addition to Age? Based on the data, Age account for significant variance in both X and Y, but the relationship is nonlinear (When Age increase, Y decrease exponentially, and X increase exponentially). So when I fit Y by X (using 0 degree correlation), the relationship between X and Y looks linear. So to ...
yuhanmc

Discussions |
Sep 27, 2022 6:17 AM

1167 views | 1 replies
Datatable indexing Problem within a Formula

I am trying to apply the log10 function to an entire column within a data table. The result will be in a new column with a new name. The new column and name are generated by I get an error in the formula portion. Below are the results of the script and the error message. This is the script: Names Default To Here(1); dt = As Table(J(5, 5, Random Uniform()), <<column names({"X1", "X2", "X3"...
RayOq

Discussions |
Sep 27, 2022 3:46 AM

1195 views | 2 replies
Box-plot + dot plot + half violin plot

Dear all, does anyone know if with JMP it is possible to create a graph showing the box-plots with the points inside each box and showing half of a violin plot.
In practice, a graph similar to the one attached, but with the points inside each box-plot. Thanks Giuseppe
GiuseppeC

Discussions |
Sep 27, 2022 2:32 AM

4899 views | 9 replies
Discrepancy measure for space filling design

Hello, how is the "discrepancy" measure calculated? I read in the docs that "The discrepancy value shown below the table is the integrated difference between the design points based and a uniform distribution." Is this the L1 distance? or something else? The DiceDesign R package has a boatload of different (L2) discrepancy measures. Any help appreciated.
John3

Discussions |
Sep 27, 2022 1:36 AM

1416 views | 1 replies

Previous
Next

Latest Discussions

stepwise regression on nonlinear data

Hi, I have a datasets with a research question: Is X contributing additional variance in Y in addition to Age? Based on the data, Age account for significant variance in both X and Y, but the relationship is nonlinear (When Age increase, Y decrease exponentially, and X increase exponentially). So when I fit Y by X (using 0 degree correlation), the relationship between X and Y looks linear. So to ...
yuhanmc

Discussions |
Sep 27, 2022 6:17 AM

1167 views | 1 replies
Discrepancy measure for space filling design

Hello, how is the "discrepancy" measure calculated? I read in the docs that "The discrepancy value shown below the table is the integrated difference between the design points based and a uniform distribution." Is this the L1 distance? or something else? The DiceDesign R package has a boatload of different (L2) discrepancy measures. Any help appreciated.
John3

Discussions |
Sep 27, 2022 1:36 AM

1416 views | 1 replies
manual grouping - extended version?

The function Rows / Row Selection / Name Selection in Colum is very useful. You can specify a label for the selected and the unselected rows. The best feature of the function
You can leave an entry empty - then you can write again and again into the same column and collect infos, like grades for studens in the first example.If you changed your mind, you can also over-ride previous entires. So, the...
hogi

Discussions |
Sep 26, 2022 11:26 PM

2482 views | 7 replies
merging values from 2 columns into one (mixed numeric and character values)

Hi I have 2 columns, one containing numeric values, and one containing strings.I want to create a third column that takes the numeric value if the string value is 'parametric', and the string value if it's not. I tried this, but I'm getting an error "Column TEST_RESULT requires numeric values", although it's defined as Character type column.I'm using JMP15 if it matters. col_test_result =dt <<new ...
shlomi_bakish

Discussions |
Sep 26, 2022 6:13 PM

4787 views | 12 replies
R interface in JMP

Hello, I wrote a code in R that I want to run into JMP. Here is the code : R init(); //send data to R R Send(dt); R submit(" library(spatstat) #creation fenetre fenn<-owin(xrange=c(40,760), yrange=c(40,160), poly=NULL, mask=NULL, units=NULL) ppp<-ppp(x=dt$XM,y=dt$YM,window=fenn) print(quadratcount(ppp,nx=6,ny=3) Q<-quadrat.test.ppp(ppp,nx=6,ny=3) a<-cdf.test(ppp,'x') D=0 if(a[[2]] & Q[[3]] < 0...
CheeseProgram

Discussions |
Sep 26, 2022 11:30 AM

4303 views | 10 replies

Previous
Next

Latest Discussions

Model classification thresholds add-in display "negative" probability

Hi, I've been looking at this add-in which is very useful.https://community.jmp.com/t5/JMP-Add-Ins/Exploring-Model-Classification-Thresholds/ta-p/66964 In our case we don't have a probability but instead we have a status and a measurement that ranges between -10 and 10.I want to adapt the script so that the slider can move between -10 and 10 (I've already done it and it works). However the "Probab...
Agustin

Discussions |
Sep 13, 2022 6:43 AM

578 views | 0 replies
wrap: hide sub-titles?

In GRaph Builder, "wrap" is a nice option to split a data set into small pieces and generate many sub-plots.
But sometimes, the window is just filles with the "titles" of the sub-plots an there is no space left for the plots.
Is there an option to hide the titles of the subplots?
In the "wrap" context menu, there is an option to remove the "title" (here: "data"), but not the sub-titles.
And in the red...
hogi

Discussions |
Sep 11, 2022 8:53 AM

623 views | 0 replies
How to transform least square means from Turkey table after box cox transformation

Hello Everyone, I am running a three-way ANOVA with data expressed in percentage, but the data set is not normal. Since I have zeros, I first add a constant 0.00001, then I fit the model, and in the least square fit window, I used the box cox transformation to do a better fit. I know if I ask to save the predicted values, it will save the back-transformed data, but is there an option for JMP to sa...
Viniaze

Discussions |
Aug 27, 2022 9:14 AM

655 views | 0 replies
XGBoost Add-In for JMP Pro no test set result in model screening

I'm using model screening and include XGBoost as a method. However the result from XGBoost are only shown in Train set and Validation set.Why the result of XGBoost for test set is not shown?
TasapornV

Discussions |
Aug 25, 2022 12:45 AM

719 views | 0 replies
JMP Pro, Dantzig selector: how do I improve computational time

Hello JMP community members. Concerning the use of the Dantzig selector on big and sparse datasets.I wondered what features would be at disposal to tune the computational time.Right now it takes about 40 minutes to get a result back for a problem with 380 rows and 149 non-singular parameters. This makes me wonder about the options available to tweak the computation time. I was thinking about redu...
Not_A_Student

Discussions |
Aug 12, 2022 7:49 AM

721 views | 0 replies