JMP User Community

Latest Discussions

Quantiles with missing values

If I have a column named X with 100 values which is a sequence from {1-100}, and I want to retrieve the 10 smallest values, I know I can use the command below:dt = current data table(); temp1 = dt:X << get values; temp2 = quantile(0.1,temp1); dt << get rows where(:X<temp2);Let's say I'm replacing the 10 largest values (i.e. 91-100) with missing values, is there a way to get the same 10 smallest va...
Djtjhin

Discussions |
Jun 11, 2021 7:45 AM

1232 views | 3 replies
How can I use recode to prepend a character string to each value?

The situation is that I have a column of sequential values "A", "B", "C", ... and I want to transform them to "Label A", "Label B", "Label C", ...I know how to do this with a column formula or with JSL, but I was wondering if this is possible with Recode? Perhaps with using a regular expression? Any ideas on how to do this with Recode?
MathStatChem

Discussions |
Jun 11, 2021 1:00 AM

6201 views | 5 replies
Name Unresolved. Works when I re-do script but not in original script??

So I have a script that is creating YbyX plots, doing a Tukey T-Test, then creating a combined dt with the p-Values, then selecting and excluding based on the p-Value. I currently have it embedded inside a dt << New Script() function to save it to the source data table. I'm not sure what is going on but when I get to the section to select the p-Values, I get this error:dt1 << select where("p-Value...
aliegner1

Discussions |
Jun 10, 2021 2:50 PM

1526 views | 1 replies
Generating Box Plot with Overlayed Histogram?

Is there a way to generate a box plot with the histogram of the data overlayed on top of the box? Similar to the attached picture from Spotfire. I used Spotfire at my previous company. Now we are using JMP. I'm trying to create some plots that look similar to better understand the data. Thanks.
MattBraunstein

Discussions |
Jun 10, 2021 9:55 AM

3961 views | 3 replies
How can copy the column name of a specified column to the Clipboard?

Use jsl.For example, open "Big Class.jmp" and copy its second column name to the clipboard. Thanks!
lala

Discussions |
Jun 10, 2021 9:05 AM

1446 views | 2 replies

Previous
Next

Latest Discussions

Name Unresolved. Works when I re-do script but not in original script??

So I have a script that is creating YbyX plots, doing a Tukey T-Test, then creating a combined dt with the p-Values, then selecting and excluding based on the p-Value. I currently have it embedded inside a dt << New Script() function to save it to the source data table. I'm not sure what is going on but when I get to the section to select the p-Values, I get this error:dt1 << select where("p-Value...
aliegner1

Discussions |
Jun 10, 2021 2:50 PM

1526 views | 1 replies
How can copy the column name of a specified column to the Clipboard?

Use jsl.For example, open "Big Class.jmp" and copy its second column name to the clipboard. Thanks!
lala

Discussions |
Jun 10, 2021 9:05 AM

1446 views | 2 replies
How to prevent unlocking data table?

Hi,I am really new to JMP.I created a script to import data from an Access DB through Query Builder.I used the following to get a locked data table and it worked. dt << Lock Data Table( 1 )I need users to open this locked table to review data but I noticed that it is possible to unlock data by clicking on the top-left red triangle (see screenshot attached) and selecting Unlock Data Table. Is there...
FabioSaragoni

Discussions |
Jun 10, 2021 7:05 AM

1039 views | 1 replies
Process Capability Physical Boundaries

How can one set physical boundaries in process capability analysis. For example, when I evaluate capability to measure within specification of a trace element in a material, most data will be near zero, but cannot be less than zero. This results in a highly skewed distribution with the bulk of the data piling up around zero and then the distribution has only a one-sided tail. But the capability...
Goblin_King

Discussions |
Jun 10, 2021 5:31 AM

975 views | 1 replies
Distribution platform

Hello,Need some advice.I used distribution platform to check best fit for my data. I wanted to know, if there is any way to check what is the level of error (in central tendency and variance) introduced if we assume a non-normal distribution as a normal distribution.
billi

Discussions |
Jun 9, 2021 6:42 AM

1324 views | 3 replies

Previous
Next

Latest Discussions

Using a List to Filter in Custom Query Builder - Question

Hello, I would like to use a list to filter within a continuous column in Query Builder. Range and then join does not work as my data set from my database will be tens of millions of lines, so I would like my list to be the only thing queried. I would like to use a list (I have a separate data sheet with the column) of about 40 or so unique numerical values and use that in the filter for a custom ...
Benjamin_S

Discussions |
Jun 3, 2021 7:59 AM

1073 views | 0 replies
Can I control text size in a word cloud inside a dashboard container?

Hi all,I have a dashboard with a data filter, a map, and a word cloud that looks like image 1 below. I have two formatting issues with the word cloud I'd like to fix. First, by design, when I make different selections using the data filter, the subset of records that are shown in the map changes and the word cloud applies only to that selection. However, when I change the data filter selection, th...
caseylott

Discussions |
Apr 28, 2021 12:03 PM

1007 views | 0 replies
多重比較での生存曲線の書き方　Bonferroniなど

4群での生存曲線をJMPproでの書き方を教えて下さい。また、JMPで「環境設定グループ」から「レポート」を選択し、「ローカルデータフィルター」を出せればできる方法も紹介されていたのですが、「ローカルデータフィルター」を出せません。どの方法でもよいので、JMPProで、多重比較法を用いた生存曲線の書き方をどなたか教えてください！宜しくお願い致します。
27070

Discussions |
Apr 20, 2021 1:41 AM

1957 views | 0 replies
Fantasy Baseball League

I am in a 16 team fantasy baseball league. Each week we tabulate totals for home runs, batting average, stolen bases, wins, saves, era, etc. If my team has the most home runs, I win that category for the week. We track 10 statistics so after each week I may have a final score of 6-3-1. My question is how can I use JMP to check what my score would have been if I had played each of the other 14 team...
atlas100

Discussions |
Apr 19, 2021 1:29 PM

794 views | 0 replies
Generation of overdispersed poisson count data (vs gamma poisson)

Hello, I would like to reconcile the parametrization used in the Random Gamma Poisson(lambda, sigma)with the over-dispersion parameter as estimated in generalized linear model platform. Take for instance the attached table. Here the generating function is Random Gamma Poisson(exp(1+3*:X1),10)Running glm with poisson/log + overdispersion I obtain: Overdispersion = 6.09. Is there any way to link...
matteo_patelmo

Discussions |
Apr 12, 2021 9:53 AM

957 views | 0 replies