JMP User Community

Latest Discussions

Selecting rows and then further selecting based on that

I have a data table where I can select rows based on one columns result. I would like to then expand that selection based on a value contained in the previously selected rows. I tried dt = Current Data Table(); dr << select where( :ctrlrange > 0.23 ); h = Column( dt, "reagentkit_id" ) << get Values; dt << select where( :reagentkit_id == h ); That didnt seem to work as JMP froze. The dat...
UberBock

Discussions |
Aug 27, 2020 9:13 AM

2561 views | 8 replies
Testing predictive capability of model in normal JMP

Hi, I have developed a model based on a training data set and would like to test the predictive capability of the model on a test data set. In there any way I can do this in normal JMP? My model consists of both continuos and categorical effects. I guess I would have to be able to fix the parameters of the model. Or maybe this is another good reason to get JMP Pro?
StefanC

Discussions |
Aug 26, 2020 11:21 PM

3921 views | 6 replies
How to do a Repeated Measures ANOVA

How do I set up the file and run a repeated measures ANOVA in jmp? I did an experiment where I tracked distance animals traveled over time for three treatments (NCS n=25; CS1 n=24; CS6 n=25). I took the average distance for each group for each 1min period and graphed it for my three treatment groups. I would like to do a repeated measures ANOVA but am unsure how to set this up in jmp and run it. ...
Kat2

Discussions |
Aug 26, 2020 10:58 AM

6555 views | 4 replies
JMP script formula to calculate the delta of multiple different ranges from X coordinates of a .csv file and display on graph, or in a text box

Hi, I have a script that creates the attached graph of some data points and overlays it with an additional line graph. I need to now be able to calculate the delta between the high and low points in multiple different x coordinates. I am able to do the first one since it includes all the x coordinate values, but I am stumped on how to do it for only the x coordinate values in-between the orange ca...
GardDog

Discussions |
Aug 26, 2020 8:46 AM

5654 views | 13 replies
Need Help with JSL for Pressure Compensated Temperature Formula

Hello, I am looking for an example or some guidance on how to get started writing JSL for the following Pressure Compensated Temperature: Create a UI to select a Temperature column and Pressure Column. Also have user input a Reference Pressure, Conversion Factor, Purity factor.Calculate the Pressure Compensated Temperature for each row using several IF statements and mathematical expressions usi...
texas_stats

Discussions |
Aug 26, 2020 6:09 AM

2326 views | 4 replies

Previous
Next

Latest Discussions

Selecting rows and then further selecting based on that

I have a data table where I can select rows based on one columns result. I would like to then expand that selection based on a value contained in the previously selected rows. I tried dt = Current Data Table(); dr << select where( :ctrlrange > 0.23 ); h = Column( dt, "reagentkit_id" ) << get Values; dt << select where( :reagentkit_id == h ); That didnt seem to work as JMP froze. The dat...
UberBock

Discussions |
Aug 27, 2020 9:13 AM

2561 views | 8 replies
How to do a Repeated Measures ANOVA

How do I set up the file and run a repeated measures ANOVA in jmp? I did an experiment where I tracked distance animals traveled over time for three treatments (NCS n=25; CS1 n=24; CS6 n=25). I took the average distance for each group for each 1min period and graphed it for my three treatment groups. I would like to do a repeated measures ANOVA but am unsure how to set this up in jmp and run it. ...
Kat2

Discussions |
Aug 26, 2020 10:58 AM

6555 views | 4 replies
Data Table sort by two columns

Normally data table can sort order by one column, just have left table shows, sort by column "Name".but how to use JMP to sort by two column? order by both "Name" & 'Date", like the right table shows, kindly help to suggest. thanks a lot. NameDateAccomplish amounts of work-->NameDateAccomplish amounts of workJohn20/8/21 9:03:59100%Kevin20/8/17 9:03:5760%Kevin20/8/22 9:03:5980%Kevin20/8/18 9:03:574...
qspringleaf

Discussions |
Aug 24, 2020 9:11 PM

2667 views | 1 replies
Which Run order I have to choose for my DoE?

Hello,I want to perform a DoE in order to optimize an extraction method. My plan is to start with a screening of the main factors using Plackett Burman followed by a central composite design in order to do a response surface. Before making a Design tube I should choose a Run order (sort left to right, sort right to left, randomize...) and I do not know which run order I should choose for each of m...
ELH

Discussions |
Aug 24, 2020 5:00 AM

3999 views | 11 replies
Adding DATE properties to a column in JSL

Hi All,I know we can add DATE stamp to any column in JMP for a time trend as following:right click on any column-> choose column info->Column properties->Other->Type in "DATE" ->Insert the name of column including the dates Is there a script to do that automatically? Thanks a lot!Moe
mjafari

Discussions |
Aug 23, 2020 1:44 PM

910 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

804 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