JMP User Community

Latest Discussions

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
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

9426 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
How to offset Spec Limits

Hi all, I work for a food manufacturer currently making granola bars. This is a new process and we are finding some significant bias in the weight readings on our X-Ray system. I have done some analysis that seems to be showing that for anything north of the teach point adds positive bias and anything south of the teach point adds negative bias. Due to this bias, we are rejecting bars within speci...
mmeewes

Discussions |
Apr 12, 2018 2:52 PM

7390 views | 5 replies

Previous
Next

Latest Discussions

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

9426 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

9852 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

5386 views | 5 replies
determination of sample size

Dear All, my sample population of each batch is 810.000 tablets for pharmaceutical product. I analyse 7200 sample for each batch. I want to reduce my sample size. Is there a statistical approach for this? I try to use Menu, DoE, Design Diagnostics, sample size and power, one sample mean part of jmpI do not change alpha value. my Std Dev is 0.3mg. My lower/upper spec is 1.3mg lower/higher than mea...
nac

Discussions |
Apr 12, 2018 5:40 AM

5631 views | 3 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

2861 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

2530 views | 0 replies