Weighting within Tabulate
Hello,
Is it possible to calculate a weighted mean within Tabulate?
Thanks,
Stefan
Find courses, tutorials, and lots of other methods of learning JMP.
view all learning resources
Hello,
Is it possible to calculate a weighted mean within Tabulate?
Thanks,
Stefan
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...
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?
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...
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...
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...
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...
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 ...
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...
@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.
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...
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...
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...
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
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!!
REGISTER HERE If you teach with JMP Student Edition, you should be aware of some lesser known...
Do you want to efficiently and interactively explore data to uncover patterns and see relationships...
Presenter: Will Morgan, Associate Software Developer - JMP Join us for a Scripters Club...
Jump into Gauge Studies Date: Wednesday, October 15Time: 1:00 – 2:30 p.m. ETDuration...