JMP User Community

Latest Discussions

Selecting duplicates with complete row values

How to select duplicate rows with conditions?
I have a table with duplicate IDs, but some of the values from other rows are missing. What I need to do is to delete the duplicate row with missing information and retain the complete one. For example:

IDNameAge1Jane121Jane 2John163Anna 3Anna154Mark Rows 3, 5 should be deleted. I know "Select duplicate rows( Match( :Col1, :Col2 ) );" but I'm not s...
UserID16644

Discussions |
Apr 9, 2025 10:42 PM

964 views | 4 replies
Missing Value Codes Don't Export To Excel

I need to export some JMP files to excel and cells that were marked as missing are empty in the resulting Excel file. Anyone figure out a way to keep it present?
SpannerHead

Discussions |
Apr 9, 2025 9:30 PM

1016 views | 4 replies
Fit a spline to a closed form (in this case an airfoil contour)

Hey everyone, Is there a way to fit a spline to a shape in graph builder (or any other platform?) I am trying to fit a spline to a set of X/Y data points that fall on the outside of an airfoil contour. So here is the data this is what the smoother function currently gives and this is what I would want (the blue fitted line) If I turn on the contour plot and have a value to put into c...
shampton82

Discussions |
Apr 9, 2025 8:30 PM

833 views | 2 replies
Permutation test

Dear reader, I'm looking at the correlation between peripheral metabolism (Insulin, glucose, HbA1c) and brain metabolites (NAA, Cho, mI) in T2DM and control group. I choose spearmans rho because there was no normal distrbution. Now i'm intressted in looking if there is a difference between the correlation. So for example is there a difference in the correlation insulin-NAA in T2DM compared to t...
Teun

Discussions |
Apr 9, 2025 11:58 AM

743 views | 2 replies
DOE without replicate runs not working

Hello,
I encountered a problem when trying to create a custom design without replicate runs.
I have 3 variables, all three are Discrete Numeric with (7,15, and 7) values.
When I enter the Custom design I enter my disallowed combination, model, desired number of runs (30), check that the number of replicated runs = 0 and ask to make design.

The resulting design has replicated runs (in my case it 8 out ...
VladimirB

Discussions |
Apr 9, 2025 10:56 AM

1956 views | 9 replies

Previous
Next

Latest Discussions

Missing Value Codes Don't Export To Excel

I need to export some JMP files to excel and cells that were marked as missing are empty in the resulting Excel file. Anyone figure out a way to keep it present?
SpannerHead

Discussions |
Apr 9, 2025 9:30 PM

1016 views | 4 replies
Permutation test

Dear reader, I'm looking at the correlation between peripheral metabolism (Insulin, glucose, HbA1c) and brain metabolites (NAA, Cho, mI) in T2DM and control group. I choose spearmans rho because there was no normal distrbution. Now i'm intressted in looking if there is a difference between the correlation. So for example is there a difference in the correlation insulin-NAA in T2DM compared to t...
Teun

Discussions |
Apr 9, 2025 11:58 AM

743 views | 2 replies
How to get value of duplicate columns?

Hi all, How can I get the value of a Column A and place it with the duplicate value in Column B? For example, this is my data: Column AColumn BAApple AppleBBanana MangoCMango This is the expected output: Column AColumn BAAppleAAppleBBananaCMangoCMango
UserID16644

Discussions |
Apr 8, 2025 5:46 AM

700 views | 2 replies
How to model responses when their sum is equal to 1?

Hello!

I have completed a DoE in order to model the particle size distribution. The distribution is measured by several screens. For each size range (e.g. <1mm, 1-5 mm, >5 mm), I have the proportion of particles, and the sum must be one. My question is how to model the three responses properly, taking into account that the sum of the responses must equal 1. I have included a synthetic table to...
Florent_M

Discussions |
Apr 8, 2025 5:45 AM

975 views | 3 replies
Life distribution: how to set the markers and weibull fit to use Kaplan-Meier or Turnbull estimates

Hello, The below is the test table I made. According to the description: https://www.jmp.com/support/help/en/18.1/index.shtml#page/jmp/event-plot.shtml#ww1386833 It meas there are total 100 samples. And exactly at 4 readings: 50, 100, 150 and 200, there are 25 new failures happened. So the failure rate I expected will be: 50, 25% 100, 50%, 150, 75% 200,100%. The markers in the Weibull plot ...
Doraemon214

Discussions |
Apr 7, 2025 3:16 PM

640 views | 2 replies

Previous
Next

Latest Discussions

Discovery summit book signings - official list of books?

Fellow JMP enthusiasts! During the 2024 Manchester Discovery Summit I was surprised to learn that the handing out and signing of books is a tradition. So, I am wondering whether there is a list of the books handed out & signed so far. If it exists, where to find it?I thoroughly enjoyed reading "Bitch" by Lucy Cooke, and I have a feeling "Hello World" by Hannah Frey will be a good read too.
Ressel

Discussions |
Feb 28, 2025 11:25 AM

493 views | 0 replies
Inquiry Regarding the Use of JMP and JMP Live (Suppress Eval?)

Hello, I am a user of JMP Live.
I am currently utilizing a simple function within JMP to leverage the Auto Refresh feature in JMP Live for dashboard purposes. However, while the function operates correctly on my PC, it does not work properly on JMP Live.Even though I have disabled "Suppress Eval" before executing Data Publish, when I later download the data, the column where the function should be ...
DJ_Kim

Discussions |
Feb 27, 2025 2:59 PM

533 views | 0 replies
query text files from zip folder in Azure blob file system secure (ABSS) url

Hi All,I wonder if anyone has the experience to query text files from zip folder through Azure blob file system secure (ABSS) url?
the url looks like format below. If you do, can you share some script lines how to connect to the url at least?

abfss://filesystemname@accountname.dfs.core.windows.net
dadawasozo

Discussions |
Feb 18, 2025 1:37 PM

458 views | 0 replies
Streamlining Data Workflows With JMP & MATLAB

Integrating tools like JMP and MATLAB offers a streamlined approach to engineering analysis, making workflows more efficient and reducing the need for redundant script rewriting. By leveraging JMP’s powerful data analysis and visualization capabilities alongside MATLAB’s robust computational tools, engineers can seamlessly combine the strengths of both platforms. This integration allows for the ra...
brycerjs8

Discussions |
Feb 18, 2025 7:07 AM

560 views | 0 replies
Question About F-Tests in GLMMs with Binomial Errors

Hi,
I have a question regarding Generalized Linear Mixed Models (GLMMs) in JMP pro. Most statisticians consider it inappropriate to use F-tests or t-tests to evaluate predictor contributions in GLMs or GLMMs with binomial errors. This is because F- and t-tests are based on sums of squares, which assume normally distributed residual errors.
While using a logit link function helps linearize the relati...
LanaMilana

Discussions |
Jan 17, 2025 2:21 AM

776 views | 0 replies