JMP User Community

Latest Discussions

Graph builder overlay question

Hi,I would like to build a graph from a table that is like this:UserEventFrequencyAW2AX1BX3BY!CZ2DX2EZ3………I want the graph to be two side-by-side bar graphs. The X-axis will be Event.The left pane should show % of each event type for the group of all users (i.e. numerators are number of each event tyoe for all users, denominator is all events of all users).The right pane should show % of each even...
john_madden

Discussions |
Apr 16, 2018 6:58 AM

8451 views | 5 replies
Not getting same results in neural network run from menu vs run from script.

I am trying to run a script that automates screening the eight different penalty modes in Neural Network and outputting the results into the current table. I have been troubleshooting why I am not getting different results from the different Fits in the script. This led me to look at the results for each individual penalty mode when the model was set up from the Neural Menu vs the script. The scri...
jwalk

Discussions |
Apr 16, 2018 6:05 AM

14153 views | 8 replies
Lack of Fit missing

Hi~ When I study fit model, I have a simple problem. As you see below image, I want to know why "Lack of Fit" is not activated, this sample data just from JMP library.
Joon

Discussions |
Apr 15, 2018 2:33 AM

7885 views | 2 replies
Calculate time difference

I have a set od data, In the script I call it RTDT. It contains a Time, Sub_name and Substrate_ID columns. I am trying to calculate the time difference between the first time and last time a unique Sub_name and Substrate_ID are listed. They will be listed sequentially for each unique Sub_name and Substrate_ID. My code is as follows: RTDT << New Column( "Runtime", Numeric, "Continuous", Format( ...
KST-CPT

Discussions |
Apr 13, 2018 11:15 AM

6766 views | 2 replies
Recode multiple columns with JSL script

I have a script with connects to an Access Database to retrieve some data for analysis. In this data there are several columns which have some null information in the data set. I know I can use the For Each Row command and recode a column to replace all the null data with the string "Blank". Is there a way to script this to work on all columns or do i need to use the For Each Row command on eac...
buckmurdock

Discussions |
Apr 13, 2018 6:12 AM

15861 views | 5 replies

Previous
Next

Latest Discussions

Not getting same results in neural network run from menu vs run from script.

I am trying to run a script that automates screening the eight different penalty modes in Neural Network and outputting the results into the current table. I have been troubleshooting why I am not getting different results from the different Fits in the script. This led me to look at the results for each individual penalty mode when the model was set up from the Neural Menu vs the script. The scri...
jwalk

Discussions |
Apr 16, 2018 6:05 AM

14153 views | 8 replies
Control Chart Builder with source data from multiple columns

I like the visualization provided by the Control Chart Builder. In particular I like the stacked Xbar-R plots in one figure, the built-in distribution with normal distribution fit overlay, and automatic control limits calculated overlaid on the charts. Unfortunately, many different data sources I'm working with aren't entered in full to our JMP tables. Mean, range and standard devivation are ca...
sbiedrzycki

Discussions |
Apr 13, 2018 5:32 AM

9428 views | 4 replies
Comparing means of two categorical factors including interactions

Hello, I am analyzing some data collected over the past year. For privacy reasons, I don't want to dive into it too much, but I think I've developed a simplified version of the experiment that I can use to ask questions. I have a randomized design with a 3x4 factorial arrangement. We'll say that I have a "Day" factor (Day 1, Day 10, Day 30) and a "Treatment" factor (Approach A, Approach B, Approac...
acbart

Discussions |
Apr 13, 2018 12:12 AM

5043 views | 2 replies
Line graph

Hello, I am trying to make a line graph to resemble this:My goalHowever, in my result (please see below), if you look vertically, the points do not line up with the x-axis like what is shown in the previous figure. I am currently using JMP13, the goal figure was created using JMP12. Could anyone help with this issue? Thanks!
alihong812

Discussions |
Apr 12, 2018 10:38 AM

9855 views | 4 replies
Filter in query builder contains 102 different strings

In SAS 9.1 I a had a script querying a medication table with a list of over 100 different medications.If the list was especially long I would create a spreadsheet in Excel and import the list into the work space, write a script matching where a.description = b.description.Neither function appears in JMP. I cannot bring in an Excel file, cannot bring in another table, ONCE THE CONNECTION TO THE ORA...
MeatPopsicle

Discussions |
Apr 12, 2018 6:06 AM

5387 views | 5 replies

Previous
Next

Latest Discussions

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

4058 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

2863 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

2456 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

3825 views | 0 replies
.jsl scripts will lock files even while set to read and execute permissions only

I am having an issue where an add-in script which runs another script via the include(); function is locking the included script file while other users are running it. This renders me unable to update that script. I tried setting the permissions on the repository and the file as read and execute only but it still locks when other users access it.
nbullen

Discussions |
Feb 5, 2018 12:05 PM

2531 views | 0 replies