JMP User Community

Latest Discussions

JSL won't set column Format

Hi all,I'm trying to copy the column names, data types, modeling types and formats from one table into a new one, but when I try to set the column format, it never takes and just reverts to "Best". I've been banging my head against this for a while and am completely stumped why it's not working. Below is my code and the resulting output that shows the column format is valid but just doesn't stick....
awoj

Discussions |
Mar 22, 2019 9:59 AM

10513 views | 7 replies
JSL fill to end of table using first row value

Hi, Using JSL script, I want the first cell value in "Intercept" column to Fill to end of table with the same value in first cell. Can anyone show me how to write it in script?
ReginaHong

Discussions |
Mar 22, 2019 3:37 AM

10660 views | 4 replies
Cpk Analysis for many parameters

I understand we can get single or multiple parameters Cpk analysis by using the Process Capability. But that feature is useful to dive in to few parameters. But i need to run hundreds of parameters for Cpk and sort them ascendingly. Then i only check those parameters with low Cpk and look into more details like process capacility. Any idea how to achieve that?
OneNorthJMP

Discussions |
Mar 21, 2019 6:30 PM

7803 views | 5 replies
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

6816 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

11093 views | 19 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

11093 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

5427 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

2993 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

4786 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

8241 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

2888 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

2231 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

3888 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

3248 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

2416 views | 0 replies