JMP User Community

Latest Discussions

How to calculate the very basics incredible basics

I have a data set and use tabulate to summarize the data and publish in the exportable interactive HTML form (implementing in a website where exporting to excel does not help).However I am unable to do it. The bottom tabulate takes the mean of several rows and I need as an aggregate the sum of those means which should be 827102,270 or vica versaI could add the sum of rows and I would need the mean...
saitcopuroglu

Discussions |
Feb 6, 2015 6:52 AM

3906 views | 0 replies
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

15357 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

6886 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

14082 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

13879 views | 14 replies

Previous
Next

Latest Discussions

How to calculate the very basics incredible basics

I have a data set and use tabulate to summarize the data and publish in the exportable interactive HTML form (implementing in a website where exporting to excel does not help).However I am unable to do it. The bottom tabulate takes the mean of several rows and I need as an aggregate the sum of those means which should be 827102,270 or vica versaI could add the sum of rows and I would need the mean...
saitcopuroglu

Discussions |
Feb 6, 2015 6:52 AM

3906 views | 0 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

6886 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

4932 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

6169 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

7951 views | 5 replies

Previous
Next

Latest Discussions

How to calculate the very basics incredible basics

I have a data set and use tabulate to summarize the data and publish in the exportable interactive HTML form (implementing in a website where exporting to excel does not help).However I am unable to do it. The bottom tabulate takes the mean of several rows and I need as an aggregate the sum of those means which should be 827102,270 or vica versaI could add the sum of rows and I would need the mean...
saitcopuroglu

Discussions |
Feb 6, 2015 6:52 AM

3906 views | 0 replies
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

3683 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

4881 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

4170 views | 0 replies