JMP User Community

Latest Discussions

Fill in Missing Data Based on previous column [cell] value

I apologize for this redundant question about column fill but for the life of me i can't find any of the previous topics. I have a data table that is filled out in an incomplete manner. I need to fill the missing cells below each value with its predecessor. I know it is a Column Formula script that uses the Lag() and Row() but can't find the correct syntax.
Yngeinstn

Discussions |
Mar 19, 2021 6:50 AM

2388 views | 1 replies
Making a Mixture Design that Does Not Sum to 1.0

I am trying to make an I-optimal mixture design with 3 components that add to 0.883, with the remainder 0.117 being a fourth, but constant, ingredient. I know a possible work around is to normalize my constraints, but to avoid confusion in reporting the information I would like to have the three components add to 0.883. I have tried to add linear constraints (shown in the attached screen shot) but...
David_J

Discussions |
Mar 19, 2021 6:49 AM

1975 views | 2 replies
Where Clause in graph loop

I have some code that is designed to build a report based on some filtering. It will be fed two lists, the first will determine which materials get pulled (in this example that will be Gender_List), the second determining which properties get graphed (In this example that will be Property_List). The idea being that there will be a loop through each Gender that will create a matrix of graphs for...
Evan_Morris

Discussions |
Mar 19, 2021 5:16 AM

4451 views | 8 replies
why is last menu hierarchy appears on the left not the right?

How can I get screening design appearing to the right in the above?
0465

Discussions |
Mar 19, 2021 5:00 AM

1400 views | 1 replies
about the project

hi, is it possible to modify a part of the screen in the project: see the image.I would like to put some colors and titles. best regards
Françoise

Discussions |
Mar 19, 2021 4:16 AM

1593 views | 3 replies

Previous
Next

Latest Discussions

why is last menu hierarchy appears on the left not the right?

How can I get screening design appearing to the right in the above?
0465

Discussions |
Mar 19, 2021 5:00 AM

1400 views | 1 replies
about the project

hi, is it possible to modify a part of the screen in the project: see the image.I would like to put some colors and titles. best regards
Françoise

Discussions |
Mar 19, 2021 4:16 AM

1593 views | 3 replies
Filtering Pareto charts by column.

I have a very large dataset of manufacturing defect bin data.My columns are the manufacturing batch IDs (called lots), and then each column is a defect bin, with the numeric value for that particular defect bin for each lot. In JMP Pareto chart, the input needs all defect bins in one column. So, I have to make another table by stacking those defect bins using Table>Stack. This makes an even larger...
spoikayil

Discussions |
Mar 18, 2021 12:53 PM

2165 views | 2 replies
How to explore the baseline level effect on response size (i.e. CFB)? Is fit model the right tool in JMP?

Hi All, We have a test that compared the benefit (data reading, numerical data) of two different treatments over a couple of time points (baseline, T1, T2, etc). There are also some other effects: test sites, gender, etc.For primary objective, I used the "Fit model" and put the data reading as Y, treatment, baseline level, time point, gender, subject ID(random factor), some 2-factor interactions i...
Diana

Discussions |
Mar 17, 2021 8:07 PM

2345 views | 2 replies
Incorporating measurement error into Dunnetts analysis

I want to start incorporating my measurement error into my dunnetts analysis. I have attached a file below which has two variables which I am trying to determine if they are different. Both variables were tested 3 times and each test was measured 3 times. Since I am trying to determine if the variables are different in the past I've always just averaged all 3 measurements and used as the value ...
wyler0

Discussions |
Mar 17, 2021 3:23 PM

2848 views | 4 replies

Previous
Next

Latest Discussions

What does it mean when the solution path for Elastic Net is not single-valued?

Dear JMP Community, (W10, 64-bit, JMP Pro 15.2.1) I am running a model to assess the active predictors. I am doing this by using the Autovalidation add-in to generate a Null Factor for my data. I then use the GenReg platform to find estimates for each possible X-factor and then Bootstrap those estimates to get a better assessment of the contributions to the response. I came across a very stran...
SDF1

Discussions |
Feb 15, 2021 12:35 PM

1578 views | 0 replies
Return number from specified row of calculation column in either a text edit box or number edit box in an add in

Hello, I'm attempting to build an application in application builder. I have two modules currently. The first module is a series of number edit boxes and lists that allow the user to input values and make selections.After pushing a button, the inputs and/or list selections update table variables in a data table that subsequently updates column equations. The data table opens in the background so ...
tys5384

Discussions |
Feb 15, 2021 7:33 AM

1386 views | 0 replies
generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

1177 views | 0 replies
Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1513 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

4251 views | 0 replies