JMP User Community

Latest Discussions

how do a number sequence to unique values?

I have the following Column1 and need to create a new column containing the sequential number of repetitions in Column1 Column1aaabbc The resulting table should look like this:Column1Column2a1a2a3b1b2c1 Any suggestions how to code in in JSL? (or in column formula?) thank you!
rs

Discussions |
Mar 21, 2019 2:42 PM

7167 views | 4 replies
Simulating data to generate larger data set for building models

Dear JMP community, I'm trying to work out a way to generate simulated data to better train a model I'm building. I have a decent sized data set -- a few thousand data points, but would like to generate simulated data that maintains a similar structure as the original data in order to improve upon the model. I'd like to have somewhere around 20K-50K data points with a similar structure in orde...
SDF1

Discussions |
Mar 21, 2019 1:44 PM

12418 views | 19 replies
Summarize response data to multiple response modeling type

I have a table of lots and wafers, which have been assigned a response code based on yield (red, green, blue; not my choice, but it's what I have to work with). There are combinations of lots and wafers that have multiple responses assigned to them. What I want to do is summarize the table by lot and wafer, and where a combination has multiple repsonses add all values to the variable. From: To:
MarkDayton

Discussions |
Mar 21, 2019 12:49 PM

14806 views | 9 replies
Multiple comparisons test on a Generalized Linear Model

Hello, I was wondering whether it is possible to adjust for multiple comparisons (for instance with Tukey's test) after creating a generalized linear model using the Fit Model option. The goal would be to compare a volume of interest (continuous variable) between three groups of patients (class variable), after adjusting for a bunch of other covariates. When I create (fit) the model, the volumes b...
pfotiad

Discussions |
Mar 21, 2019 10:12 AM

10038 views | 4 replies
Writing a data table in Python

I perform extensive post-processing in Python and then move that data to jmp for analysis. Is the data table format standardized or documented somehow so that I can write jmp files directly? Right now I am writing to an intermediate CSV and then importing which is just another step to go wrong. The answer to a similar question from last year suggested that the user write their data to a JSL script...
TheSource

Discussions |
Mar 21, 2019 5:01 AM

5665 views | 2 replies

Previous
Next

Latest Discussions

Simulating data to generate larger data set for building models

Dear JMP community, I'm trying to work out a way to generate simulated data to better train a model I'm building. I have a decent sized data set -- a few thousand data points, but would like to generate simulated data that maintains a similar structure as the original data in order to improve upon the model. I'd like to have somewhere around 20K-50K data points with a similar structure in orde...
SDF1

Discussions |
Mar 21, 2019 1:44 PM

12418 views | 19 replies
Writing a data table in Python

I perform extensive post-processing in Python and then move that data to jmp for analysis. Is the data table format standardized or documented somehow so that I can write jmp files directly? Right now I am writing to an intermediate CSV and then importing which is just another step to go wrong. The answer to a similar question from last year suggested that the user write their data to a JSL script...
TheSource

Discussions |
Mar 21, 2019 5:01 AM

5665 views | 2 replies
Augmenting a Full Factorial Design

This is based on a recent collaboration with a colleague. He had executed a 3 factor full factorial design with 2 centerpoint runs (a classical, easy design for 3 factors). The results of the analysis of the design showed strong lack of fit, and test for "curvature" (i.e. that there is a quadratic effect missing in the model) was conducted, and that had strong statistical significance. With th...
MathStatChem

Discussions |
Mar 19, 2019 3:36 PM

3289 views | 3 replies
Prediction Interval for Poisson Distribution

Dear JMP Communities, I have data that are count/space. In my case, (number of events occured / time). As such, it is naturally I would fit these data using Discrete Fit > Poisson. Afterwards, JMP produces the fitted Poisson with results of Upper/Lower 95% Confidence Interval per below photo. My question is : How do I get Upper/Lower 95% Prediction Interval? Thanks for the pointer. B.r,Chris
Zappy

Discussions |
Mar 19, 2019 3:00 AM

5067 views | 3 replies
how do you get an r2 and AICc value for a custom nonlinear regression model? How do you adjust the curve for built in regression models?

I don't know what equation best fits the line. I think that the curve for some of my data looks like a power function. Since I don't know the exponent, I used the custom model for nonlinear regression. I need an R2 and AICc values to compare different models. I created a column using the power equation and then went to analyze to modeling to nonlinear and put in my y values and then put in the pow...
des2870

Discussions |
Mar 18, 2019 7:58 AM

8824 views | 6 replies

Previous
Next

Latest Discussions

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

3092 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

2382 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

4104 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

3420 views | 0 replies
I want to use LASSO and Group LASSO in JMP

I'm involved in a project where we are applying lasso to build a logistic regression model from a "black box" set of predictors. I need to get JMP Pro before trying out JMP's implementation. I'm doing all the analysis in R at present. Does JMP Pro also include group lasso? I've found through using JMP Cluster Variables (CLUSVAR) that I can naturally group my predictors prior to group lasso. F...
gene

Discussions |
Nov 2, 2018 7:43 AM

2558 views | 0 replies