JMP User Community

Latest Discussions

How to center columns in Tabulate?

Hello All! I am a fairly new user and would love to know if we can center the columns when we are using the "Tabulate" function. I have tried:- highlighting/right clicking- adjusting the properties to "center"- looking at the format settings- input "center" into the "Set Format( Uniform Format ( 10, 1 ) )" and adding ",center"- looking at my overall JMP preferences-->Tables Thank You!
Maerawlings

Discussions |
Sep 27, 2022 2:30 PM

1468 views | 2 replies
update table using JSL without adding missing columns

I'm trying to update the values of a specific column in a data table using values in another data table. The update function seems like the logical choice but it always seems to add extra unmatched columns to the updated table. From the update utility there is an option for this However there isn't any mention of this in either the scripting index or in the help search. I've tried dt << upda...
tom_e_dunn

Discussions |
Sep 27, 2022 2:04 PM

15317 views | 3 replies
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

1448 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

861 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

881 views | 2 replies

Previous
Next

Latest Discussions

How to center columns in Tabulate?

Hello All! I am a fairly new user and would love to know if we can center the columns when we are using the "Tabulate" function. I have tried:- highlighting/right clicking- adjusting the properties to "center"- looking at the format settings- input "center" into the "Set Format( Uniform Format ( 10, 1 ) )" and adding ",center"- looking at my overall JMP preferences-->Tables Thank You!
Maerawlings

Discussions |
Sep 27, 2022 2:30 PM

1468 views | 2 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

861 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

1067 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

1619 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

3285 views | 12 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

414 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

485 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

517 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

565 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

573 views | 0 replies