JMP User Community

Latest Discussions

Move data from a row to a column for duplicates, then remove duplicates

New JMP user here. I know how to do this in Excel, but am not sure how to in JMP. Here 's my dataset:Column1Column 2Column 3Column 4AAA123456ABCPAAA123456ABC210.72AAA234567ABCPAAA234567ABC28.9BBB345678ABCNBBB345678ABC20.01BBB456789ABCPBBB456789ABC221.2 Here's what I want my data to look like:Column1Column 2Column 3Column 4Column 5AAA123456ABCP10.72AAA234567ABCP8.9BBB345678ABCN0.01BBB456789ABCP21.2...
CMG

Discussions |
Mar 17, 2021 6:42 AM

1898 views | 2 replies
Weighted Least Squares and Residuals

Attached is a sample of real estate sales and house sizes. If you build a model predicting price as a function of size, there is clear evidence of nonconstant variance. So, I created a weight column to do a weighted least squares regression. However, the residual pattern never changes - I tried weights = 1/size, then size squared, cubed, etc. The residual pattern appears exactly the same until...
dale_lehman

Discussions |
Mar 17, 2021 6:00 AM

3840 views | 2 replies
Remove and add wrap variables in graph builder with JSL

When I manually add a line in graph builder via the costume graph script function in the window and then wrap or group it with a nominal variable, the stacked windows will have the same costume line copied. Right click in the graph windows --> Customize --> click on the “+” button (add the “Script” entry) and add the line script (for example with the Samples --> “Drag Line” option). But if I then ...
Mauro_Gerber

Discussions |
Mar 17, 2021 1:50 AM

2887 views | 2 replies
Formula to subtract the average of a subset from a data column?

I am looking for a way to take a subset of a data table that uses only rows matching a specified condition, and subtract the mean of those rows from a column. For example, using the Big Class data set, say I want to create a new column showing "Difference in height between this student and the average 14-year-old of the same gender." The way I know how to do this is by adding a second table, usin...
MarkJSchwab

Discussions |
Mar 16, 2021 7:24 PM

6256 views | 8 replies
Numbering the overlay plots

Hi All, Is there a way I can number the overlay plots? I want something similar to the pic attached below Thanks
Jackie_

Discussions |
Mar 16, 2021 1:16 PM

4756 views | 10 replies

Previous
Next

Latest Discussions

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

2623 views | 3 replies
Selecting a test to determine when to end an experiment?

We have an experiment testing a population's response to a chemical with three sampling points in time. The measurements at these time points are the dosage with a significant effect on the test population. I want to know if the measurements at the first and last time points (middle time point too) are normally equal or different. It would save money to end the experiment at sampling point 1 if t...
joemama985

Discussions |
Mar 16, 2021 6:32 AM

5605 views | 10 replies
Comparing Life Data Sets

Hello, Some statistical SW packages offer the ability to compare two or more sets of reliability or life data in order to determine which of the data sets has a more favorable life distribution. The data sets could be from two alternate designs, manufacturers, lots, assembly lines, etc. The data sets may contain censored data. In general, the problem boils down to that of being able to determine a...
Zvika_BK

Discussions |
Mar 16, 2021 6:03 AM

10546 views | 9 replies
logo + graphbuilder

Hi,In some cases, we need to put a logo or copyright in the background of a graphic if we send the graphic into an email for example.How to set the sizes of the logo or copyright, text, comments if we change the graphic (cf. the image with an additional variable at the top of the graphic) ? Thanks for your help; best regards
Françoise

Discussions |
Mar 15, 2021 10:43 PM

1358 views | 1 replies
Error while hosting the interactive web reports in HTTS protocol

When We are trying to host in a website to share the interactive web reports, it is unable to display it. it displays the error page as "Technical Issue. Please contact administrator". From observation upon investigating on the issue, it does not render due to mix content. jmp pro interactive html internally contains link to http protocol. Basically issue some what related to cross origin. Pleas...
rvkamal

Discussions |
Mar 15, 2021 9:27 PM

1498 views | 1 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

1445 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

1291 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

1093 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

1403 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

3935 views | 0 replies