JMP User Community

Latest Discussions

Pass and Fail Condition

Hi Guys, I have the following table and would like to know how shall I set the formula(or JSL) where in this case, based on ID and MAIN_RAD, I would like to check on the value of SUB_1 to SUB_3. The condition is if at least 2 of the SUB has a value of more than 20 then it will be considered as FAIL otherwise PASS. For instance as you will notice, for M101X at MAIN_RAD 1, the SUB_3 is more than 2...
adam

Discussions |
Apr 11, 2018 9:30 PM

4361 views | 2 replies
How to copy and paste data cells from different ID cells?

Hi,I have an example of data table enclosed in this post. I need to copy the information from ProTest cells from Phase B to Phase A in the same column. However, first I need to match the Test_IDs following the rule: Phase A <-> Phase B1 113 135 157 179 19 I have different numbers of p...
Reinaldo

Discussions |
Apr 11, 2018 3:43 PM

7605 views | 7 replies
Extracting data from Surface plot

Dear All, I have fitted my response with three variables and found out the expression that relates the response to three variables. Now, I plotted the surfaces by keeping one of the variable constant using Graph---> Surface plot. Is there a way to extract the fitted surface into an excel sheet (X, Y, Z data) so that I can plot it in any other software? Thanks, Suraj
sdgff

Discussions |
Apr 11, 2018 4:44 AM

6196 views | 4 replies
How to delimit the range of my calculation in a JMP column with different numbers of participants?

Hi,I have an example enclosed in this post. I would like to calculate the Difference of Scores (Column 4) between Column 3 and Column 2 and then calculate the Mean of that difference per participant (Column 5). The problem is that I cannot use simply the formula "PostTest - PreTest" because I need to delimit its range (per participant). Furthermore, I have got different numbers of participants bec...
Reinaldo

Discussions |
Apr 10, 2018 6:26 AM

10181 views | 4 replies
custom expression Today() minus seven days in query builder

Attempting to obtain all releases by date (reldate) 7 days ago from ORACLE through ODBC Connection table.Code below returns the attached error image: SELECT DISTINCT t1.PIN, t1.PCP, t1.LASTNAME, t1.COMDATE,
t1.RELDATE, t1.JLOCAT, t1.SEX, t1.RELTYPE,
t1.RELAUTH, t1.RELCUST
FROM schema.table t1
WHERE ( ( ( t1.RELDATE >= (Today() - In Days( 7 )) ) 2nd question:Once I get this query straight, does ...
jumboshrimps

Discussions |
Apr 9, 2018 7:52 AM

6190 views | 1 replies

Previous
Next

Latest Discussions

custom expression Today() minus seven days in query builder

Attempting to obtain all releases by date (reldate) 7 days ago from ORACLE through ODBC Connection table.Code below returns the attached error image: SELECT DISTINCT t1.PIN, t1.PCP, t1.LASTNAME, t1.COMDATE,
t1.RELDATE, t1.JLOCAT, t1.SEX, t1.RELTYPE,
t1.RELAUTH, t1.RELCUST
FROM schema.table t1
WHERE ( ( ( t1.RELDATE >= (Today() - In Days( 7 )) ) 2nd question:Once I get this query straight, does ...
jumboshrimps

Discussions |
Apr 9, 2018 7:52 AM

6190 views | 1 replies
Reference line from axis to specific value

hi,i am new user to JMP and I was using Graph Builder for for developing a graph. However, I could not have specific value for x axis and y axis. Currently I have option to keep minimum Scale and maximum scale with a increment. eg.: Minimum: 0Maximum: 24Increment: 5Then axis will be 0, 5, 10, 15, 20 and 25.But I want like below:0, 1, 2, 3, 6, 9, 12, 18, 24. Can someone help? Thanks.
pprabhu

Discussions |
Apr 9, 2018 6:57 AM

3491 views | 4 replies
Does anyone know how p value of Actual by Predicted Plot in Fit Model platform?

HiAfter running a linear regression using the Fit Model platform, JMP displays P value (as P), RSq and RMSE on the bottom of the a Actual by Predicted Plot. I would like to understand how P value is calculated and what it means.I ask this because in a simple Y =aX+b case, the p value is identical to the p value of the X but if there are more Xs (e.g. Y = aX1+ bX2 + c) then, p value is something el...
woongkim79

Discussions |
Apr 8, 2018 8:48 AM

10755 views | 4 replies
Test of agreement for presence/absence by month

Hi, I collected data on the monthly occurrence of a parasite and the monthly occurrence of a histological lesion in the tissues where the parasite infects. The parasite is strongly seasonal - peak prevalence and intensities occur in March and April. The lesions are more spread out throughout the year but appear to be more common in those months. So for each (lesion or parasite), I can construct...
fishguy

Discussions |
Apr 6, 2018 8:35 AM

5740 views | 11 replies
Col Mean behaviour with hide/exclude

Hello, I observe that when I use ColMean function in one column that the value in the column is not updated when I hide/exclude some rows.I think this is not a normal behaviour - there is no automatic recalculation. May be we can avoid this with script but I would prefer to avoid. If someone has a solution, thank you in advance Regards Sébastien
seb38360

Discussions |
Apr 4, 2018 11:50 AM

2482 views | 1 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

3543 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

2379 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

2004 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

3248 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

2077 views | 0 replies