JMP User Community

Latest Discussions

Comparing row values

I have a table which has 2 columns Term and Multiply which looks something like this: I want to somehow be able to read the column "Term" and check the following:1) If the term in the "Term" column is not multiplied by anything (like Name, Place, Animal and Thing in the above table), then multiply the value in the "Multiply" column by 2.2) If the term in the "Term" column is multiplied by any othe...
powerpuff

Discussions |
Mar 14, 2018 7:13 PM

5045 views | 2 replies
Any chance that JMP will corrupt or modify a CSV file during text import?

Hi all,Here's the scenario. There are six CSV files in multiple computers. Each CSV file has same filename and folder with respect to drive C. I also have the IP address of the computers and can connect to these computers. I think this can be done with some combination of loop codes. My question is this: I am importing the CSV files from the computers which is the main file dump. As a rule, when I...
shaira

Discussions |
Mar 14, 2018 3:50 PM

4904 views | 2 replies
How to find intersection of two tables column names?

Hi,I have two data tables with similar column names and like to write a script to find the overlap (intersection) of two column names and write the interesection into a new data table. I tried using Tables and join and did not work for me. I appreciate your help. Thanks
AT

Discussions |
Mar 14, 2018 3:21 PM

7388 views | 9 replies
How to delete rows based upon a condition

how to make a formula to delete certain rows in column. tasked with deleting all unknowns in the column as well as mixtures of the cultivars. The issue is that the rows are words and a formula in jmp must be used to get full credit for this exercise. attached is a screenshot of the jmp file with the cultivars column. must delete the unknowns and the mixture of cultivars.
Ges

Discussions |
Mar 14, 2018 1:23 PM

22665 views | 5 replies
When "Set Delta For Power" is set to 2, does this represent a SNR of 2 or 1?

In the DOE Guide, on pg 429, under Evaluate Design > Evaluating Relative to a Specified Model, it describes evaluating the "power of detecting an effect whose magnitude is three times the error" by setting the Anticipated Coefficient to 3 and the Anticipated RMSE to 1. This sounds like a signal-to-noise ratio (SNR) of 3. Later in the DOE Guide, on pg 451, under Evaluate Design Options > Advanced...
StevenCHowell

Discussions |
Mar 14, 2018 11:29 AM

7244 views | 5 replies

Previous
Next

Latest Discussions

When "Set Delta For Power" is set to 2, does this represent a SNR of 2 or 1?

In the DOE Guide, on pg 429, under Evaluate Design > Evaluating Relative to a Specified Model, it describes evaluating the "power of detecting an effect whose magnitude is three times the error" by setting the Anticipated Coefficient to 3 and the Anticipated RMSE to 1. This sounds like a signal-to-noise ratio (SNR) of 3. Later in the DOE Guide, on pg 451, under Evaluate Design Options > Advanced...
StevenCHowell

Discussions |
Mar 14, 2018 11:29 AM

7244 views | 5 replies
How change the line width in Graph Builder?

Hi,I'm making a graph builder script by manually plotting and saving the script in the data table. So far here is what I've got: //User declares Bottom_Var, Left_Var, Top_Var, Right_Var, and Legend_Var //Legend_Var is the cell grouping whose number may vary Graph Builder( Size( 1173, 638 ), Show Control Panel( 0 ), Variables( X( Bottom_Var ), Y( Left_Var ), Group X( Top_Var ), Group Y(...
shaira

Discussions |
Mar 14, 2018 9:32 AM

2946 views | 1 replies
Populating/Expand UI based on a selection

All,
I found this post and example very relevant to my needs. https://community.jmp.com/t5/Discussions/Creating-drop-down-menu-for-interactive-user-input/td-p/17982. However, as I try to implement/execute the code piece provided here, I don't see what I expected to happen. I think it is a typo, provided is my edited - working code. dt = Open( "$SAMPLE_DATA\Big Class.jmp" ); /* Extract a li...
uday_guntupalli

Discussions |
Mar 13, 2018 7:20 AM

2633 views | 2 replies
Assessing significance of slopes and interactions in mixed models

How do I test not only for differences among slopes, but also that the slopes are different from zero (significant) in a linear mixed effects model with 1 continuous and 1 categorical (2 level) variables, and two random effects. In the Parameter Estimates output below I see that I have a significant interaction between tissue type [MSC] and lnSe. Meaning that the slope for MSC is different from t...
arstewar

Discussions |
Mar 12, 2018 8:12 AM

5168 views | 2 replies
change p-value output format in preferences

Simple question. I understand the reasons why reporting p<0.0001 as "<0.0001"; I also understand how to change the number format in individual outputs. However, for some downtream analyses (like FDR calculation) it is necessary to have the exact p-value AND it is difficult to change format in a large output with thousands of tests. Is there a way to change the preference for p-value output system-...
l_yampolsky

Discussions |
Mar 12, 2018 7:54 AM

4781 views | 4 replies

Previous
Next

Latest Discussions

pseudo r square in JMP choice model platform

Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...
DG

Discussions |
Mar 11, 2018 6:27 AM

2255 views | 0 replies
chnging colors on PCA plot

Hi,I seem to be able to change the color of the circle around the PCA plot but not the arrows which remain red no matter what I do. I changed the circle by Right Clicking on the plot --> Customize --> Circle and selecting the black color. I did the same using the option of Customize --> Arrow but nothing changes.Any advice would be appreciated.Thanks a lot.Helga
helga55

Discussions |
Mar 9, 2018 2:20 PM

3495 views | 0 replies
.jsl scripts will lock files even while set to read and execute permissions only

I am having an issue where an add-in script which runs another script via the include(); function is locking the included script file while other users are running it. This renders me unable to update that script. I tried setting the permissions on the repository and the file as read and execute only but it still locks when other users access it.
nbullen

Discussions |
Feb 5, 2018 12:05 PM

2273 views | 0 replies
Sub-sampling data analysis in JMP

In Biology (Plant Sci. and Agriculture) usually we have sub-sampling data for replicates. It's very difficult to analyze these data in commonly use Stat S/W (SPSS/Minitab) because MSS(Error) is calculating wrongly. Without taking averages of samsamples, the easiest S/W for this is using JMP and I need some assistance for this. I've found very useful Youtube video about subsampling in JMP (CRD: S...
Kynda

Discussions |
Nov 15, 2017 2:32 PM

3765 views | 0 replies
Conceptual question about the profit matrix

This issue has been discussed previously, but I keep finding myself confused about how to use the profit matrix. My question is conceptual in nature, so let's just use some simple numbers. Suppose I have data on customer churn and I build a predictive model for churn (the particular technique does not matter for this question). My decision errors are not symmetric, however, so I want to modify ...
dale_lehman

Discussions |
Nov 10, 2017 6:02 AM

2648 views | 0 replies