JMP User Community

Latest Discussions

how to convert p value of <.0001 to actual number

Is it possible to get an actual number for pvalues instead of "<.0001"?
jaboraws

Discussions |
Sep 16, 2020 6:40 AM

17985 views | 16 replies
creating data table from min-max dates and making a spine of data

I'm back from an 7 year hiatus from JMP scripting and I'm looking for some help to create a data table based on min and max dates and a list of things. I'm already importing the list of things from an excel file and it's in a data table, but what I need to do is take my min/max dates and combine them with my list of things by iterating on a 1 month interval from the min date to the max date (inclu...
JM13

Discussions |
Sep 15, 2020 2:37 PM

3287 views | 5 replies
Benjamini-Hochberg (FDR) exact calculation?

Hi JMP Community,For as long as I can remember, I have used an approximation of the Benjamini-Hochberg FDR calculation to account for multiple testing: > On a sorted list of Nominal P Values (smaller to larger) : BH p Val = Nom P Val * N Row()/Row ()However, I'm aware of some limitation with this approach:For large Nominal p Values, the formula described above returns values > 1 (not by much but i...
Thierry_S

Discussions |
Sep 15, 2020 6:35 AM

3272 views | 1 replies
Surface plot with different z and contour axes

I would like to plot a surface plot with x, y, and z axes as the positions in the graph "cube" but use a different axis (I'll call this axis "p") to overlay data on top of the surface. However, when I plot a surface using my 4 axes, as soon as I put Z as my response and choose surface as a style, the surface fill defaults to Z's values which isn't very useful. It's basically plotting the same vari...
burakbagdatli

Discussions |
Sep 15, 2020 4:19 AM

5169 views | 4 replies
How can I use a jmp script to select specific rows and delete specific rows using multiple arguments?

I have tried looking this up in the help guide, and it looks like I am applying it correctly, but it does not seem to be working. Could someone please check if I am missing something? I have a column that I created from another column and rounded the values. I need to keep only a range of the rows based off of values in the new column. I want to keep only New Y values that are between 50000, and 5...
GardDog

Discussions |
Sep 14, 2020 11:26 AM

6445 views | 7 replies

Previous
Next

Latest Discussions

creating data table from min-max dates and making a spine of data

I'm back from an 7 year hiatus from JMP scripting and I'm looking for some help to create a data table based on min and max dates and a list of things. I'm already importing the list of things from an excel file and it's in a data table, but what I need to do is take my min/max dates and combine them with my list of things by iterating on a 1 month interval from the min date to the max date (inclu...
JM13

Discussions |
Sep 15, 2020 2:37 PM

3287 views | 5 replies
Distribution Platform: Difficulty Using "Set Spec Limits for K Sigma" when all fits are used

Hi. In the Distribution platform, is there a way to refer back to a fitted distribution if the Fit Distribution("All") option is used? Context: I have a script that fits multiple distributions to my data using the Distribution platform. When I include the Fit Distribution("All") option, the report includes a table "Compare Distributions" with the ranking of each distribution. For example: Names...
nikles

Discussions |
Sep 14, 2020 7:24 AM

2655 views | 3 replies
vertical line and annotation

I watched an on-air video and tried to come up with a Control chart including the vertical lines and comments (annotations). I got the lines but the comments are all messed up. I tried number of things but no success. Can you please see the attached file, code and let me know what the issue is?
Sebnem

Discussions |
Sep 13, 2020 3:13 PM

3950 views | 3 replies
Script to control the Profiler

I like adding buttons to my toolbar that run scripts that execute actions of common tasks I do vs having to dive multiple layers into an option menu. My most recent goal is to add some buttons that would control steps i take in the profiler. Specifically I'd like to click a button to have the profiler maximize desirability, one for set the profiler to a row, and one to save current profiler sett...
shampton82

Discussions |
Sep 13, 2020 1:54 PM

2345 views | 3 replies
How to use data filter for a column with empty cells without deleting the cells?

Hi I want to make a filter in my report for a column that has a few empty cells. Other cells have the name of products. When I use Data Filter, nothing shows up in the report and I think it is because of empty cells. I tried to exclude them but did not work Add Filter( columns( :Entity1, :Entity2, Where( :Entity1 != "" ), Where( :Entity2 != "" ), ), Display( :Entity1, Size( 120, 100 )...
Mikasa

Discussions |
Sep 13, 2020 10:35 AM

3003 views | 4 replies

Previous
Next

Latest Discussions

Default encoding on JMP - EUC-KR

Hi,I have JMP 14.2, 15.1, and also 16.0EA at the moment.All versions here don't include EUC-KR encoding system; so this can cause importing problems in many cases since a lot of Korean data or pages are made with EUC-KR. I have charsets that are all broken. So I had to import it with other programs and save as to fit into UTF-8 or match/join columns with other matching codes.It seems like JMP is a...
joelahn

Discussions |
Sep 10, 2020 1:26 AM

1482 views | 0 replies
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

1015 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

1141 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

1544 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

1734 views | 0 replies