JMP User Community

Latest Discussions

JSL to create a column that is a cumulative sum based on previous row of other columns

I am using JMP Pro 12.I need help to create a new column ('cum_Qty') in JSL that will be an ongoing sum of the previous rows value in 'Qty'column until meet => 500. If the row qty is => 500 in , the value will update as it in the 'cum_Qty'. Example:In workweek 2, the qty is 633 (> 500) in 'Qty'column, this value is updated as 633 in 'çum_Qty' column.In workweek 3, the qty is 185 (< 500), it sums ...
bzanos

Discussions |
Sep 8, 2020 2:33 AM

1958 views | 2 replies
Check for multicollinearity in Ordinal logistic regression

Hello everyone! I’m running a nominal logistic Reg Model (JMP v13) which has 8 independent variables. I am concerned about collinearity and confounding. How can I check the existence of these two issues? Can you evaluate multi-collinearity with Variation inflation factor in JMP? (kindly, how?) Thanks.
illimani

Discussions |
Sep 8, 2020 12:49 AM

27529 views | 6 replies
Plotting Multiple linear regression line on one graph

Hi There!I have 10 Y measurements all against one X, how do I compare the responses on one graph using the linear regression lines (on the scatterplots)? The Y are in triplicates. I have attached the Excel file with the data.
achengula

Discussions |
Sep 7, 2020 11:39 PM

33286 views | 12 replies
Detect outliers in a dataset with categorical variables

I have a large data set with categorical survey data from > 800 participants. There are 10 categorical variables with 4 nominal levels each. Is there a jmp method for assigning/detecting outlier participants?
frankderuyck

Discussions |
Sep 7, 2020 12:20 AM

5412 views | 3 replies
Common X axis for Graph Builder by loop taking max and min value from a column

Good day JMP community, hope you can help me to solve this concern.We need to show performance in terms of rework rate of a series of defects by tool/day, due to different allocation of tools some period of time, not all tools are utilized the same days, thus charts are giving me different X axis (:DATE INSP).Attached is a sample raw data, then also attached script for my approach.First chart crea...
AndresGlez

Discussions |
Sep 5, 2020 4:44 PM

3465 views | 6 replies

Previous
Next

Latest Discussions

Detect outliers in a dataset with categorical variables

I have a large data set with categorical survey data from > 800 participants. There are 10 categorical variables with 4 nominal levels each. Is there a jmp method for assigning/detecting outlier participants?
frankderuyck

Discussions |
Sep 7, 2020 12:20 AM

5412 views | 3 replies
Assign different spec limits from a column rows to another column rows as a property

Hi I know Spec limit has been discussed here different times but I could not find a solution for my question I have a column with different product and I group the same products but each group has different spec limit. all the spec limits are in 2 columns (Upper, lower limit). I like to assign each row of the product column to the same row in the spec limit column. Could you please tell me how ...
Mikasa

Discussions |
Sep 4, 2020 8:24 AM

6806 views | 14 replies
Apply Column Spec Limits based on Row Conditions

I am seeking some help with whether or not JMP is capable of applying Column Spec Limits based on row conditions and if so how would one go about do that? Attached is a sample table: The key parameters are :part_number, :set_id, :band1, X__57_AVG, X__58_AVG and X__59_AVG. :part_number, :band1 and :set_id are the row (test) conditions while the other 3 are the results from the test. I also attached...
Yngeinstn

Discussions |
Sep 4, 2020 7:39 AM

6394 views | 10 replies
Power BI

Hi, what do you think about power BI? I find there are similarities with jmp e.g. in data visualization. has someone tested? best regards
Françoise

Discussions |
Sep 4, 2020 5:06 AM

4184 views | 2 replies
Gage R&R Formula

Hello, I'm looking for the detailed formula of the Gage R&R study which isn't described in the document "JMP Quality & Process Methods". Someone knows on which basis this analysis is defined, and which formula this is? Example: I have an optical high resolution measurement system, measuring 5 different products each 10 times in an automated cycle repetition (moving the axis forward and backwards ...
Michel_AR

Discussions |
Sep 3, 2020 12:01 PM

6076 views | 7 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

985 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

1099 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

1486 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

1691 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

1421 views | 0 replies