JMP User Community

Latest Discussions

check if data exist in another table

Hi, I have 2 tables A and B, each has a column "email" and "id". I want to add a new column in table A, if that row has "the same email OR same id" showing up in table B, then "YES", if no then empty. Could someone help me how to write this script? Thank you.
joann

Discussions |
Mar 11, 2021 10:35 AM

4117 views | 7 replies
combine formula

Hi, could someone help me combine the 2 formulas below? The second one is simply minus the time of day part. Thank you. ---------------------------------------- New Column( "week start", Numeric, "Nominal", Format( "m/d/y", 12 ), Input Format( "m/d/y" ), Formula( If( Day Of Week( :WR_Date ) == 1, (:WR_Date - In Days( Day Of Week( :WR_Date ) )) - In Days( 5 ), (:WR_Date - In Days( Day Of Week(...
joann

Discussions |
Mar 11, 2021 8:40 AM

1770 views | 4 replies
full factorial plot

Hi everyone.could someone explain me what is the meaning of the blue line?
hillel

Discussions |
Mar 11, 2021 4:29 AM

1286 views | 1 replies
Adding moving Average to a bivariate graph

Hello,my data table looks something like this:dataBeforeAvg = datadataMovingAVG = calculate moving average 7 days back (based on dataBeforeAvg column)doing fit x by y graph I have a graph with regular dataBeforeAvg on Y and date on Xwhat I want to do is take the moving AVG line and stick it on the graph above is this possible in JMP 12?
itzikd

Discussions |
Mar 11, 2021 4:26 AM

1359 views | 1 replies
Repeated Measures analysis doesn't return results for one treatment

Hi Folks,I'm at a loss. My experiment is cells with 4 different treatments and over the course of 5 time points. I have 5 biological replicates of this experiment. The script doesn't return data for one of my treatments. They are called: Control, Catalase, LewisA, LewisX.I'm not even sure what information I should share.Please help.Thanks in advance. Fit Model( Y( :SqrtLive ), Effects( :Treatme...
jrhughes

Discussions |
Mar 11, 2021 4:09 AM

1150 views | 2 replies

Previous
Next

Latest Discussions

Adding moving Average to a bivariate graph

Hello,my data table looks something like this:dataBeforeAvg = datadataMovingAVG = calculate moving average 7 days back (based on dataBeforeAvg column)doing fit x by y graph I have a graph with regular dataBeforeAvg on Y and date on Xwhat I want to do is take the moving AVG line and stick it on the graph above is this possible in JMP 12?
itzikd

Discussions |
Mar 11, 2021 4:26 AM

1359 views | 1 replies
Repeated Measures analysis doesn't return results for one treatment

Hi Folks,I'm at a loss. My experiment is cells with 4 different treatments and over the course of 5 time points. I have 5 biological replicates of this experiment. The script doesn't return data for one of my treatments. They are called: Control, Catalase, LewisA, LewisX.I'm not even sure what information I should share.Please help.Thanks in advance. Fit Model( Y( :SqrtLive ), Effects( :Treatme...
jrhughes

Discussions |
Mar 11, 2021 4:09 AM

1150 views | 2 replies
Fill consecutive rows

I have a large data set and will like to fill consecutive rows with top value.
pankti

Discussions |
Mar 10, 2021 5:32 PM

3188 views | 5 replies
How to plot the estimates (fixed terms) of a linear mixed model

Hello, I have regular JMP (no Pro) and have used a linear mixed model using the REML option having as fixed terms 3 single and 3 crossed terms. All single terms used were nominal with 4, 3 and 2 levels respectively. I want to plot the estimates (fixed terms) as a standardized coefficient with respective associated 95%CI as significance level. However, I am unsure in the output where (or if) I can ...
Catarina

Discussions |
Mar 10, 2021 3:21 PM

3968 views | 9 replies
BMI percentile calculations

For patients < 18 years of age, their obesity is determined by age, gender specific BMI percentiles . CDC had codes to do this in SAS https://www.cdc.gov/nccdphp/dnpao/growthcharts/resources/sas.htm I am wondering if this is possible to do this in JMP. I currently have to depend on a SAS user to do this for me..
Sandeep123

Discussions |
Mar 10, 2021 3:13 PM

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

1339 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

1196 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

1016 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

1284 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

3687 views | 0 replies