JMP User Community

Latest Discussions

Stacking in JSL indexed columns by group (sensor data and assets)

In manufacturing, is common to extract sensor data in the following form, where A and B correspond to similar devices (known as assets). In this format, the user needs to create a combined formula for each parent group. For example:(Input: Sensor data table needs specific columns per parent group) When handling several assets, this becomes cumbersome, so a better way is to stack the data per group...
FN

Discussions |
Apr 12, 2023 10:44 AM

3122 views | 7 replies
Power analysis for Mutiple response DOE

Hi all,
I have a custom design with 4 responses, and 3 factors that plan to run. I want to do a Power analysis. What I understand is I need to: - Estimate RMSE: Or noise in response when repeating many runs with the same factors setting - Define delta (or signal/ 2* Anticipated coefficient). The minimum change in the response that critical to detect. But I have 4 responses. Which one should I put...
Justin_Bui

Discussions |
Apr 12, 2023 7:10 AM

1554 views | 2 replies
Inserting additional values to existing keys in associative arrays (data dictionaries in JSL)

I cannot find the proper method to add new values to existing keys in associative arrays. Names Default To Here( 1 ); ex = Associative Array(); ex["a"] = {"10"}; ex["b"] = {"20"}; ex["c"] = {"30"}; // Add new value to "b" ex["b"] = {"21"}; show(ex); //ex = ["a" => {"10"}, "b" => {"21"}, "c" => {"30"}]; // Solution needed //ex = ["a" => {"10"}, "b" => {"20", "21"}, "c" => {"30"}];
FN

Discussions |
Apr 12, 2023 6:12 AM

2843 views | 7 replies
Tabulate

Bonjour, est-ce qu'on peut remplacer les zéros dans un tableau par un espace (= pas de valeurs) pour mieux voir les données différentes de zéro?peut-on le faire avec le script du tableau? cordialement
Françoise

Discussions |
Apr 12, 2023 12:43 AM

820 views | 1 replies
How can I SUM specific columns in a Data Table if they exist?

I am trying to write a script to sum specific columns if they are present in the data table. Lets call them Col A, Col B, Col C, Col D. The problem is the data table does not always have all four columns which results in an error. I would like to write a script that can add Col A, Col B, Col C, and Col D that are present in the data table. Obviously I could just update the code for the ones presen...
DegreesOfGen19

Discussions |
Apr 11, 2023 10:09 PM

2125 views | 2 replies

Previous
Next

Latest Discussions

Tabulate

Bonjour, est-ce qu'on peut remplacer les zéros dans un tableau par un espace (= pas de valeurs) pour mieux voir les données différentes de zéro?peut-on le faire avec le script du tableau? cordialement
Françoise

Discussions |
Apr 12, 2023 12:43 AM

820 views | 1 replies
How can I SUM specific columns in a Data Table if they exist?

I am trying to write a script to sum specific columns if they are present in the data table. Lets call them Col A, Col B, Col C, Col D. The problem is the data table does not always have all four columns which results in an error. I would like to write a script that can add Col A, Col B, Col C, and Col D that are present in the data table. Obviously I could just update the code for the ones presen...
DegreesOfGen19

Discussions |
Apr 11, 2023 10:09 PM

2125 views | 2 replies
Make Vertical bar chart showing only Top 10

Hello JMP community, I would like to have vertical graph like on the left side. This graph is based on a data set far bigger. See on the right.Now I would only like to show the top 10 or top 5. Does anybody have a good idea for that? Ben What I tried so far, somehow works but not as I would intend it to: Generally that is possible by:Limiting with a local data filter for x so that the graph on the...
Benjamin_Fuerst

Discussions |
Apr 11, 2023 5:59 AM

1750 views | 2 replies
Using tabulate Row % within a group

Hello everyone, I am using tabulate to massage data to exemplify yields and failures of machines. Generally the data is sorted by date (as Rows), and status (columns). I wanted to group this info by machines, as shown below. A - accept ; R - reject I would like to display this as percentages. i.e. yield of the machine per day. The Row % on tabulate is usually what I would use. In this case, it w...
Jacobusk

Discussions |
Apr 10, 2023 10:04 PM

1057 views | 1 replies
How to loop through the unique values of a column to fit a line in a bivariate plot?

I am trying to write a jsl to plot a bivariate plot between x vs. y, group by the values in column 'b' and fit a line through each of the groups (from the unique values in column 'b'). The script generated from the manual bivariate plot I did is as follows but I cannot figure out how to do add a for loop for all the "Fit Where" commands that go through the unique values in column 'b'Bivariate( Y(...
FrequencyBison9

Discussions |
Apr 10, 2023 11:32 AM

1270 views | 3 replies

Previous
Next

Latest Discussions

oci connection example

I am looking for an example of how to connect to oracle data with JMP 16 via oci. I have seen notes indicating that it is a far faster connection.
sconard

Discussions |
Apr 10, 2023 10:40 AM

655 views | 0 replies
Criblage des processus

Bonjour à tous,Est-il possible de mettre dans le criblage des processus le format/la colonne de notre choix dans le module « dernière alarme ». Pour ma part j’aimerais pouvoir y mettre une colonne Date pour pouvoir contrôler à quels jour interviennent mes dernières alarmes.Merci pour votre aide.
hcarr01

Discussions |
Apr 3, 2023 2:41 AM

702 views | 0 replies
How do I choose which significant effects to use for a posthoc

I'm looking at the impact of 4 two level independent categorical variables on a continous dependent variable. How to I choose what effect to use for a posthoc analysis? If I choose forexample size*treatment*shelfcode how do I consider the effect color to explain dependent variable Firmness?Do I do posthoc on all interactions? If yes, how do I interprete separate posthocs on the same variable firmn...
JulianAch

Discussions |
Apr 1, 2023 2:15 PM

621 views | 0 replies
Hey I need help with solving this control chart problem?

The largest purchaser of care of the WorldBest Healthcare System complained that the average C-section rate at WorldBest had increased from 1999 to 2000 and was now over 21 percent. The average at other area hospitals was between 17 to 19 percent. To investigate the situation, WorldBest wants to set up a control chart to monitor the number of C-Sections every month. 1. What type of control chart s...
StarIconCohort4

Discussions |
Apr 1, 2023 10:56 AM

694 views | 0 replies
How do I get percentage difference by function within JMP platform?

I'm working with a large dataset with a single continuous number column and then multiple nominal columns. I need to understand the % delta (or % difference) in the number column as a result of toggles in the nominal columns.With the Fit Y by X platform, I can readily add a function to provide the raw difference (as with the t test function), but I can find nothing for the % delta I'm needing. And...
tsandidge

Discussions |
Mar 30, 2023 11:09 AM

964 views | 0 replies