JMP User Community

Latest Discussions

JMP Join Tables with 2 or more Column matching with Logical "OR

Hi All,I am looking to dig into if there is a solution already exist for below problem.Say i haveTable A with 3 columns "X", "Y" & "Z"Table B with 1 column "R"Column R already contains some values of X and Y.I want to merge Table A and Table B like ---> Match column (X=R) OR Match column (Y=R)Can it be done with JSL or something? ThanksRam
ram

Discussions |
Feb 7, 2018 12:07 PM

8522 views | 2 replies
Fitting scheffe model in mixture + non mixture design

Hi, I have a custom design with 4 mixture variables and 13 non mixture variables. I am performing a screening experiment with 24 runs. When I use the "Fit Model" functionality with only main effects and choose "No intercept" to fit a model, 1) Do i get a scheffe model?2) I am not including any interaction terms in the model as I am performing screening and so am interested in only the main effects...
akrishna39

Discussions |
Feb 6, 2018 6:56 PM

13365 views | 8 replies
JMP 13 JSL that passes variables to oracle SQL statement

I am working with a collegue that has a JMP 13 script to is defining variables using Modal windows. User selection then sets variables that we want to pass into a open database section of our script in the SQL statement. Data table is updated for which oven is selected in the Modal window. We then select the oven column to pass this value into our SQL statement. Example. OvenList={18,22}; n...
steve_reinhart

Discussions |
Feb 6, 2018 12:36 PM

6501 views | 3 replies
Multivariate analysis for non-normal distribution (not transformable)?

Dear JMP community, I need to analyze the effects of treatment and multiple biomarkers on an clinical outcome variable that is not distributed normally (see histogram below). Based on my limited knowledge, I'm pretty sure that I cannot use the Standard Least Square model for the analysis of this data since the error generated by the model is not distributed normally. So, what would be my best opti...
sornasst

Discussions |
Feb 6, 2018 9:09 AM

20771 views | 7 replies
Real roots of degree 3 Polynomial

Hello everyone, Does anyone know how to calculate real roots of degree 3 polynomial with JMP scripting ? I have the coefficients of the equation : 0 = A + B.X + C.X² + DX^3. What I need is the real solutions.I started to create a new data table with lots of rows in order to get as close as possible to the desired value, but it takes too much time. Thanks,
MHz

Discussions |
Feb 6, 2018 5:11 AM

12751 views | 8 replies

Previous
Next

Latest Discussions

JMP 13 JSL that passes variables to oracle SQL statement

I am working with a collegue that has a JMP 13 script to is defining variables using Modal windows. User selection then sets variables that we want to pass into a open database section of our script in the SQL statement. Data table is updated for which oven is selected in the Modal window. We then select the oven column to pass this value into our SQL statement. Example. OvenList={18,22}; n...
steve_reinhart

Discussions |
Feb 6, 2018 12:36 PM

6501 views | 3 replies
Tabbox

I am trying to create a tab box display with a bivariate plot. I have the script that already generates the bivariate fit.what is the jsl code for creating tabbox?
jaysiri

Discussions |
Feb 5, 2018 8:06 PM

2807 views | 1 replies
Sample size estimation for mixed model designs

Hello, I am somewhat new to the concept of mixed model analyses for repeated measures but I believe that they will be of great use to my projects. One thing that I am having trouble grapping with is how to go about estimating what type of sample size I should be aiming for. ANOVA and t-test sample size calculations are easy to follow but I don't even know where to start for mixed model repeated me...
bio_grad

Discussions |
Feb 5, 2018 12:36 PM

5403 views | 1 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
Multivariate-Imputation

When I perform data analysis, I use the imputate missing values in the multivariate plateform(https://www.jmp.com/support/help/13-2/Impute_Missing_Data.shtml). Where could I find the documentation on how this imputation method is done--such as formula, etc. I need to provide it in the paper I am writing. Thank you!
xiaoyaj0

Discussions |
Feb 2, 2018 5:55 AM

5865 views | 1 replies

Previous
Next

Latest Discussions

.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
Sub-sampling data analysis in JMP

In Biology (Plant Sci. and Agriculture) usually we have sub-sampling data for replicates. It's very difficult to analyze these data in commonly use Stat S/W (SPSS/Minitab) because MSS(Error) is calculating wrongly. Without taking averages of samsamples, the easiest S/W for this is using JMP and I need some assistance for this. I've found very useful Youtube video about subsampling in JMP (CRD: S...
Kynda

Discussions |
Nov 15, 2017 2:32 PM

3957 views | 0 replies
Conceptual question about the profit matrix

This issue has been discussed previously, but I keep finding myself confused about how to use the profit matrix. My question is conceptual in nature, so let's just use some simple numbers. Suppose I have data on customer churn and I build a predictive model for churn (the particular technique does not matter for this question). My decision errors are not symmetric, however, so I want to modify ...
dale_lehman

Discussions |
Nov 10, 2017 6:02 AM

2841 views | 0 replies
Confirmation of Repeated Measures Analysis, when sphericity if voilated

Hi Everyone, I would like confirmation on the appropriate analysis to run on a repeated measures design.Experimental design:Independent variable: Nutrient treatment (Control, Low, Med, High),Dependent variable: basal diameter, 5 replicates (plants)Repeated measurements were taken at Weeks 0, 1, 4, 7, 10, & 12Split data-> Fit Model-> Y: basal 0, basal 1, 4, 7, 10, 12, Add: Nutrient treatmentPers...
uamiller

Discussions |
Oct 23, 2017 8:07 AM

2968 views | 0 replies
Cox Proportional Hazard - adjusting risk ratio with std dev

I'm working with someone who is using SAS and I'm trying to do the same analysis in JMP. When I questioned their hazard ratio they said it was adjusted by the standard deviation. They commented:In order to obtain results in units of 1 standard deviation – you simply get the standard deviation value for parameter of interest and introduce it in the PH regression statement, for example:proc phreg ...
Maureen

Discussions |
Aug 22, 2017 1:18 PM

3569 views | 0 replies