JMP User Community

Latest Discussions

Opening URL table with "," issue

Hi all,when trying to open URL table I got an issue wit hthe columns,some of the valiues have "," in them and it cause the valuse to split in several columns,is there a way to resolve it?example:original value in column: "bag,mask,cup"when I open URL in JSL-> I got 3 seperate columns: "bag" "mask" "cup" appriciate your support.
Hamal22

Discussions |
Jul 28, 2021 4:46 AM

825 views | 1 replies
about JSL formula to mark lowest 6 numbers within each fixed Item

I have one table with column "ITEM" and "ID", and the "ID" column value is random, could help to suggest how to use JSL formula to create one new column, and fill in content "Y" when the "ID" value is the lowest 6 within each fixed "ITEM" value. thanks a lot ITEMID6 low ID within each Fixed Item?OHO112973YOHO1129111 OHO112972YOHO112971YOHO1129114 OHO1129113 OHO112969YOHO1129109 OHO112970YOHO112911...
qspringleaf

Discussions |
Jul 28, 2021 4:16 AM

2167 views | 4 replies
Count values

Hi all, I have 2 columns, 1st column is for the parts name (sample: parts 1 and parts 2) then 2nd column is the judgement whether is good or no good. Is is possible to count all the good parts and place the total good parts for parts 1 & 2 on the next column?Thanks
29755

Discussions |
Jul 27, 2021 11:35 PM

944 views | 1 replies
Creating a dynamically linked table

Hi, I created a set of tables from a script using the Tabulate feature, but they don't appear to be dynamically linked. Is there a way to amend this, or how else would one go about creating a dynamically linked table in JMP / JSL? FYI by dynamically linked I mean, when you click on a cell in the table, it selects the corresponding data samples. Mike
mostarr

Discussions |
Jul 27, 2021 2:57 PM

2099 views | 4 replies
Using XGBoost Model to Predict on a hold-out test set

I am using JMP 16. I installed the XGBoost addin. I developed a xgbbost model using this. I saved the model in the data table using 'Save Prediction formulae'. Now, I have a separate hold-out test set on which I want to run the formulae to get the prediction. If I click the formulae (see attached figure), I found that the formulae depend on the training and validation set, which seems odd to me....
sukrit2020

Discussions |
Jul 27, 2021 1:51 PM

7360 views | 12 replies

Previous
Next

Latest Discussions

Opening URL table with "," issue

Hi all,when trying to open URL table I got an issue wit hthe columns,some of the valiues have "," in them and it cause the valuse to split in several columns,is there a way to resolve it?example:original value in column: "bag,mask,cup"when I open URL in JSL-> I got 3 seperate columns: "bag" "mask" "cup" appriciate your support.
Hamal22

Discussions |
Jul 28, 2021 4:46 AM

825 views | 1 replies
Count values

Hi all, I have 2 columns, 1st column is for the parts name (sample: parts 1 and parts 2) then 2nd column is the judgement whether is good or no good. Is is possible to count all the good parts and place the total good parts for parts 1 & 2 on the next column?Thanks
29755

Discussions |
Jul 27, 2021 11:35 PM

944 views | 1 replies
Creating a dynamically linked table

Hi, I created a set of tables from a script using the Tabulate feature, but they don't appear to be dynamically linked. Is there a way to amend this, or how else would one go about creating a dynamically linked table in JMP / JSL? FYI by dynamically linked I mean, when you click on a cell in the table, it selects the corresponding data samples. Mike
mostarr

Discussions |
Jul 27, 2021 2:57 PM

2099 views | 4 replies
Using XGBoost Model to Predict on a hold-out test set

I am using JMP 16. I installed the XGBoost addin. I developed a xgbbost model using this. I saved the model in the data table using 'Save Prediction formulae'. Now, I have a separate hold-out test set on which I want to run the formulae to get the prediction. If I click the formulae (see attached figure), I found that the formulae depend on the training and validation set, which seems odd to me....
sukrit2020

Discussions |
Jul 27, 2021 1:51 PM

7360 views | 12 replies
Regression P-Values in a Column based on the Values from other Columns

Hi... I am trying to find an alternative to Nelson Rule number 3 (6 points increasing or decreasing) that uses a regression based on a number of successive points an alpha value and a resultant p-value to help me flag when a signal is large enough to overcome noise. This is would be used for tool wear types of control charts. Suppose I had a data set that looks like below (for simplicity) where;...
fat_angus

Discussions |
Jul 27, 2021 1:02 PM

1713 views | 3 replies

Previous
Next

Latest Discussions

Partial redundancy analysis in JMP

I need to check the effects of three explanatory variables which are 1) fish_length, location, and sex on a set of response variables (PC1…..PC7).
First I need to test the effect of size (fish size), and in case if the effect of fish_length is significant then I need to use the residuals of the first pRDA test to check the effects of location and sex using RDA. Also I will need to use the residuals...
ukhandurrani

Discussions |
Jul 22, 2021 9:33 AM

1280 views | 0 replies
Graphlet disappearing after filtering through a null set

Have a tool I built that has a series of graphlets in them. Noticed some odd behavior. The top-level graph has a local data filter. Some combinations of that data filter will result in no data. When I filter to a no-data set, then expand back to a set with data, the graphlet no longer exists. Any ideas on how to retain the graphlets after filtering?
Evan_Morris

Discussions |
Jul 12, 2021 10:28 AM

879 views | 0 replies
Obtaining a p-value for an odds ratio of a continuous variable

Hi all,When performing an odds ration analysis on a nominal variable I get a p-value which is identical to the p-value of the parameter estimate (see pic below). When performing the same on a continues variable there is no p-value (see pic below). Could I use the p-value of the parameter estimate as the p-value of the odds ratio?If not how could I obtain the p-value in JMP?TIA
eliyahu100

Discussions |
Jul 7, 2021 10:27 AM

1491 views | 0 replies
How do I get Odds Ratios after fitting a GLM with binomial distribution and logit function?

Hi everyone,I need to get OR after fitting a GLM with binomial distribution and logit function - that is a logistic model. I cannot fit a "nominal logistic" where there's the option for OR because I need to use the Firth adjustment for small-sample bias (I can only do that for that GLM). Is there an option to get the Odds Ratios? Thank you in advance. Antony
Antony

Discussions |
Jul 7, 2021 10:04 AM

880 views | 0 replies
Solving for new FPCs using a training set

Had a question on the Functional Data Explorer system. Feels like a dumb question but can't figure it out. So I set up a training set and developed FPCs I like. The next step is then to use that spline structure to solve the FPCs for new items as they come in. What steps would I take to do that?
Evan_Morris

Discussions |
Jul 6, 2021 11:08 AM

707 views | 0 replies