JMP User Community

Latest Discussions

Weighted average with varying row numbers

I found Byron's great example of the moving average function, but am having trouble implementing this into a data table of my own. In my table I have listed final product batches that are composes of a varying number of ingoing raw material batches. Each of the raw material batches contains a component at some concentration level and different quantities of the raw material batches are combined in...
Ressel

Discussions |
Feb 9, 2021 11:08 PM

1742 views | 2 replies
Parsing strings creating filter condition from excel and applying to it to datatable

Hi, JSL: how to create a reference to a table variable inside a column formula I would like to build custom formula sheet that I can modify and apply to data table. Say have a sheet-like in the attachment. Formula Sheet and would like concatenate this formula so that I can apply to selectwhere. I come with for loop idea below but I cannot figure it out how to parse it to selectwhere dt = o...
joshua

Discussions |
Feb 9, 2021 10:21 PM

1241 views | 2 replies
Permutation procedure for randomized block design

I'm interested in conducting a permutation analysis. I have three treatments, with a randomized block design with seven blocks. I'd like to do a permutation procedure to test both the F value and for posthoc pairwise comparisons.
Craig_Stockwell

Discussions |
Feb 9, 2021 12:27 PM

1487 views | 4 replies
Hover Graphlet and Data Filter Context Box

I have a tool that used a local data filter for a graph before and wanted to expand the data filter to a few other graphs/tabs so I switched to a Data Filter Context Box, but in doing so I noticed that my drill-down graphlet no longer respected that filter. Does the hover-label graphlet respect the data-filter context box?
Evan_Morris

Discussions |
Feb 9, 2021 7:44 AM

1105 views | 1 replies
Define Factor Constraints DOE Custom Design by Disallowed Combinations Script

Hello together,Sorry in advance, I just startet using JMP. I have struggle adding a factor constraint script to my DOE. My constraint are as follows:Factor A^2 * Factor B <=200Unfortunately I'm not able to write the script like this, because I always get the JMP Alert: Invalid disallowed combinations script. See log for details. Where ist this log and do I have to add something?Best regards
Freddy

Discussions |
Feb 9, 2021 7:27 AM

2022 views | 3 replies

Previous
Next

Latest Discussions

Permutation procedure for randomized block design

I'm interested in conducting a permutation analysis. I have three treatments, with a randomized block design with seven blocks. I'd like to do a permutation procedure to test both the F value and for posthoc pairwise comparisons.
Craig_Stockwell

Discussions |
Feb 9, 2021 12:27 PM

1487 views | 4 replies
Define Factor Constraints DOE Custom Design by Disallowed Combinations Script

Hello together,Sorry in advance, I just startet using JMP. I have struggle adding a factor constraint script to my DOE. My constraint are as follows:Factor A^2 * Factor B <=200Unfortunately I'm not able to write the script like this, because I always get the JMP Alert: Invalid disallowed combinations script. See log for details. Where ist this log and do I have to add something?Best regards
Freddy

Discussions |
Feb 9, 2021 7:27 AM

2022 views | 3 replies
How to consider multiple rows for a given Participant ID

This is a pretty elementary question, but how should one go about analysis of a large human clinical research data set with multiple rows for a given participant? Lets say there are columns titled "ParticipantID", "Visit", and "HasBeard" each containing categorical data. For each ParticipantID (i.e. 001; 002; 003) there are multiple study Visits (i.e. V1; V2; V3 etc) with each Visit containing uni...
colez

Discussions |
Feb 9, 2021 6:40 AM

3900 views | 7 replies
envelope calculate function

HelloI have data were I calculate a column with the moving average usingCol Moving Average()for a parameter.I am wondering if there is a function to calculate the min and max envelope line of the data i am not aware ofor is it necessary to program it in jsl?Best regards
nusopiti

Discussions |
Feb 8, 2021 9:40 PM

771 views | 1 replies
Display box that can both input column name and numeric value

Is there a display box that can take both column name and numeric value ? I'm trying to create a window where users can either select a column from column list (like a col list box) or insert a constant value (like a number edit box).
Djtjhin

Discussions |
Feb 8, 2021 8:25 AM

1645 views | 6 replies

Previous
Next

Latest Discussions

generalized regression

How do I get a whole model significance test when conducting a generalized regression using the negative binomial distribution? I can get the individual effect significance tests, but I do not see where I can get the whole model significance.
Mrubra

Discussions |
Feb 3, 2021 2:31 PM

832 views | 0 replies
Tablebox <

Using JMP 12.x, I noticed that: tablebox() <<sort by column does sort the column fine, but it does not seem to preserve any existing cell coloring post row sort. Is there any way to force it to preserve the existing cell colors post row sorting?
thanks, DJ
djhanson

Discussions |
Jan 14, 2021 9:17 AM

1070 views | 0 replies
Comparing observed/predicted from different models. (Mean Absolute Deviation (MAD) or Mean Absolute Error (MAE))?

I'm using the neural platform to calculate a model that makes predictions from some observed data and want to compare the performance of that model to other models (not from JMP). To compare the different models, I want to compare the observed data and the predictions from the different models.The R2 is not a good measure because it checks for any linear relationship between the observed and predi...
matthias_bruchh

Discussions |
Jan 8, 2021 2:32 AM

2991 views | 0 replies
Graph Builder - Remove Combine Scales?

In graph builder I am interested in plotting a simple Y vs X for multiple X variables. By default graph builder combines all the different X variables on the same X axis and scale. Is there a simple way to change the X axis to have separate scales on the X axis for each variable? Default graph builder (script1, graph1)Plot 1 variable on Y axis vs 8 variables on X axisAll 8 variables on same x-axis...
ehorne

Discussions |
Oct 29, 2020 9:11 AM

1162 views | 0 replies
SharePoint Online

My company recently began the migration from SharePoint 2010 to SharePoint Online. I have found that my JSL scripts are now no longer able to open or save files to the new SPO site. Anyone have the correct updated syntax for this. Example 1 (SP 2010): This worked. TablePath4 = "\\sharepoint.amr.ith.company.com@ssl\sites\rpt\documents\JMP_tables\"; //set variable TablePath path location Tabl...
Outdoorsman1963

Discussions |
Oct 23, 2020 4:06 PM

1051 views | 0 replies