JMP User Community

Latest Discussions

Filtering Pareto charts by column.

I have a very large dataset of manufacturing defect bin data.My columns are the manufacturing batch IDs (called lots), and then each column is a defect bin, with the numeric value for that particular defect bin for each lot. In JMP Pareto chart, the input needs all defect bins in one column. So, I have to make another table by stacking those defect bins using Table>Stack. This makes an even larger...
spoikayil

Discussions |
Mar 18, 2021 12:53 PM

1699 views | 2 replies
Adding x number of days to a Character Date column (dd-Mon-YYYY)

I have a JSL script that periodically pulls data from an Access database. The access database contains a date column "Available Date" with a dd-Mon-YYYY (E.g., 12-APR-2018) format. What I am trying to do, is create a new column "Target Date" in JMP that adds x number of days to the date in "Available Date" for each row. For example: In the image below, the Target date is equal to Available date +...
DanAlexander

Discussions |
Mar 18, 2021 12:25 PM

4469 views | 3 replies
How do I extract only the text that is between quotation marks

I have a column containing 1000's of Machine Error Codes which are typed in by an operator at the machine.Most of the errors do not have quotation marks but for those that do I would like to be able to extract what is between the quotation marks.For other special characters I can use the escape character but I'm having problems using this with the quotation marks.Thanks in advanceFiona Example 1: ...
fionaweston

Discussions |
Mar 18, 2021 10:11 AM

2685 views | 2 replies
Create a log-space vector

All-I am new to JSL and I want to know if there is an easy way to create a log-space vector--similarly to the function in MATLAB or Numpy.Thanks. -Alvaro
a_betancourt

Discussions |
Mar 18, 2021 9:18 AM

1240 views | 1 replies
Concat data in multiple text files with no headers

I have about 500 text files that I need to combine. All of them have no headers. The values are separated by comma as below. (the format is the same for all files) 122,3410732003,,ABC2,P
122,3410732003,,ABC2I,13.6
122,3410732020,,ABC2,P
122,3410732020,,ABC2I,4.13 So when I try to use the import multiple files option in JMP with csv settings, it warns me that there will be 500 data tables generated.An...
CMG

Discussions |
Mar 18, 2021 6:31 AM

2050 views | 3 replies

Previous
Next

Latest Discussions

Filtering Pareto charts by column.

I have a very large dataset of manufacturing defect bin data.My columns are the manufacturing batch IDs (called lots), and then each column is a defect bin, with the numeric value for that particular defect bin for each lot. In JMP Pareto chart, the input needs all defect bins in one column. So, I have to make another table by stacking those defect bins using Table>Stack. This makes an even larger...
spoikayil

Discussions |
Mar 18, 2021 12:53 PM

1699 views | 2 replies
How to explore the baseline level effect on response size (i.e. CFB)? Is fit model the right tool in JMP?

Hi All, We have a test that compared the benefit (data reading, numerical data) of two different treatments over a couple of time points (baseline, T1, T2, etc). There are also some other effects: test sites, gender, etc.For primary objective, I used the "Fit model" and put the data reading as Y, treatment, baseline level, time point, gender, subject ID(random factor), some 2-factor interactions i...
Diana

Discussions |
Mar 17, 2021 8:07 PM

1810 views | 2 replies
Incorporating measurement error into Dunnetts analysis

I want to start incorporating my measurement error into my dunnetts analysis. I have attached a file below which has two variables which I am trying to determine if they are different. Both variables were tested 3 times and each test was measured 3 times. Since I am trying to determine if the variables are different in the past I've always just averaged all 3 measurements and used as the value ...
wyler0

Discussions |
Mar 17, 2021 3:23 PM

2252 views | 4 replies
How to save report as a text file via script?

Hi all, I have a script to run a logistics regression. I then want to save it as a text file, akin to doing a Ctrl+s with that report open, selecting "txt file" in "Save as type", then saving it. Is there a way to script this last saving part? I've tried Save(), SaveAs(), Save Text File() and none of them seem to work. I'm intending to then use a separate bash script to parse through that text fil...
jcashida

Discussions |
Mar 17, 2021 10:21 AM

4799 views | 9 replies
Prüfung von Residuen auf Normalverteilung (Diagramm Normalquantile)

Hallo, ich habe über DoE einen Versuchsplan erstellt und möchte diesen jetzt auswerten. Bei der Modellanpassung möchte ich natürlich prüfen, ob die Residuen normalverteilt sind. Dazu habe ich mir im Modell-Fenster das "Diagramm der Residuen-Normalquantile" anzeigen lassen. Zusätzlich habe ich die Residuen als Spalte gespeichert und mir diese über "Verteilungen" als Histogramm anzeigen lassen. Hier...
Al24

Discussions |
Mar 16, 2021 8:31 AM

2394 views | 3 replies

Previous
Next

Latest Discussions

What does it mean when the solution path for Elastic Net is not single-valued?

Dear JMP Community, (W10, 64-bit, JMP Pro 15.2.1) I am running a model to assess the active predictors. I am doing this by using the Autovalidation add-in to generate a Null Factor for my data. I then use the GenReg platform to find estimates for each possible X-factor and then Bootstrap those estimates to get a better assessment of the contributions to the response. I came across a very stran...
SDF1

Discussions |
Feb 15, 2021 12:35 PM

1333 views | 0 replies
Return number from specified row of calculation column in either a text edit box or number edit box in an add in

Hello, I'm attempting to build an application in application builder. I have two modules currently. The first module is a series of number edit boxes and lists that allow the user to input values and make selections.After pushing a button, the inputs and/or list selections update table variables in a data table that subsequently updates column equations. The data table opens in the background so ...
tys5384

Discussions |
Feb 15, 2021 7:33 AM

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

1011 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

1277 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

3678 views | 0 replies