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
-
Difference between Block and Categorical factors in Custom Design
Dear JMP community, I have a question regarding the custom design function in JMP. I want to generate a D-optimal design with 12 continuous factors and 2 blocking factors and I have 64 runs at my disposal. I want this design to be able to estimate the 2nd order interaction effects of the 12 continuous factors as well. I add a blocking factor in the “Custom Design” menu and I select all 2nd o...
MaartenvM
10154 views | 5 replies -
How do I compare 2 variances with an F-test?
Hello, I need to compare the residual sum of squares in an unrestricted model with the residual sum of squares in a restricted model using an F-test to see if the additional independent terms in the unrestricted models significantly reduce the unexplained variations in the model. In the linked Youtube video, a guy shows how to do it manually (view the last 2 minutes or so) - however, I need to d...
Gummiand12
18011 views | 5 replies -
Concatenate to Summary Table
I have a joined table that combines two summary tables. I want to plot the results of one column against the other. These columns are calculated from values in their respective parent tables and are locked. However, I also want to plot a reference trendline (1:1) on this plot. To do this I would like to add four rows with numeric values in the two columns I'm plotting and create a new column that ...
KApple
2845 views | 1 replies -
Script works in scripting editor but not on menu item (Get Column Names not behaving the same)
When I run the following script from the scripting editor, it works fine. But when I run it from a custom menu item I created in View->Customize, it does not work. I've traced it down to the Get Column Names function not behaving the same. When I put a print statement to output the value of each column name and its Type before I use Get Property on it, I see this (for example) when running from...
tatarjj
6086 views | 4 replies -
Formula to use previous value if not missing, otherwise use value from last occupied cell
I'm trying to write a formula in Col3 that adds the current value of Col1 with the lagged value of Col2 but I'm running into a pickle trying to figure out how to carry forward the last observation from Col2 when missing data is encountered and to use this value at the first instance of non-missing data. That is,
If( !IsMissing( Col1) Col1 + Lag(Col2,1); //create variable that contai
...terapin
21499 views | 15 replies
Latest Discussions
-
Concatenate to Summary Table
I have a joined table that combines two summary tables. I want to plot the results of one column against the other. These columns are calculated from values in their respective parent tables and are locked. However, I also want to plot a reference trendline (1:1) on this plot. To do this I would like to add four rows with numeric values in the two columns I'm plotting and create a new column that ...
KApple
2845 views | 1 replies -
How to create APA-format tables and plots from JMP data?
Hi JMP users, I would like to know if there is an easy way to create/export tables and plots from JMP data to APA*-format. Thank you! * APA: American Psychological Association
Reinaldo
4080 views | 2 replies -
Issues with local data filter and select where
I am trying to make a Class object that contains methods and properties I find usefull when working with distribution reports. I have everything working how I would like it when I don't try and filter the report or data table but when I try and fitler the report I start having issues. Main issue being is after I filter the report when I go into the display tree to pull and save values they don't r...
awsmagala
4043 views | 3 replies -
get current work week in string
Hi I need to pull the date from a constant changing folder name, the name is the year+curent WW e.g. 201817I have the following JSL
if ((day of week(today()))==1, WW = "^year(today())^^week of year(today())-1^", WW = "^year(today())^^week of year(today())^" );
it works when I run it on my PC but when I schedule it on a serv...
Eval Insert Into( WW );
dt = Open("\\.......\Reports\"||WW||"\.......xlsx");AdamChoen
2642 views | 2 replies -
ODBC connection
How do I create an ODBC connection from LIMS to JMP?
eward3614
6055 views | 2 replies
Latest Discussions
-
Why does Profiler not stop
All,
I have a script I am trying to profile and improve on. When I run the script without the profiler, it runs and ends within 4 minutes. When I try to profile the script, even after a good 5-6 minutes, it does not stop. Wondering why this is happening and if there is a way to use profiler and not run into this. I am using JMP 13.uday_guntupalli
1590 views | 0 replies -
P value, L-R Chi Square, Prob Chi Square in Choice results
Hello everybodyI am going to undrestand the P value, L-R Chi Square, Prob Chi Square in Choice results. But different interpretations of these values can be found in the web. It seems that the true interpretation is related to null hypothesis and confidence intervel.The results of the study are as the attached pictures.Could any body inform me what exactly these statistics are saying and base on w...
aryasohrabi
3593 views | 0 replies -
Convert separate DATE and TIME columns in formats YYYYMMDD and HHMMSS into a single column
Hello, I manage an addin for my company where all data is imported into JMP via command line utilities owned by our automation team. My addin translates a users request into a formatted command and issues the command in the background. The data is returned back as a text file on the users system. My addin can then load the data from the text file. The issue that I have is that the columns vary bas...
Picard
2428 views | 0 replies -
pseudo r square in JMP choice model platform
Hi,I am using JMP's choice model platform to analyse some Discrete Choice Experiment (DCE) data. I am trying to find the pseudo r square but the platform does not provide it. Is there a way to calculate pseudo r square based on the results JMP presents under the choice model platform? I know pseudo R square comes up as entropy RSquare under JMP's fit model platform, nominal logistic fir for respon...
DG
2061 views | 0 replies -
chnging colors on PCA plot
Hi,I seem to be able to change the color of the circle around the PCA plot but not the arrows which remain red no matter what I do. I changed the circle by Right Clicking on the plot --> Customize --> Circle and selecting the black color. I did the same using the option of Customize --> Arrow but nothing changes.Any advice would be appreciated.Thanks a lot.Helga
helga55
3294 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...