JMP User Community

Latest Discussions

How to evaluate each column?

Hi all,I have Amplitude 21 as an example data table, and for example, I want to determine if the amplitude passes or fail. How can I evaluate each columns if they are pass/fail? For example: Amplitude limit is 4. Every amplitude value with > 4 and < 4 will be marked as failed using a new column. Names Default To Here(1); dt = Open("$SAMPLE_DATA/Amplitude 21.jmp"); New Column ("Pass/Fail", Characte...
UserID16644

Discussions |
Dec 22, 2021 5:28 AM

1969 views | 4 replies
AUDPC

I conduct research within the agricultural field and I use excel like most people to organize my data. However, a common analysis is the area under the disease progress curve (AUDPC) to track the changes of the disease throughout the growing season. Is there any way to calculate the total area under a line graph without fitting a trend line/regression analysis.
travislr11

Discussions |
Dec 22, 2021 5:08 AM

2864 views | 3 replies
Question about JMP 16 graph color customize option

Hello, I'm unable to set the color for an indivdual variable in my graph using the customize feature. I was able to do this in JMP 14 but now with JMP 16, I'm unable to use this to set different colors for variables in the same graph. Examples provided as snapshots below. Currently, in version 16, if I select customize and go the marker option to select a color it changes all variables (markers)...
ndowidar

Discussions |
Dec 21, 2021 3:24 PM

3472 views | 6 replies
"If statement" does not work properly when running the whole script but if I only run the part in question it works well

Hi, I am note very experienced in scripting and have a question (may be I am missing some basic syntax here?).I use the following script to create in a data table new columns with an "if statement". For new column "Headache 1" this works well. For "Fever 1" it does not work. New column is created (but with data type numeric and data model continuous instead of character, nominal and if statement d...
MH1

Discussions |
Dec 21, 2021 8:30 AM

1364 views | 2 replies
Overlap / Gap Analysis by Row

I'm looking for a method to run a gap and overlap analysis across a set of data 1000-ish rows. Data are teams ranking their test coverage of each feature as 1, 2 or 3, Scores. I want to look for gaps across the rows where no group has scored it a 1 and also show where multiple groups rank as 1. A snapshot of the data table is below.Feature #FVTEVTCVTMSVGQCertHWPEMFG TestPDETCM / FAE?11 23 3122 ...
MuMover

Discussions |
Dec 21, 2021 8:19 AM

2254 views | 5 replies

Previous
Next

Latest Discussions

AUDPC

I conduct research within the agricultural field and I use excel like most people to organize my data. However, a common analysis is the area under the disease progress curve (AUDPC) to track the changes of the disease throughout the growing season. Is there any way to calculate the total area under a line graph without fitting a trend line/regression analysis.
travislr11

Discussions |
Dec 22, 2021 5:08 AM

2864 views | 3 replies
Calculating the Top of a Square wave from a Continuous Data

Hello, I would like to calculate the Top(not max) of an imperfect square wave signal that I measure, the distinction of the Top and Max is illustrated in the image below. It is somewhat the average of the high value right after the cliff at the edges of the signal. Is there a way to calculate the Top value via JMP? Thank you in advance!
Ashraff09

Discussions |
Dec 21, 2021 7:03 AM

1147 views | 1 replies
Design an experiment anticipating autocorrelation.

Is there a way to anticipate and account for potential affects of previous runs in an experiment? Two use cases: Lab - Samples are prepared using a mixer that cannot be (cost effectively) fully cleaned between runs. The samples are later treated using a process that, again, cannot be fully cleaned between every run.Continuous Process - A process is not shut down between runs, rather new condi...
ih

Discussions |
Dec 20, 2021 12:37 PM

1819 views | 5 replies
Problems performing a DOE

Hello,I am trying to solve different DOE exercises. However, JMP will not really let me perform this DOE. I have solved 4.1 - 4.4, but have difficulties from 4.5-4.7.Any suggestions or hints?4.1:We have four factors with 8 runs, and we then have a fractional factorial with a resolution of 4. 4.2: We have 4 factors: LG, TG, offset, and tube. 4.3:Fractional factorial experiments are good to find mai...
ProbitMeerkat86

Discussions |
Dec 20, 2021 12:10 PM

2165 views | 4 replies
'n' row average of a column based on a condition from other column -

Hi All,
I am looking for 'n' row average (in the attached example, n == 3) based on other coulmn (-- "Customer_ID"). If my row number for each group (customer) is integer multiplier of 'n' i.e. [Row == Integer Constant x n]. My basic formula works fine. But if Row != Integer Constant x n, it takes remaining rows from other group. Which is giving me wrong results.
What I want -
Best Case - Calculate...
HSS

Discussions |
Dec 18, 2021 11:28 PM

1368 views | 2 replies

Previous
Next

Latest Discussions

Expand Contours

Hi,

I understand that the contouring is done based on triangulation to data points, but is there a method for expanding them further to fit a custom SHP file I've imported into JMP? I've already set the alpha and the lowest value so the contour should cover the, 'most', area. Any other methods? Thanks!
MikeDereviankin

Discussions |
Dec 15, 2021 12:49 PM

729 views | 0 replies
Getting all Zeros for the AR(1) estimate/std error in a Repeated Measures Mixed Model Using JMP Pro

I am fitting a model of a continuous response against 7 fixed effects. When running the Standard Least Squares; my residuals plots/assumptions checks don't look too bad but the Durbin Watson test is suggesting an AR(1) structure in the residuals. This is expected for this particular analysis and is consistent with other data sets looking at the same response/factors. The Time Series platform also ...
lisa2442

Discussions |
Dec 14, 2021 7:32 AM

885 views | 0 replies
Export Functional Data Explorer prediction formula

Hi,I want to export the prediction formula generated by Functional Data Explorer either to Excel or Python (via Formula Depot), but there is a problem because the formula contains P Spline Coef() interpolation, which I think is not available in Excel or in Python libraries. Do you have any suggestions how to solve this?Best regards
ruskicar

Discussions |
Dec 14, 2021 2:11 AM

845 views | 0 replies
Need help with changing separators lines location in a variability graph

Hello,I need to change the locations of the separators line in the graph.In the attached image, I need the separators lined on the upper row (labeled ISI).I have tried to find how to do that without success.Thanks
SHRG

Discussions |
Dec 10, 2021 8:59 AM

1110 views | 0 replies
Change default setting for scale format in graph builder

Ive been using JMP on the Mac for a few years and now have to us the PC version (JMP® 16.1.0 (539038)
Microsoft Windows 10 Pro 64-bit (10.0.19042.0). I use graph builder a lot and find that the axis (either) "scale format" defaults to "fixed decimal" which does wacky things when trying to use certain increments for the scale.This is with the X axis set at increment of 0.05 with fixed decimal This...
DMW

Discussions |
Dec 9, 2021 4:29 PM

992 views | 0 replies