JMP User Community

Latest Discussions

How to apply a column formula on only a range of rows and not every row?

Hi, I am trying to create a column formula that calculates the mean of every 5 rows (for a specific column). Normally the formula are applied to every row using values in such row. Instead, I would like to use values from 5 previous row to calculate a mean value. I am been playing with the formula editor and try to use the Row() and other functions, but without success. Thanks a lot to anyon...
AC_AC

Discussions |
Jul 15, 2022 4:03 AM

1521 views | 1 replies
Using the Prediction Profiler to optimize for a certain range

Hi everyone,

I'm trying to use the prediction profiler in JMP in combination with the desirability function in order to optimize several models simulatanously.
There are several optimisation options in JMP implemented like maximizing, minimizing or matching a target. However, I need an option to match a range.Since there are only 3 adjustable points in the desitability function and I need a desirab...
Marco_

Discussions |
Jul 15, 2022 2:09 AM

5413 views | 11 replies
Exclude selected columns

Hello, I get a varying list of columns from a source and select these columns in my data table. The data table has many other columns, but I want to hide/exclude the columns which are not in the list provided to me while my script is running and doing some analysis... I can select all the columns which I don't need by line below:dt < <invert column selection (Provided_List) Next step: Exclude thes...
aumair

Discussions |
Jul 14, 2022 10:44 PM

6672 views | 6 replies
Including multiple mixtures in a data table

Is there a way in JMP 16 to include multiple mixtures of variables in a data table? I have three "mixtures" that are independent of each other and the components of each total 100% of each mixture. All three mixtures are factors of the response I am investigating.
LargeChipmunk17

Discussions |
Jul 14, 2022 2:41 PM

1210 views | 2 replies
Prediction profiler does not work if formula contains row statement

Hi, I can't get the prediction profiler to display predictions if my formula contains a Row() statement. MWE: the Formula for Column5: :x works fine: while the formula for Column4::x[Row()] results in the prediction not being computed: Obviously I wouldn't need the Row() statement in the above MWE, but I've run into this problem while trying to build something somewhat more involved. I'm usin...
LukasKuerten

Discussions |
Jul 14, 2022 12:57 AM

1724 views | 4 replies

Previous
Next

Latest Discussions

Exclude selected columns

Hello, I get a varying list of columns from a source and select these columns in my data table. The data table has many other columns, but I want to hide/exclude the columns which are not in the list provided to me while my script is running and doing some analysis... I can select all the columns which I don't need by line below:dt < <invert column selection (Provided_List) Next step: Exclude thes...
aumair

Discussions |
Jul 14, 2022 10:44 PM

6672 views | 6 replies
Including multiple mixtures in a data table

Is there a way in JMP 16 to include multiple mixtures of variables in a data table? I have three "mixtures" that are independent of each other and the components of each total 100% of each mixture. All three mixtures are factors of the response I am investigating.
LargeChipmunk17

Discussions |
Jul 14, 2022 2:41 PM

1210 views | 2 replies
Prediction profiler does not work if formula contains row statement

Hi, I can't get the prediction profiler to display predictions if my formula contains a Row() statement. MWE: the Formula for Column5: :x works fine: while the formula for Column4::x[Row()] results in the prediction not being computed: Obviously I wouldn't need the Row() statement in the above MWE, but I've run into this problem while trying to build something somewhat more involved. I'm usin...
LukasKuerten

Discussions |
Jul 14, 2022 12:57 AM

1724 views | 4 replies
How to check if list value exist in folder?

Hi all,I have files that needs to be checked if it is existing in a folder. If it does not exist, a prompt will show which file names are not in my list. Here's a snippet of my code://Sample Data dt = Open( "$SAMPLE_DATA/Quality Control/Diameter.jmp" ); New Column ("Machine Op", Character, Formula ( "Machine_" || :MACHINE || " Op_" || :OPERATOR ) ); dt_list =associati...
UserID16644

Discussions |
Jul 13, 2022 10:07 PM

1404 views | 3 replies
Custom Annotation Based on Framebox content

I would like to add an annotation to each individual frame of a graph builder report. Here is a (trivial) example... dt = Open( "$SAMPLE_DATA/Big Class.jmp" ); gb = Graph Builder( Variables( X( :height ), Y( :weight ), Group X( :sex ), Group Y( :age ) ) ); gb << SendToReport( Dispatch( {}, "Graph Builder", FrameBox, Add Text Annotation( Text( "Female-12" ), Filled( 0 ) ) ) ); In this ex...
hhggzz

Discussions |
Jul 13, 2022 1:26 PM

1671 views | 4 replies

Previous
Next

Latest Discussions

July/August classes from JMP Education

JMP Education is offering upcoming classes with a live instructor. Links go to the page in the course catalog with more information and a link to register. July 26-29: JMP: Reliability Analysis for Non-Repairable Systems August 9-12: JMP Pro: Analyzing Curves and Profiles Using the Functional Data Explorer August 16-19: JMP: Statistical Decisions Using ANOVA and Regression August 29-September 1: J...
Di_Michelson

Discussions |
Jul 11, 2022 8:50 AM

689 views | 0 replies
Urgent: covariance parameter estimates are all zero (i.e. estimate, Std error, confidence interval)

Dear All,I have been analysing a two factorial (3*4) RCBD repeated measures design by using the mixed model approach in JMP. Above is a section of the report I got. Why are the estimates zero. Other information include about the analysis include:1. 14 continuous variables measured four times at unequal time periods2. All the three covariance structures I tried (AR1, Toeplizt and spatial power) had...
MomentMonster90

Discussions |
Jun 13, 2022 5:53 AM

803 views | 0 replies
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

643 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

810 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

1031 views | 0 replies