JMP User Community

Latest Discussions

referencing column using Column("name")

Hi,I have a "quick" question:dt = Open( "$Sample_data/Big Class.jmp" ); //// These don't work; dt << Select where( Column("sex") == "F"); dt << Select where( Column(3) == "F"); //// Only this works...why?? dt << Select where (:sex == "F");I am pretty sure all these options used to work for me.....has something changed? I am using JMP16.Reason I am asking is because I usually have the column name...
derchieh

Discussions |
Feb 25, 2022 4:49 AM

1729 views | 3 replies
Calling column from column list in formula

I'm quite sure I will feel stupid after seeing the answers but I currently have a brain hang up. I want to refer to a column from a list of columns in a new formula in JSL (for later looping over the list). Names Default To Here(1); dt = Open("$SAMPLE_DATA/Big Class.jmp"); mylist= dt<< Get Column Names(); dt << New Column( "myCol", Numeric, "Continuous", Format( "Best", 12 ), Formula(:height...
Feli

Discussions |
Feb 25, 2022 1:31 AM

1741 views | 2 replies
Incorrect 95% confidence interval range for matched pairs plot?

I am trying to create a bland-altman plot using the matched pairs function in JMP. I created the plot below and decided to double-check some of the statistics calculated on excel. I found that while the standard error and mean difference were correct, my upper and lower 95% confidence interval values were very different than the ones provided by JMP Pro 16 I tried to test out their match pair exa...
Querida

Discussions |
Feb 24, 2022 8:25 AM

3717 views | 2 replies
MSA Gauge R&R AIAG Version?

Hallo!JMP Verion 16.1Vorrede zu meinen Daten:Ich möchte einen Datensatz (2 nahezu gleiche Messysteme, darauf jeweils die 10 gleichen Personen mit 5 Wiederholungen gemessen) auswerten und den Varianzanteil durch die verscheidnen Massysteme zu erhalten. Dazu kann ich ja Gauge R&R oder EMP zur Analyse verwenden. Da alles mit dem gleichen Bediener gemessen wurde, würde ich bei der Analyse die 2 Messys...
CountableMarten

Discussions |
Feb 24, 2022 8:23 AM

2667 views | 4 replies
Conditional If then to return values for ranges

I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number 19,20,21,22,23,24,25,26,27 etc.)
ByrdQuestions

Discussions |
Feb 23, 2022 3:11 PM

1658 views | 2 replies

Previous
Next

Latest Discussions

MSA Gauge R&R AIAG Version?

Hallo!JMP Verion 16.1Vorrede zu meinen Daten:Ich möchte einen Datensatz (2 nahezu gleiche Messysteme, darauf jeweils die 10 gleichen Personen mit 5 Wiederholungen gemessen) auswerten und den Varianzanteil durch die verscheidnen Massysteme zu erhalten. Dazu kann ich ja Gauge R&R oder EMP zur Analyse verwenden. Da alles mit dem gleichen Bediener gemessen wurde, würde ich bei der Analyse die 2 Messys...
CountableMarten

Discussions |
Feb 24, 2022 8:23 AM

2667 views | 4 replies
Conditional If then to return values for ranges

I have written a formula to flag runs in campaigns (ex: consecutive days above 19.) HOw can I create a formula that will then generate the production values specific for campaigns greater than 9 days? (Examples: campaign 1, 2, 3=>No value whereas campaigns showing 1,2,3,4,5,6,7,8,9 would show the appropriate number 19,20,21,22,23,24,25,26,27 etc.)
ByrdQuestions

Discussions |
Feb 23, 2022 3:11 PM

1658 views | 2 replies
Why JMP Neural Networks Don't Need Data Normalization

When the data value vary widely, the data standardization process must be done first. Why does the JMP neural network do not need data standardization process?
changqi

Discussions |
Feb 23, 2022 12:15 AM

2512 views | 3 replies
How do you remove this random line from a graph?

When I am in graph builder working on a line graph, sometimes a random black line appears and I am not sure where it is coming from or what it's for. How do I get rid of it?

[Note: Variables in the column box are redacted out in this post, but there are items there.]
EdgeCurved

Discussions |
Feb 21, 2022 12:13 PM

1957 views | 2 replies
Force Excel Import Wizard to Use Character for All Columns?

I am trying to import several one sheet from several auto-generated Excel tables and then concatenate into a larger file. The problem is that the first row contains the 'blank' data which has no batch/lot/etc. info, and the Excel cells have 'general' as the format. The next three columns are empty for the 'blank' but full for all other rows (samples). The first (batch) always imports correctly ...
andersonmj2

Discussions |
Feb 15, 2022 7:30 AM

4081 views | 4 replies

Previous
Next

Latest Discussions

Setting Guardbands on Test Limits Using EMP

Hello. I am trying to use the EMP tool to help set guardbands to my test limits based on my gauge R and R data from a final test machine.I used 10 devices and measured these devices 5 times each, across 5 different test sites on the machine.I need to know how much to guardband my Upper and Lower specs. I am having trouble understanding how to apply the data in the EMP report. I feel like this is a...
Jbritsch04

Discussions |
Feb 2, 2022 8:49 AM

910 views | 0 replies
JMP > GraphBuilder > Parallel Plots >River / Sankey Plots > Maximum Items?

Hi JMP Community, I just came across an odd behavior in GraphBuilder with the Parallel Plot > Sankey Plot. If I limit the input to a maximum of 66 rows, the plot looks good. However, if I bump the number of rows to 67 or more,the output is no longer useful: no annotations: Is there a trick to maintain the axis annotations as shown in the first plot? Thanks. Best, TS
Thierry_S

Discussions |
Dec 9, 2021 3:30 PM

3240 views | 0 replies
Permutation Tests and Monte Carlo Cross Validations Using the Simulation Platform

I'm trying to do permutation tests and Monte Carlo Cross Validations with the Iris sample dataset as a MWE for our dataset. I'm not sure if I'm doing things and interpreting output correctly. 1) Create New Formula Column (Random->Sample Without Replacement) for the Species Column for Permutation Test. 2) Create a Validation Column (0.75/0.25 split) and a new Formula Column (Random->Sample Withou...
mjmg

Discussions |
Dec 1, 2021 7:53 AM

1010 views | 0 replies
Variability Chart Platform Factor Re-Insert Positions (Not Swapping)

Hello JMP Community, I understand dragging between any two factors swaps the location pairs in the Variability Chart platform. Is there a way to drag to specifically re-insert the factors instead? For example, can I drag "Layout" between "Horizontal" and "Wafer ID" in the attached screenshot instead of performing multiple drags to have the intended result? I am aware I can do this reordering with ...
Technician

Discussions |
Oct 26, 2021 11:04 AM

1327 views | 0 replies
Get (x & y) intercept values from linear fit of the linear region of a curve/data and store them in a new column

I have JMP data table with data from several parts for which a Capacitance 'C' has been measured as a function of reverse voltage 'V' (0 to -5 V in -0.1V step). A plot of [1/C]^2 vs V has a linear part for small reverse bias (say from 0 V to -0.5V and data is available at 0, -0.1, -0.2, -03, -0.4 -0.5 V within this range). How to do a linear fit to the points between 0 to -5V for each part, extrac...
Neo

Discussions |
Oct 22, 2021 10:15 AM

785 views | 0 replies