JMP User Community

Latest Discussions

Problem to transfer continuous data from excel to jmp

Dear community experts, I try to import the dataset with continuous data (factor6, 7, 8, 9, 12, 13,15 and everything beyond fifteen are responses) from JMP to excel. After export I cannot change the data type to continuous, its not available. I already changed everything to number formate and it didnt help.Its irritating for me also, that all the responses are continuous, even they come from the s...
SimonFuchs

Discussions |
Oct 10, 2022 6:52 AM

1224 views | 1 replies
Can I use a list to populate the X and Y axis in graph builder when scripting?

I have a list of X and Y values that the user selects. I want those list values to populate the x and y axis in graph builder. Is this possible.? I continually get an error that the column names cannot be found?For example:x_values = {"x1", "x2", "x3"}y_values = {'y1", "y2", "y3"}I want the x axis to be the x_values and the y axis to be the y_values. This changes by how the user selects though so ...
ellielee115

Discussions |
Oct 10, 2022 6:18 AM

5529 views | 6 replies
How to join two tables on datatime columns that match within 1 minute

Hello All, I have two data tables that I am trying to join. They both contain a datetime column that I would like to use to match up the rows. The problem is the datetimes can be off by at most 1 minute due to some inconsistencies in how table B is rounding its values. For example, on table A the datetime might be 2022-10-03 22:13:47 and on table B it will round down to 2022-10-03 22:13:00, but fo...
jbakri

Discussions |
Oct 10, 2022 6:13 AM

1278 views | 2 replies
Equivalence Testing in JMP

Does anyone know how to change the equivalence test graph from the new style (Confidence Interval) to the old style (distribution curves)?
lklein8

Discussions |
Oct 10, 2022 1:33 AM

719 views | 1 replies
How to calculate the median for a group of data

Hello everybody,
I have test groups A and B, 4 different items, Param2 (being the maximum of Param1 values) saved in the first cell of corresponding item. The values of Param2 are sometimes provided per hand. Now I would like to calculate the median of Param2 for each test group and save it again
in the first cell where each test group starts, like in the table below. I would appreciate for hints ho...
lukasz

Discussions |
Oct 10, 2022 1:00 AM

1630 views | 2 replies

Previous
Next

Latest Discussions

Problem to transfer continuous data from excel to jmp

Dear community experts, I try to import the dataset with continuous data (factor6, 7, 8, 9, 12, 13,15 and everything beyond fifteen are responses) from JMP to excel. After export I cannot change the data type to continuous, its not available. I already changed everything to number formate and it didnt help.Its irritating for me also, that all the responses are continuous, even they come from the s...
SimonFuchs

Discussions |
Oct 10, 2022 6:52 AM

1224 views | 1 replies
Can I use a list to populate the X and Y axis in graph builder when scripting?

I have a list of X and Y values that the user selects. I want those list values to populate the x and y axis in graph builder. Is this possible.? I continually get an error that the column names cannot be found?For example:x_values = {"x1", "x2", "x3"}y_values = {'y1", "y2", "y3"}I want the x axis to be the x_values and the y axis to be the y_values. This changes by how the user selects though so ...
ellielee115

Discussions |
Oct 10, 2022 6:18 AM

5529 views | 6 replies
How to join two tables on datatime columns that match within 1 minute

Hello All, I have two data tables that I am trying to join. They both contain a datetime column that I would like to use to match up the rows. The problem is the datetimes can be off by at most 1 minute due to some inconsistencies in how table B is rounding its values. For example, on table A the datetime might be 2022-10-03 22:13:47 and on table B it will round down to 2022-10-03 22:13:00, but fo...
jbakri

Discussions |
Oct 10, 2022 6:13 AM

1278 views | 2 replies
Equivalence Testing in JMP

Does anyone know how to change the equivalence test graph from the new style (Confidence Interval) to the old style (distribution curves)?
lklein8

Discussions |
Oct 10, 2022 1:33 AM

719 views | 1 replies
How can use a script to match data directly from a matrix?

For example: Get the memory matrix ar with the following script.
How do match data directly from a matrix with a script?
Achieve something like this:dt<<Update(With(d2),Match Columns(age=age));Thanks!
lala

Discussions |
Oct 9, 2022 9:59 PM

651 views | 1 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

415 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

486 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

568 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

576 views | 0 replies