JMP User Community

Latest Discussions

Numerical solver add-in

I am looking for a script or add-in which can adjust the values i a single column, recalculate the entire sheet, evaluate some criterion and repeat until some criterion is met. In short I need something which will do for me what the Excel solver add-in does for me in Excel.Does anyone know of such a tool for or function i JMP?
JesperJohansen

Discussions |
Feb 6, 2015 1:30 AM

15354 views | 4 replies
Big Class: Creating a New Grouping Variable

Hi! I'm sure this will be elementary for many of you, but having come from tabulation software to JMP, this one is stumping me.I am trying to understand the process of creating a new grouping variable. This is a relatively straight forward process in IBM's Survey Reporter, but doing so in JMP is not immediately clear to me.Using the Big Class data file, I would like to create a new column where th...
mcstagger

Discussions |
Feb 5, 2015 11:21 AM

6883 views | 2 replies
Analyzing factorial experiment with missing data

I will preface my question with the fact that I am new to DOE in general. After trying to learn the basics, I designed a 2^5 full factorial experiment with 5 center points (to obtain an estimate of process error). Ultimately the process is producing samples, which we are characterizing in different ways. We are looking at MANY responses. The problem is that for some of the samples, we cannot do al...
michelle

Discussions |
Feb 4, 2015 4:15 PM

14069 views | 4 replies
Creating a Cumulative Summary Column for different rows

Hi,As you will understand from the question I am a newbie to JSL scripting/formulating/automating...I have a revenue data set which contains a column called as "year" of 2013 2014 2015... I need a Cumulative Sum for each year but when I create a column of Cumulative Sum (by the help of Graph Builder) it adds all the days and year one to another and ends up with grand 3 year total Cum Sum, where I ...
saitcopuroglu

Discussions |
Feb 4, 2015 8:09 AM

13874 views | 14 replies
How to Join and get common matching columns

One of the things that I'm struggling with in JMP is the fact that, when I want to do a many-for-many table join using the "Join" function on matching columns, then the match columns in the resulting table always get/stay segregated between each of the two source tables. JMP doesn't seem to provide an automatic or convenient way to get the common match column(s) with the values filled in for all ...
a01

Discussions |
Feb 4, 2015 5:52 AM

15543 views | 3 replies

Previous
Next

Latest Discussions

Big Class: Creating a New Grouping Variable

Hi! I'm sure this will be elementary for many of you, but having come from tabulation software to JMP, this one is stumping me.I am trying to understand the process of creating a new grouping variable. This is a relatively straight forward process in IBM's Survey Reporter, but doing so in JMP is not immediately clear to me.Using the Big Class data file, I would like to create a new column where th...
mcstagger

Discussions |
Feb 5, 2015 11:21 AM

6883 views | 2 replies
Script for Error Bar Line Color in Graph Builder

Hello,I have a fairly simple problem, but cannot find the answer in the scripting guide. I created a temperature graph in graph builder using hourly temperature data. I used a line graph to show the daily mean and added error bars to show the range of daily temperatures. The error bars are the same color as the line graph which makes the mean line hard to see. To get around this, I right-click on ...
joshuas

Discussions |
Feb 2, 2015 11:45 AM

4931 views | 1 replies
Non-numeric Pass/Fail Rate Analysis

I'm a long time JMP user, but a first time poster. I’ve searched and searched and cannot find a means to analyze data the way I’d really like.Attached is an Example data table that I’m using.For my specific example, each “ID” has ~700 unique X/Y coordinate locations. And each one of those X/Y coordinate locations is tested for Pass/Fail. (Pass = “.”; Fail = “F”).Ideally, I’d like:A Contour Plot...
nldavis

Discussions |
Feb 2, 2015 9:31 AM

6167 views | 3 replies
Dynamic Charts and Graphs in JMP

@Hi Dear Friends,I have question regarding the development of dynamic charts and graphs in SAS JMP. Is it possible by SAS JMP scripting? Here I need to include some list boxes, drop down menus,radio buttons and check boxes ect.. agin i need to link all these things to charts and graphs. Please help me or guide me, in achieving this task.Thanks,
Swamy.
swamypamu

Discussions |
Feb 2, 2015 7:29 AM

7946 views | 5 replies
Image processing

I want to compare multiple images with the reference image and add indication marks on the image if it is different from the reference. Could you please help me making this as a JSL code?
hj

Discussions |
Jan 27, 2015 11:01 AM

7396 views | 5 replies

Previous
Next

Latest Discussions

test statistics on odds ratios in logistic regression

I've been using logistic regression with multiple categorical predictors. I'm particularly interested in the odds ratios, and I understand how the odds ratios themselves are calculated, but I'm having trouble understanding how the test statistics associated with each odds ratio are calculated. JMP gives the disclaimer "Tests and confidence intervals on odds ratios are likelihood ratio based." M...
mjahnke

Discussions |
Dec 5, 2014 11:03 PM

3681 views | 0 replies
What robust methods are common for Process Capability Indices for Non-Nornal distributions?

In Europe, we found it common to use Cpkn as a non-normal Cpk metric, where mean was replaced with median, and stdev was replaced with IQR/1.35. For some "regulatory" or "customer" reports, this seems to be accepted rather than the usual "torture the data until it says its normal" approach with transformations. Does anyone have similar experience or better ideas? (Note: any use of capabilit...
mclayton200

Discussions |
Jun 19, 2014 2:05 PM

4879 views | 0 replies
Graph Builder Remove Variable

Hello,I am trying to use jsl to remove the x-axis variable and replace it with a different one. It looks like I should use the GraphBuilderBox <- Remove Variable() tool, but since I change the x-axis variable multiple times, I do not know its name and would like to use the Remove Variable(Role("X"), Position(1)) method, but this does not work. Any assistance would be appreciated.Thank you,Martin
Martin

Discussions |
Apr 15, 2014 6:44 AM

2747 views | 0 replies
How to calculate average (median) of a group of variables to get the eudlidean centre

How would I calculate the shape of the average (using the median) of a variable from a group within a data set? I need a certain function for calculating the centre of gravity (centroid) or Euclidian centre of this group of variable.
Many thanks!!
alexsheehy1992

Discussions |
Apr 2, 2014 12:17 PM

4169 views | 0 replies
LD50 and LT50 calculation

Hi everybody,I would want to calculate LD50 and LT50 from a dataset organized in 6 columns:- Name of the compound (I just got 1 compound named A)- Concentration of the compound (2 dilutions per compound)- Individual number (a fixed number of 10 individuals is used per assay)- State of the individual at the end of the experiment (1 = alive, 0 = dead)- Day death (experiment last 15 days)- Experiment...
cecilia

Discussions |
Mar 5, 2014 8:13 AM

5106 views | 0 replies