JMP User Community

Latest Discussions

New Column : Set Initial Value from List Data

Hi The script will read numeric column name from the file. If there is only 1 column, I want to create the new column and assign value in the column with the header reading from file. In below case, the new column should have initial value = ITH I use below script but it doesn't assign the initial value. Not sure why. ColList2 = Data Table( "raw data" ) << get column names( numeric ); if(n items...
yanee

Discussions |
Aug 27, 2020 9:29 AM

2896 views | 4 replies
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

3446 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

5072 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

8200 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

8023 views | 13 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

3446 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

8200 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

3193 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

5550 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

1136 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

897 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

1003 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

1314 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

1559 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

1312 views | 0 replies