JMP User Community

Latest Discussions

Formula to make a new column

I have a table with four columns, and I am trying to make a new column based off of the available columns. Here is my script:dtq = current data table(); a = dtq << New Column( "E", Formula( If( Is Missing( :A ) & Is Missing( :B ), Abs( :C ), Is Missing( :A ), Abs( :C / (:B - :D) ) , Is Missing( :B ), Abs( :C / (:D - :A) ), //If !Is Missing( :A ) & !IsMissing( :B ), //then do Abs...
Aam_jmp

Discussions |
May 29, 2018 11:11 AM

6527 views | 2 replies
Dynamic Filters for SQL Query

So I dont know anything really about SQL, so I used the JMP Query Builder and based all my code off that.Basically, I want to allow the user to filter any data they want via a pop up screen where they can pick the column to filter, then what values they want to filter. All the columns in my JMP table are valid column names in my Database. So i got to the point where i created an associative arr...
thsueh89

Discussions |
May 29, 2018 7:12 AM

7614 views | 4 replies
Error saving to a file: I/O Problem. File not open in Write mode.

hi, when I want to save a SQLQuery.jmp, i can't do it because I have this alert message from JMP14: does it mean that someone has already opened this file without close it? Is there a solution? best regards
Françoise

Discussions |
May 29, 2018 5:05 AM

9697 views | 2 replies
excel import cell colors

I have used import cell colors in the excel import because I have clients who color cells that should be included or excluded. The colors import fine but I havent found an easy way to access the cell's color state in order to exclude those cells. The only workaround I've found is to get the columns script and parse out the row numbers. I'm afraid that this might not be very reliable. Are there...
ghartel

Discussions |
May 29, 2018 12:27 AM

6409 views | 2 replies
Help Needed! Incomplete Details when using SPLIT column

Hello JMP community!I need help figuring out what seems to be the problem when I Split a column of the following Data Table:My raw data is as shown:Data Table 1 (Raw Data)Take note that I have 2 types of Design : D1 and C1. I Split this data by "STEP" and "Shift" as the splitted column.Rema. Unexpectedly, I am getting the output table as shown below: Output TableTake note that in the Output table,...
switzal87

Discussions |
May 28, 2018 12:30 AM

8204 views | 4 replies

Previous
Next

Latest Discussions

Dynamic Filters for SQL Query

So I dont know anything really about SQL, so I used the JMP Query Builder and based all my code off that.Basically, I want to allow the user to filter any data they want via a pop up screen where they can pick the column to filter, then what values they want to filter. All the columns in my JMP table are valid column names in my Database. So i got to the point where i created an associative arr...
thsueh89

Discussions |
May 29, 2018 7:12 AM

7614 views | 4 replies
F-test comparing unrestricted and restricted model in JMP

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 do ...
Gummiand12

Discussions |
May 25, 2018 8:35 AM

2892 views | 1 replies
Chi Square independence P value colors

I am conducting a contingency analysis on a set of data at using the Chi square tests of indepedence. JMP does its thing and then spits out P values for Likelihood Ratio and Pearson. Sometimes JMP puts the P value in an orange color. Sometimes it puts it in red. Sometimes there's an asterisk after the P value, sometimes there's not. What is the significance of the color and the asterisk? I do not ...
AndrewRS

Discussions |
May 25, 2018 7:25 AM

2770 views | 1 replies
How to refresh data in a new table within JSL script

Hello -I am currently writing a script that will ultimately display a report for me. I can get all preceding tables/graphs to refresh accordingly when the data source's data is updated, but I'm not sure why the final table in the script doesn't update (labeled /* FINAL REPORT */). Am I missing a line so I can pull in data from the data source? Thank you in advance! Names Default To Here( 1 ); Cu...
JMPer08

Discussions |
May 24, 2018 10:26 PM

7252 views | 2 replies
JMP crashing when opening

Hello all!I started JMP pro 13 not long ago, however i am having some noobie troubles. I have only done a few scripts, however now whenever i open JMP it crashes and closes itself after starting it, regardless if i open a new file or an existing one. I already tried uninstalling the program and installing it again, as well as the solution mentioned here , however the program keeps on crashing. I w...
danielgri17

Discussions |
May 24, 2018 2:01 PM

2754 views | 1 replies

Previous
Next

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

Discussions |
Apr 27, 2018 7:12 AM

1566 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

Discussions |
Mar 17, 2018 2:22 AM

3564 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

Discussions |
Mar 15, 2018 1:57 PM

2395 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

Discussions |
Mar 11, 2018 6:27 AM

2015 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

Discussions |
Mar 9, 2018 2:20 PM

3264 views | 0 replies