JMP User Community

Latest Discussions

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

5661 views | 2 replies
multiple join

Hey, I am trying to join multiple tables and copied the SQL script from the JMP Query Builder into a script, adding some commands in the beginning. Probably, it doesn´t work as it´s SQL and not JSL language? My problem is that in JMP Query Builder I do not have the option to decide which columns should be chosen for the matching of the rows. Anybody, who can help me out here? This is the script I ...
Pacco

Discussions |
Mar 20, 2019 1:05 PM

4586 views | 1 replies
Inconsistencies in value ordering of numbers stored as character strings

Hi,I've recently found something curious in JMP Pro 14.2 : The default value of the value ordering property of a character column is not necessarily consistent with the sort order of the same column. An example : The French chart of accounts uses an articulated code as the ID of defined accounts. In such a system, 101 is a subdivision of 10, and so on. Thus, the ID must be stored as a character co...
yvesa_roy

Discussions |
Mar 20, 2019 9:19 AM

6301 views | 2 replies
Importing XML directly to data tables

Hello,I want to import a data set from (well formed) XML directly into a data table. This is something that Excel can do so I'm sure JMP can! The XML and the final data tables look like the examples below; there are a set of tests with results for individual pins, associated with a die, all part of an overall lot, with associated attributes such as tester or x,y coordinates (it's based on semicond...
matthew5

Discussions |
Mar 19, 2019 11:55 PM

20459 views | 10 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

3277 views | 3 replies

Previous
Next

Latest Discussions

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

5661 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

3277 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

5060 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

8815 views | 6 replies
What is the meaning of numerical arguments in Legend or Overlay functions?

Hi,I am a newbie to JSL. I am very confusing about the argument values of legend and overlay functions in Graph Builder. For example, 19-21 and 25-27 in the following script. When I change these values, the graph seems no changes. Besides, I found "Overlay( 0 )" in some scripts. What are the meaning of these values? Thanks a lot in advance! dt = Open("$SAMPLE_DATA/Hybrid Fuel Economy.jmp"); dt <...
chiwei

Discussions |
Mar 17, 2019 12:01 AM

4936 views | 4 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

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

2376 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

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

2556 views | 0 replies