JMP User Community

Latest Discussions

how to query an external data base to the existing data table in JMP

This is the code that currently works , but i would like to automate it and probably hard code the section in BOLD Italics below - which is the list of CMOS_Lot-Wafer from the "Wafer List" datatable, I have also attachged the code that i tried to hard code this section and does not work. Could someone take a look at it and help me out please, Thanks (Wafer list is the user list that the user w...
varshini

Discussions |
May 7, 2019 1:50 PM

2229 views | 2 replies
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

2212 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

9461 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

7669 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

10831 views | 4 replies

Previous
Next

Latest Discussions

how to query an external data base to the existing data table in JMP

This is the code that currently works , but i would like to automate it and probably hard code the section in BOLD Italics below - which is the list of CMOS_Lot-Wafer from the "Wafer List" datatable, I have also attachged the code that i tried to hard code this section and does not work. Could someone take a look at it and help me out please, Thanks (Wafer list is the user list that the user w...
varshini

Discussions |
May 7, 2019 1:50 PM

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

7669 views | 9 replies
t-test not listed

T-test option not listed?
yurimalkova

Discussions |
Apr 28, 2019 11:20 AM

4515 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

4949 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

4104 views | 3 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

2841 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

2886 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

2228 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

3883 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

3245 views | 0 replies