JMP User Community

Latest Discussions

Group columns based on number of value in a table

I have this table with three columns (dut, vcc, result) (for exemple) :dut | vcc | result | 1 | 1.1 | pass 2 | 1.1 | pass 3 | 1.1 | pass 4 | 1.1 | pass 1 | 1.2 | pass 2 | 1.2 | fail 3 | 1.2 | pass 4 | 1.2 | pass 1 | 1.3 | pass 2 | 1.3 | fail 3 | 1.3 | fail 4 | 1.3 | failAnd I want to group by vcc the number of pass so have this table :vcc | number | 1.1 | 4 1....
OrderedColt522

Discussions |
May 20, 2022 3:23 AM

1045 views | 1 replies
DSD Even-Order Effects Estimate and Statistical Significance

Hi, community, I am new to definitive screening design and I am trying to get my head around the data I got recently. I had 6 factors, one of which was a categorical variable, and two responses. I did an 18 run DSD which only identified 3 factors to be active. The second stage for determining the even-order effects identified all possible 2-factor interactions to be included in the model for one...
Kimani

Discussions |
May 20, 2022 1:11 AM

3581 views | 9 replies
rotate the gradient legend

Hi, is there a possibility to rotate the label of a gradient legend?

hogi

Discussions |
May 20, 2022 1:09 AM

878 views | 1 replies
Memory Demands of Multiple Correspondence Analysis

A couple of days ago I tried, somewhat thoughtlessly, an MCA on four variables from the Twitter record. These were all user names, user screen names, in-response-to names, and the like. All are alphabetic of random length. The procedure ran perfecty.Now I have started to redo the analysis, thinking first. My obvious mistake. on a 4257 case file, I cannot get the MCA to finish executing (I have n...
LNitz

Discussions |
May 20, 2022 1:08 AM

1503 views | 2 replies
Calculate time difference and summing the values

I have a table with a time column with this format: m/d/y h:m:sI would like to create a new column called CumTimeSec that will show the cumulative time difference up to that row.For example,Time TimeCumTimeSec5/11/2022 5:30:03 PM05/11/2022 5:30:08 PM55/11/2022 5:30:20 PM175/11/2022 5:30:23 PM 20 I figured I could use this code to calculate the difference between each row, but I'm not sure how to s...
Lavik17

Discussions |
May 19, 2022 2:57 PM

1844 views | 3 replies

Previous
Next

Latest Discussions

rotate the gradient legend

Hi, is there a possibility to rotate the label of a gradient legend?

hogi

Discussions |
May 20, 2022 1:09 AM

878 views | 1 replies
Missing/Absent Data Treatment on JMP - Two-way ANOVA

Hi there. I am a new user of JMP version 16.0. I am using student scores to analyze the prediction scores. I am utilizing the Fit-to-Model. There are data where students are absent during the test. Thus, I leave the score as a character such as 'ABS', set as numeric - continuous at the column setting. I develop a linear model to analyze the prediction and the results are successfully be calculated...
Alauddin_NS

Discussions |
May 19, 2022 8:08 AM

5668 views | 5 replies
Correlations with ordinals

Hi, From correlations results in design evaluation I don’t understand how you estimate the correlation ofan ordinal and a continues factor and the correlation between two ordinals. If I understand correctly, the correlation between continues is the absolute value of Pearson correlation but what is it when ordinals are involved?I can see that in ordinals the available correlations are (nr of levels...
Elef

Discussions |
May 19, 2022 8:02 AM

1896 views | 4 replies
How to Get specific input values from subset data table to be placed correctly in a JMP script to save to original data table?

Hi, I am not sure what is wrong with my script. It is supposed to take the user input values of PQA (a categorical variable) and produce output scripts that contain customized One-way results for each PQA, using a subset data set to get the information needed to read into the scripts that are saved to the original data table. For example, when I run the following JMP code on the toy Data table wi...
kachveder

Discussions |
May 19, 2022 5:03 AM

1282 views | 2 replies
How do I open Excel in JSL to run the specified VBA?

Hello!
How do I open Excel in JSL to run the specified VBA?For example, run "sub tt()" in "C:\1\ book1.xlsm ".
This question has been raised in the community but has not been answered.
Of course, this screenshot is just a hint.This is not how the VBA is implemented.Thank you very much!
lala

Discussions |
May 19, 2022 4:12 AM

2119 views | 4 replies

Previous
Next

Latest Discussions

Validate column values (make sure all values in column follow a specific pattern)

Is there a better way rather than iteration of all the rows to validate values in column? Let's say before making something with the column I want to make sure that all values in column match specific Regex. Like so:!IsMissing(Regex(Column(myColumn)[1], "^\w+(\d{3})\w+$", "\1"))I can iterate through each row to make sure that all of them match, but maybe there is a better way?
miguello

Discussions |
May 6, 2022 11:09 AM

639 views | 0 replies
SUR (Seemingly Unrelated Regressions)

HI, How to find estimators of FGNLS and NLS (Seemingly Unrelated Regressions) Using JmpPro.# Note that it is present in SAS in the proc syslin
and it is in stat in the nlsur command Regards
Raaed

Discussions |
May 5, 2022 4:45 PM

798 views | 0 replies
Friedman post hoc analysis

Hello, I am trying to do a matched sample analysis across three different factors. I wanted to:1. Confirm that my sample would be what I pick for 'Block" when I do Fit Y by X when running Friedman's test2. Is there a post hoc analysis in JMP that I can use? I dont see Nemenyi or Conover as an optionThanks for your time.
pnakashe

Discussions |
May 5, 2022 12:02 PM

1015 views | 0 replies
JMP script: Script Alarm Control chart- Table with atypical batch number and values

Hello everyone,I am trying to make a table with the OOT (out of Trend) batches with their respective "atypical" values.I used for that the "script alarm" function as I could found some exemples on the JMP community. Here is my script: z_KSigmaZ =1.4; // Création de la Carte de controle si N catégories > 5 Names Default To Here( 1 ); If(N Items(Associative Array(:"RNS/NS tordu (srg)")) > 5, Gr...
Sebastienlg

Discussions |
Apr 29, 2022 6:29 AM

713 views | 0 replies
How to create a graph builder box plot with mean values, and including the "group X" variable in the legend

I'm using JMP 16.2.0 and I'm trying to automatically generate a graph builder with box plots and their mean values with the group X variable as the color. I'm using a bar chart with style=floating to display the mean value (inspired by this topic)My current graph:This is almost what I want, except for a few things.1. I'd like the Group X variable (Recipe) to be visible in the legend as well. One w...
mvanderaa1

Discussions |
Apr 20, 2022 4:13 AM

2555 views | 0 replies