JMP User Community

Latest Discussions

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
If row column value equals any values of any array then... What is the general form of this formal?

How do I write an If statement (or whatever the right function is) to evaluated when a row's column value = any value in an array?

Example:If( :ColToCheck == [Any of these values] , then 1, else 0 )
BSwid

Discussions |
Apr 26, 2019 7:02 AM

9685 views | 6 replies
Date Based Equations, Line of Fit, Setting X to mean different units of time

With JMP often we are asked to roll up raw data, group it by week, month, quarter, year, etc. Then go look for a trend. What are the best practices for dealing with longitudinal data? Data TypeModeling TypeFormatMaybe tricks in graph builder?I'm having trouble getting the graphical output to be both executive presentation friendly AND include an equation that makes sense. For example, it's typ...
BSwid

Discussions |
Apr 25, 2019 4:19 PM

4899 views | 1 replies
Scripting Table Sort by User Defined Column

Warning - scripting newbie @ work. I'm working on a script, a part of which sorts the data table by the user selected column (obtained by ColList selection and Eval List). This does not work, it brings up the Sort dialog, which I don't want: dt << Sort( By(_userCol), Order(Ascending), Replace Table); When I hover over _userCol, the assigned column is shown in the scripting window. If I u...
markschahl

Discussions |
Apr 25, 2019 1:18 PM

25524 views | 5 replies

Previous
Next

Latest Discussions

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
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

3378 views | 4 replies
Nested effect

I have data for two species and two types of leaves. Species A and B, type R and L. I would like to check how species and type of leaves affects for example leaf area. However I have results of area measurements for several leaves assigned to each individual. Because of that I used nest function: Model effects:SpeciesTypeSpecies*typeLeaf number [Individual]But I receive “The model is missing an ef...
Kronika

Discussions |
Apr 24, 2019 6:21 AM

7439 views | 2 replies
JRP with embedded JMP table/file missing the report

HelloI was doing some K means and saved the clusters to my table and saved the cluster out as JRP file and chose the option to embed the table with the report and saved it. When I open the jrp, only the MP file associated is showing up, I do not see the actual JRP with the cluster out summaries.Is there any effective way to save reports with the tables? This seems to be occuring very frequently. N...
theseventhhill

Discussions |
Apr 24, 2019 12:54 AM

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