JMP User Community

Latest Discussions

Creating a column of time intervals

I have a column containing date & time data and I would like to create a new column that calculates the time interval between the current row and the previous row? For example, if I have Row 1: 01/01/2019 15:00:00Row 2: 01/01/2019 15:00:05Row 3: 01/01/2019 15:00:12 then I want to create a new column that returns the values (in seconds): -57 Is that possible from the formula builder in JMP? Many t...
Alicia

Discussions |
May 7, 2019 7:56 AM

2412 views | 2 replies
multivariate analysis with categorical and continuous variables

Hello, I have mixed model, where I evaluated on univariant analysis by either Pearson for categorical variables or logistic regression for continuous variables significance to a binary outcome (eg mortality). Putting those variables (continuous and categorical) into a multivariate analysis shows me a certain effect, using "Fit Model" and "Nominal Logistic" option with subsequent manual backward el...
marc1

Discussions |
May 2, 2019 11:52 AM

9770 views | 1 replies
How PCA on correlations standardizes?

I have a confusing issue that I am trying to sort out, but having trouble finding an answer to anywhere. I am using JMP to run PCA on corrections using REML Estimation. I know that doing a PCA on correlations standardizes the data in some way and I am not sure how. Does anyone know how? I am trying to understand how because I am having trouble interpreting my results without knowing this. Specif...
Binoink

Discussions |
May 1, 2019 3:17 AM

8331 views | 9 replies
Lack of fit test issue

Hi, I built a simple logistic model to predict loan chargeoffs. The variables included all appear to be significant and the model passed the whole model test. However, the model didn't pass the Lack Of Fit test. So my questions are: 1. Does it imply that some important variables or interactions are missing thus it is not a good mordel? 2. Can I still use the odds ratio/estimate to calculate the im...
Nancy

Discussions |
Apr 30, 2019 4:07 PM

11514 views | 4 replies
How to create a indicator column for double data with a formula

I' dlike to create a formula indicator column for double data by applying the following JSL Code: dt << Clear Column Selection(); dt << Select Duplicate Rows(); dt << Name Selection in Column( Selected( 1 ), Unselected( 0 ) ); dt << Clear Select();Despite I 'm getting the right results, the code creates a lot error messages. It would be great if the code could be improved.
Thomas1

Discussions |
Apr 30, 2019 7:38 AM

6352 views | 6 replies

Previous
Next

Latest Discussions

How PCA on correlations standardizes?

I have a confusing issue that I am trying to sort out, but having trouble finding an answer to anywhere. I am using JMP to run PCA on corrections using REML Estimation. I know that doing a PCA on correlations standardizes the data in some way and I am not sure how. Does anyone know how? I am trying to understand how because I am having trouble interpreting my results without knowing this. Specif...
Binoink

Discussions |
May 1, 2019 3:17 AM

8331 views | 9 replies
t-test not listed

T-test option not listed?
yurimalkova

Discussions |
Apr 28, 2019 11:20 AM

4743 views | 1 replies
Correlation matrix is not positive definite and singular?

Hello,I am trying to do a factor analysis (PCA) on a large data set. It has 181 columns and 163 rows, values are between -6 and 8. I have started the factor analysis and the eigenvalues and scree plot looks good.Below all the factors it says: "Warning: the Correlation matrix is not positive definite". Can someone help me understand what it means?I try to perform the analysis using Maximum Likeliho...
luinel

Discussions |
Apr 28, 2019 5:24 AM

5202 views | 1 replies
table of fold change P value and FDR for comparison of groups

I have datasets with many response variables (~15K) and many samples (~7K). I have clustered the samples based on prior knowledge into 10 clusters, and need to define the variables that are characteristic for each. I want to generate a table/matrix that lists all the variables vs the clusters, with the fold change (ratio) in mean response values (each cluster vs all other samples together) with...
genecb

Discussions |
Apr 27, 2019 2:44 PM

4430 views | 3 replies
Creating JMP script for data manipulation

Hi i want to create a JSL for following table title1Title2Title3stack1stack2stack3..............stack(n-1)stacknACE0.55.0100..........2045.65BDF1.521055.35.........2241 for this table i want to create a script which will create a new table with stacked all columns from stack1 to stack n. then in new table add new column at the end which will put numbers 1,2..25 abd repeat same sequence till end o...
Probe_PE

Discussions |
Apr 25, 2019 10:29 AM

3711 views | 4 replies

Previous
Next

Latest Discussions

Chi square or Cochran's Q test

Okay, so i have to decide whether i should use chi-square or Cochran's Q test for one of my study.If i assume meat as experimental unit (EU) and impose 6 different wood smoke (like apple smoke, cedar smoke, hickory smoke etc.) on EU and consumers (people) act as observational unit (OU). I have 10 consumers and each one will taste each treatment (6 treatments) and respond liking (9 point scale), an...
sharmachetan

Discussions |
Apr 16, 2019 3:54 PM

3037 views | 0 replies
Selecting Number of Clusters in Hierarchical Clustering

One way to select possible number of clusters in hierarchical methods is to identify the relatively large changes in distance as number of clusters change (see table below). When I look at the actual distance measure from the table (clustering history below dendogram), there is a bigger jump from 3 clusters to 4 than from 4 to 5 (smaller), suggesting 4 may be the right decision. However, when you ...
pratyushdash

Discussions |
Feb 23, 2019 5:51 PM

3091 views | 0 replies
Beta Generalized Regression and adjusted chi-square values

I have a data set from a two-choice rodent feeding trial. We were testing the effectiveness of 10 deterrents by coating them on seeds and offering them to rodents alongside control seeds that were uncoated. The explanatory variable is which of the 10 deterrents the treatment seed was coated with, and the response variable is the proportion of control seed and treatment seed consumed. The question...
Mananahi

Discussions |
Feb 13, 2019 9:58 AM

2379 views | 0 replies
DF Dens for repeated measures ANOVAs

Dear JMP Community, When I run repeated measures ANOVAs with JMP (RMS, with Subject as a random factor), I have noticed that when a certain factor is crossed with Subject, the corresponding DF Den stays independent while the DF Dens for the other factors are put together as “Residual”. Please see Images 1-3 of the attached file on how “DF Den” under “Test Denominator Synthesis” change across imag...
mu

Discussions |
Feb 6, 2019 8:10 AM

4100 views | 0 replies
Partition and Pruning

I'm working with a dataset of about 27,000 rows and am trying to use 9 factors to predict a response using the partition function and a decision tree. I'm using both k-means and validation. When I tell JMP to Go, it will split 100-200 times, however the Split History shows me very little improvement after about 20 splits. For what I'm trying to do, I want to back up to the 20th split, but I don'...
NG

Discussions |
Jan 30, 2019 8:25 AM

3417 views | 0 replies