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
-
Excel VBA to automate JMP
Hi Folks, i am trying to run JMP time series analysis from excel VBA. below is the codes Sub LData()
Dim myjmp As JMP.Application
Dim jmp_doc As JMP.Document
Dim jmp_BL As JMP.DataTable
Dim jmp_dt As JMP.DataTable
Dim jmp_dtFinal As JMP.DataTable
Dim jmpstr As String
Set myjmp = CreateObject("JMP.Application")
myjmp.Visible = TrueSet jmp_doc = myjmp.OpenDocument("C:\Data_Doc1.xlsx")
Set jmp_BL = jmp_doc.Ge...KL
8394 views | 4 replies -
Non-Modal windows/user-interactive script
Hi, Details of my script:Part 1: open a new table so that user fills valuesPart 2: wait for the user to fill values and take the response to proceedPart 3: proceed with the remaining script I am struggling in part 2 because if I use Modal windows, I cannot fill the values in the table.I would like to generate a new window which will wait on user input OK" to proceed but should not interrupt the us...
shashivenky
4692 views | 2 replies -
Help choosing JMP Analysis for Multiple Factors
Hello! I am using JMP 13 (regular) and learning about predictive and specialized modeling. I have a dataset (attached) with over 100,000 observations of a process. 75% of the observations had a duration of 4 days or less. I'd like to know why some observations took over 4 days. I've identified some possible factors: 1 continuous and 16 categorical. Can you please suggest one or more JMP analy...
jb
16730 views | 8 replies -
Negative R2 in Mixed Models
How is R2 calculated in JMP (v12.2) when fixed and random effects are included in Fit Model? I can't find any documentation on this. The reason this came up is that I have been getting negative R2 values.
jwiltsie
7929 views | 6 replies -
Tricky Question about the Graph Builder
Hi JMPers, I'm trying to convince a large customer to use JMP. Now I'm having a hard time to reproduce one of their applications in JMP. The first problem I face, is that we would like to keep the colors from the row-states while using the Overlay-option.We need the above graph (including the blue and red colored points) with connection lines between the two points of each part (Y-axis).I can ge...
shoffmeister
8345 views | 3 replies
Latest Discussions
-
Non-Modal windows/user-interactive script
Hi, Details of my script:Part 1: open a new table so that user fills valuesPart 2: wait for the user to fill values and take the response to proceedPart 3: proceed with the remaining script I am struggling in part 2 because if I use Modal windows, I cannot fill the values in the table.I would like to generate a new window which will wait on user input OK" to proceed but should not interrupt the us...
shashivenky
4692 views | 2 replies -
Negative R2 in Mixed Models
How is R2 calculated in JMP (v12.2) when fixed and random effects are included in Fit Model? I can't find any documentation on this. The reason this came up is that I have been getting negative R2 values.
jwiltsie
7929 views | 6 replies -
Database stored procedure
Hi There, I have a database in which I wrote a stored procedure, which generates a table for DOE analysis. Basically selecting the parameters and their values dynamically, which is why a simple table query does not work.In JMP 13, there is the advance database open table window which lists all the stored procedure in the SQL. I'd like to run "Call StoredProc(x)" by using execute sql but nothing ha...
krisah
4506 views | 1 replies -
Disallowed Combinations Script with conditional statements
I am using the Space Filling Desing Platform to run a Fast Flexible Filling Design. I would like to add a disallowed combination script where if a level for one variable equals a certain value, then a separate column is limited to a specific value. I have the following script, but the script is not working. I have tried: F1 == 1 & F11 > 0 | F2 == 1 & F12 > 0, but then this removes all cases of...
jshaw04
7126 views | 2 replies -
Automatically save the file to folder
Hi, does anyone know if I select the any file from desktop,eg: CSV, after i open that file, it can automatically save into the working folder by using JSL? Thanks
blue1994
3534 views | 1 replies
Latest Discussions
-
Understanding the Dispatch and Legend Model and what exactly is Base(0,0,0)?
My problem is two fold. Im writing a JSL Function to create some custom charts at work. Everything is working fine. Thats great. But I dont understand why - and I am trying to break down the code. Most of I wrote myself, but some aspects I made the tweaks within JMP, copied the scripts and used the parts that generated what I needed. Some of the code chunks that get added in are intuitive to read ...
kevinwtbolger
3151 views | 0 replies -
Data Binding Associative Arrays
I recently had need to create some slightly complex data structures and started to play with associative arrays a little more. These are similar to dictionaries in other languages. Where they differ is that most languages to improve speed, when assigning an object in a dictionary to a variable it does a data binding. Essentially it makes it so both the dictionary and the variable refer to the s...
msharp
4197 views | 0 replies -
How to Maintain JMP Graphs Table Layout When Copy and Pasting into Word
For years I've had to build sets of graphs using the Fit Y by X platform. The graphs are simple: X-axis is always (1) a character, nominal column and (2) a numeric, continuous date/time column. The Y-axis is always numeric, continuous data (bins, registers, parameters). The result is a list of box plot on the left, time trend on the right. There could be many plots at a time. In JMP 12 (and I thin...
MIKE
4508 views | 0 replies -
Odds ratios for multiway tables
On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...
DonMcCormack
4677 views | 0 replies -
How to find ETA squared effect size for MANOVA?
Hello, Does anyone know how to calculate the eta squared value from a manova analysis in JMP? I know that the E and H matrices tab shows the sum of squares for each parameter, but which values do I use to calculate SStotal and SSeffect? In my model, I have 2 control variables (age and gender) and then a two way factorial. If only one of these variables (in addition to both control variables) is si...
nsalmano_stanfo
3609 views | 0 replies
JMP Events
-
ChinaShanghai May 29
-
12:00PM - 1:00PM EDTApr 3Teaching Predictive Modeling
REGISTER HERE: https://www.jmp.com/en_us/events/live-webinars/academic/teaching-predictive-modeling-...
-
2:00PM - 3:00PM EDTApr 3Virtual JMP Pharma and Biotech Club: "Comparability: One of These Things Is Not Like the Other"
https://www.jmp.com/en_us/events/users-groups/users-group-meetings/jmp-pharmabio-club-03apr25.html &...
-
1:00PM - 2:00PM EDTApr 4Getting 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 4Centralizing Shared JMP Reports Across or Within Groups Using JMP Live - Mastering JMP
Do you need to share reports with different work groups, suppliers or partners? Are you part o...