Welcome to the JMP User Community!
Ask questions, get answers, meet other JMP usersLearning Resources
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resourcesLatest Discussions
-
How do I create a counting variable based on another column & transpose a table?
Hi all,I'd appreciate help with reformatting a clinical dataset. It records ~50 variables for multiple patients on multiple visits. So there are ~51 columns with one being an MRN or record number per patient. There are typically 6-7 rows of data per patient/MRN to report on variables taken at different visits. So 2 questions: 1)How can I generate a new incremental count variable that counts number...
acm
1503 views | 1 replies -
Process Capability - Summary report: color of process stability column
I made a process capability analysis of 7 processes. Although the 7th process is very unstable with stability index = 1,30 in the summary report it is labeled as green where is should be red as in the process performance report, see below. Is it possible to adjust the color of the Stability Index (SI) column to red according to the SI target?
frankderuyck
2262 views | 5 replies -
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
3388 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
1399 views | 4 replies -
full factorial plot
Hi everyone.could someone explain me what is the meaning of the blue line?
hillel
1061 views | 1 replies
Latest Discussions
-
How do I create a counting variable based on another column & transpose a table?
Hi all,I'd appreciate help with reformatting a clinical dataset. It records ~50 variables for multiple patients on multiple visits. So there are ~51 columns with one being an MRN or record number per patient. There are typically 6-7 rows of data per patient/MRN to report on variables taken at different visits. So 2 questions: 1)How can I generate a new incremental count variable that counts number...
acm
1503 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
1204 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
957 views | 2 replies -
Fill consecutive rows
I have a large data set and will like to fill consecutive rows with top value.
pankti
2561 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
3008 views | 9 replies
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
1183 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
1041 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
867 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
3137 views | 0 replies
JMP Events
-
ChinaShanghai May 29
-
1:00PM - 2:30PM EDTApr 16Jump into DOE: Hands-on Workshop
Jump into DOE Wednesday, April 16 | Live Web Workshop1:00 p.m. – 2:30 p.m. ET Hosted via Zoom...
-
12:00PM - 1:00PM EDTApr 17JMP for Teaching Statistics in Semiconductor Engineering Education
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/jmp-for-teaching-stat-semicon...
-
1:00PM - 2:00PM EDTApr 25Getting Started with JMP
New JMP users will learn how to: Easily navigate JMP using the JMP Starter. Import all types o...
-
2:00PM - 3:00PM EDTApr 25Gleaning Valuable Product Information from Text Data - Mastering JMP
Are you a subject matter expert with information buried in unstructured text, such as survey free-re...