JMP User Community

Latest Discussions

Data subset indexing tips

I have a bunch of concatenated test runs output that have columns: time, position, speed, etc. ... and time goes from 0 to some number, e.g. 50, then resets to zero and starts up again. I'd like to make a new column, setid, that indexes the sets, so the first set (time 0-50) gets a "1" in the setid column, the second set (time resets to 0...) gets a "2" in the setid column, etc. Is there a smart/...
BHarris

Discussions |
Jul 23, 2020 10:12 AM

1409 views | 1 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
Auto Scaling of Variability Chart Y-axis based on USL & LSL spec limit

When there is outlier data, my chart is always being scaled to mix or max point, which make the chart not visible.Is that possible to use JSL script to set the Variability Chart Y-axis dynamically based on the parameters USL & LSL limit that already embeded inside the parameters? Please advice. Thanks
OneNorthJMP

Discussions |
Jul 23, 2020 7:10 AM

19809 views | 15 replies
pooled /unpooled t test

Hi What is the appropriate two sample t procedure for the summary below milking periods of cow breeds pooled/unpooled (Welch) using R?Frisian cow Xbar=342.5 S1=10.2 n1=126Jersey cow Xbar =348.6 S2=12.2 n2=39Construct 95% confidence interval for µ1-µ2Give proper interpretation of the intervalThanks
Alma1

Discussions |
Jul 22, 2020 4:33 PM

8653 views | 10 replies
bin each row based on date time

I often need to bin each row based on the date time. However, this is kind of troublesome for the data time. let say I am binning based before 7/22/2020 12:00:00pm as Good and after as bad. I can use the IF formula logic to compare the date time to 7/22/2020 12:00:00pm. But to do that I need to convert to the numeric value of 3678264000. if there any quicker way to do this? thanks
wencun6

Discussions |
Jul 22, 2020 3:40 PM

2018 views | 5 replies

Previous
Next

Latest Discussions

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
bin each row based on date time

I often need to bin each row based on the date time. However, this is kind of troublesome for the data time. let say I am binning based before 7/22/2020 12:00:00pm as Good and after as bad. I can use the IF formula logic to compare the date time to 7/22/2020 12:00:00pm. But to do that I need to convert to the numeric value of 3678264000. if there any quicker way to do this? thanks
wencun6

Discussions |
Jul 22, 2020 3:40 PM

2018 views | 5 replies
How can the minimum value of the specified column corresponding to each category be greater than the number of categories of a certain value?

For example, according to "Big class.jMP"
1. First, categorize by age.
2. Determine the minimum "weight" >90 for each age.
3. Figure out the number of age categories that meet the second condition.So it turns out the number of ages is 3. How can I use JSL to solve it quickly?Thanks!
lwx228

Discussions |
Jul 22, 2020 3:25 AM

1378 views | 3 replies
Autocorrelation by JMP14

I check my training powerpoint file I was trained on year 2007. When we want to make control chart, we have to check normality of data. And also autocorrelation by JMP. I try to search autocorrelation check on JMP14 but I cannot find it. Any function in JMP14 to use instead of autocorrelation.

In the previous version of JMP we need to go by Autocorrelation Check – In JMP:Analyze > Modeling > Tim...
ThoYala

Discussions |
Jul 21, 2020 10:38 PM

3687 views | 3 replies
Details about robust standard deviation from "Distribution" module?

The JMP documents guide me to the book by Huber & Ronchetti (2009). But it's still not clear for me how to calculate the robust standard deviation.Thanks!
jennyli

Discussions |
Jul 21, 2020 12:10 PM

4521 views | 3 replies

Previous
Next

Latest Discussions

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
[JSL Contour Plot] Method of define contour plot, number, minimum, maximum

The contour plot is very helpful to show 3D map, however the problem of defining the zone is always a trouble. In my typical jsl plot, I use something below to define the contour plot zone number = 8, maximum = 1.4, minimum =1. However, the table column :Length may change time to time, and the scale will have to be modified manually for each corresponding plot. Does someone have experience how t...
Stokes

Discussions |
Jun 25, 2020 12:09 PM

984 views | 0 replies
Impact of screen resolution on html output

Hi, I'm preparing a dashboard using jmp that will be used for a daily meeting. It contains information in form of data tables and text boxes. In order to transfer text sizes and colors for the text as well as the data tables into the html output I transformed them into pictures (rep = dt << get as report(); pic = rep << get picture(); ). I set up all font sizes on my external monitor and it worked...
Ole

Discussions |
Jun 9, 2020 6:21 AM

945 views | 0 replies