JMP User Community

Latest Discussions

Fit Model - Custom Test

Hello everybody,I have a question regarding the Fit Model platform. Let's say that I am working with the Big Class data table. My Y variable is height and I have two effects in my model: age and sex.I would like to know if the height difference between the groups 12 and 17 for M is significantly different from the height difference between the groups 12 and 17 for F. I think I can use the "Custom ...
anne_sa

Discussions |
Aug 31, 2020 11:34 PM

4276 views | 8 replies
List the value for Max Date?

I have a data table that has a date column, median_resultval column and reagentMLot_sublot . What I would like is that for the Max(Date) what is the value by reagentMLot_sublot. So for each reagentMLot_sublot I would like to list the median_result value for the Max Date and the median_result for the min date. So if on the min day the median value is 0.1 and on the max day it is 0.2 I would like...
UberBock

Discussions |
Aug 31, 2020 8:03 PM

3996 views | 9 replies
UPDATE JOIN SQL statement with JMP tables

Hi, I would like to update via SQL statement the :age column in dt1 with the values of dt2. dt1 = Open( "$SAMPLE_DATA/Big Class.jmp", output table("t1")); dt2 = subset(dt1); dt2:age[1] = 99; Query( Table( dt1, "t1" ), Table( dt2, "t2" ), "\[ UPDATE t1 SET t1.age = t2.age FROM t1 INNER JOIN t2 ON t1.name = t2.name ]\" );I got an syntax error near "." Thanks
TWE

Discussions |
Aug 30, 2020 11:23 PM

1622 views | 2 replies
How to find the mode of multiple columns and partial rows?

For example, add new columns with "Big Class. JMP ", and find the mode of the data in the same row of the "height"、"weight" columns and the five rows above. Thanks! mode(Range(:weight[Index(Row()-5,Row())], :height[Index(Row()-5,Row())]))
lwx228

Discussions |
Aug 30, 2020 5:47 PM

2175 views | 6 replies
Partition Modelling: What dictates Minimum Size Split?

I am not a de facto statistician but have gained much experience in biostatistics over many years, thanks largely to using the standard version of JMP (currently v13). I certainly cannot imagine using anything else and regularly promote it.I am presently progressively defining partitions in a variety of continuous variables to optimise outcome in a binomial categorical variable (fail versus pass)....
34South

Discussions |
Aug 30, 2020 2:02 PM

3113 views | 4 replies

Previous
Next

Latest Discussions

List the value for Max Date?

I have a data table that has a date column, median_resultval column and reagentMLot_sublot . What I would like is that for the Max(Date) what is the value by reagentMLot_sublot. So for each reagentMLot_sublot I would like to list the median_result value for the Max Date and the median_result for the min date. So if on the min day the median value is 0.1 and on the max day it is 0.2 I would like...
UberBock

Discussions |
Aug 31, 2020 8:03 PM

3996 views | 9 replies
Partition Modelling: What dictates Minimum Size Split?

I am not a de facto statistician but have gained much experience in biostatistics over many years, thanks largely to using the standard version of JMP (currently v13). I certainly cannot imagine using anything else and regularly promote it.I am presently progressively defining partitions in a variety of continuous variables to optimise outcome in a binomial categorical variable (fail versus pass)....
34South

Discussions |
Aug 30, 2020 2:02 PM

3113 views | 4 replies
How to save a file with name as a variable in For loop to save multiple files

Hi, I am trying to save files in a for loop, the problem is how to put a variable into the file saving procedure, However, it looks the file save part is not working. I didn't use any clear global to make sure filename has be assigned with the original value. Is there any problem with my saving part? Thanks // filename is a variable assigned below, For( j = 1, j <= N Row( sdt ), j++, filename...
Stokes

Discussions |
Aug 28, 2020 4:29 PM

2359 views | 2 replies
Box Plots Shifted in Graph Builder

For some reason I can't figure out, my box plots are appearing on either side of the ordinal x-axis line in this graph building chart. I can see the boxes well enough but why off-center (left of the grid line on the LHS and right of the grid line on the RHS)? Running on Mac, JMP® 14.2.0 Thanks!
datanaut

Discussions |
Aug 28, 2020 7:30 AM

3711 views | 5 replies
How to get lowest two row values in grouped data ?

Hi, Lets say we have data like this and want to get lowest two row values. Group by Age and Sex, get the two lowest height values. How can we do this in JSL? Thanks
joshua

Discussions |
Aug 27, 2020 11:44 AM

1277 views | 1 replies

Previous
Next

Latest Discussions

order statistic for DS Weibull ... maximum failure time for n fails out of N~n/p units

this isn't a JMP question per se, but a reliability/survival statistics question ... see my post on Cross Validatedthanks in advance! https://stats.stackexchange.com/questions/483556/order-statistic-maximum-for-subpopulation-weibull-distribution
galactus3000

Discussions |
Aug 18, 2020 8:48 AM

720 views | 0 replies
Custom Lat Long Contour Map

Hi all, Playing around with the Custom Map Creator add in and I ran into some trouble when trying to construct borders for a river system. When constructing a custom map border using a a background map the boundaries function does not let me to trace the river pattern as accurately as I would hope (see attached photo). Alternatively, when constructing a border from a background photo the bounda...
MikeDereviankin

Discussions |
Aug 14, 2020 11:03 AM

802 views | 0 replies
XPath Query() and XML namespaces

I have a bunch of XML documents that I want to put into a data column. I want to use XPath expressions to pull out values from them, by appending columns that contain formulas that make use of the XPath Query() function. Some of my documents have XML-namespace qualified element names. For example, one might look like this: <?xml version="1.0" encoding="UTF-8"?> <synopsis xmlns="http://www.cap.org/...
john_madden

Discussions |
Jul 23, 2020 9:53 AM

976 views | 0 replies
Using JMP to Calculate Surface Flatness

Has anyone used JMP to calculate the Minimum Zone surface flatness of a point cloud? I have some differences between two metrology areas for our surface flatness requirements and wanted to check them in JMP. There are different algorithms for doing the calculation. (There is an ASME standard for the general rule, ASME Y14.5: " a tolerance zone defined by two parallel planes within which the surfa...
jay_holavarri

Discussions |
Jul 20, 2020 11:26 AM

1271 views | 0 replies
Save all scripts and close reports by JSL

Trying to write a script for this I found the following below working. JMP15@Win10.The first part opens two tables and starts some Reports,and the second Closes all report Windows post saving scripts to belonging tables.But when the report has a local datafilter, the script is not working any more (get scriptable object doesn't get the Right reference).Is there a way to find proper reference for e...
Georg

Discussions |
Jul 20, 2020 7:48 AM

1123 views | 0 replies