JMP User Community

Latest Discussions

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

1796 views | 3 replies
Blocks of data - reorganization

Hello! I have "blocks" of data, where multiple rows correspond to one data point. Within this block, I have a column where some values are stacked. I wish for these values to be in a single row.

By scripting, how do ISave the value <= 1 in Col ACreate new column, Col A_2Insert saved data from step 1Repeat with all blocks. Blocks are illustrated below by: Row A,B; Row C,D; Row E,FThe distance betw...
StarfruitBob

Discussions |
May 19, 2022 1:55 PM

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

5450 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

1841 views | 4 replies
DoE disallowed combination script/filter not working as expected

Hi, I keep getting runs in my design that should be restricted by my disallowed combination script. Or perhaps I'm not understanding the syntax. I have tried it both using the filter and as a script. An example where the combination of S2S==5.8 & L2L>4 is not allowed, yet I get multiple runs that do not conform to that restriction (run 4, 5, 10). I attached the script for the design as well.
mvanderaa1

Discussions |
May 19, 2022 5:56 AM

1772 views | 3 replies

Previous
Next

Latest Discussions

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

5450 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

1841 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

1240 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

2065 views | 4 replies
DOE with whole plots and blocking factor - how to improve the design?

I am trying to make a DOE for an experiment where I have one continues variable and two discrete numeric variables that are very hard to change (more information in the image below). My questions are:1. I am running the test by columns in a 96 well plate, so is there a way to define that no matter how many runs are needed, a plot will always have up to 8 runs?2. As is, even with 192 runs in 24 p...
Lavik17

Discussions |
May 18, 2022 6:20 AM

1786 views | 1 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

627 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

769 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

989 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

698 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

2506 views | 0 replies