JMP User Community

Latest Discussions

Combining Data from multiple tables

I'm trying to create a new master table by combining data from two tables (or more). As an example, I'm trying to combine Table A & Table B below into Table A-B as the result:Basically both table A & B have similar column in "start" & "end" but different range for each row. What I'm trying to do is to combine the segments from starting distance 1 to 20 from both table and combine them into table A...
Djtjhin

Discussions |
May 7, 2021 6:47 AM

2630 views | 4 replies
How to display the value of alpha (statistical significance) that is used in the Fit Model graphs? Is it possible with JSL JMP scripting?

Graphs in the Fit Model platform show confidence intervals. For instance, "Actual by Predicted Plot" and "Prediction Profiler". How can I add to the display to show the value of significance or confidence that that interval represents. For instance, if I changed the alpha to 0.1 I'd like to see "alpha = 0.1" somewhere in the platform. Then I can compare the graph to one where the alpha is 0.15...
MiBo

Discussions |
May 7, 2021 5:04 AM

2042 views | 3 replies
mixed model - clarification of terminology and concepts

Hi,I'm learning about the mixed model platform in JMP and I have a few questions that mix the theory with JMP's way of doing it. I'd like to ask for some help to explain as the way that the model is entered is crucial. The documentation is very technical and sparse. I've watched both mastering JMP videos on mixed models already, and they give examples but there's a lot left out. I'm finding it dif...
utkcito

Discussions |
May 7, 2021 4:03 AM

1871 views | 1 replies
Category Bias kNN

v16 has added an option to the k-Nearest Neighbor platform called Category Bias. What is this? I can't find any specifics about this option in the documentation. And, importantly, What numerical value should the Category Bias be set to in v16 to make the kNN results identical to those produced by v15 which does not have a Category Bias?
MAS

Discussions |
May 7, 2021 3:16 AM

1073 views | 1 replies
Creating heatmap on a datatable and updating color gradient with script

Hi,I have a lot data that I like to plot as a heatmap from a data table. I have attached an image below of a sample data table image and the steps I do to create the heatmap on the data table. It follows the following steps:Get a datatable after using tabulateStack all the columns (except for 'type'). Then do a summary of the whole data set to find min, median and max.Take the min, median and max ...
tarkan_bih

Discussions |
May 6, 2021 1:22 PM

4670 views | 8 replies

Previous
Next

Latest Discussions

How to display the value of alpha (statistical significance) that is used in the Fit Model graphs? Is it possible with JSL JMP scripting?

Graphs in the Fit Model platform show confidence intervals. For instance, "Actual by Predicted Plot" and "Prediction Profiler". How can I add to the display to show the value of significance or confidence that that interval represents. For instance, if I changed the alpha to 0.1 I'd like to see "alpha = 0.1" somewhere in the platform. Then I can compare the graph to one where the alpha is 0.15...
MiBo

Discussions |
May 7, 2021 5:04 AM

2042 views | 3 replies
Category Bias kNN

v16 has added an option to the k-Nearest Neighbor platform called Category Bias. What is this? I can't find any specifics about this option in the documentation. And, importantly, What numerical value should the Category Bias be set to in v16 to make the kNN results identical to those produced by v15 which does not have a Category Bias?
MAS

Discussions |
May 7, 2021 3:16 AM

1073 views | 1 replies
Linear (Holt) Exponential Smoothing

My experience with Time Series in JMP is relatively short, so forgive me if this question seems basic. Forecasting in the covid environment can be challenging at times due to lockdowns in various parts of the country. I’m trying to run the Linear (Holt) Exponential Smoothing for +2K locations based on most recent trends using Time Series – Autocorrelation by location. The results give me a time se...
bab02rs1

Discussions |
May 6, 2021 12:30 PM

1577 views | 2 replies
Do JMP DT Columns with Special Characters in them (/, ., etc.) Need their Special Characters Escaped in Formulas?

I have a column with a backslash in the title, do I need to either escape it or put the column's name in quotes when referencing it in a formula in a JSL script?Mike
mostarr

Discussions |
May 6, 2021 12:17 PM

1233 views | 1 replies
How to open Shape files fron Q-gis in JMP?

how to open shp.file from external source? I have a shape file and other files imported originally from Q-gis.I really want open this files in JMP for make or see the map and its atributes like poligons. But I cant open and convert.Someone know about the steps for open shp.file from external source on JMP? how do I translate these files into a format that JMP understands?Thanks!
jonasN

Discussions |
May 6, 2021 7:27 AM

1593 views | 4 replies

Previous
Next

Latest Discussions

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

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

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

Discussions |
Apr 20, 2021 1:41 AM

2279 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

971 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

1183 views | 0 replies
JSL Syntax Change is coming: Name() is being deprecated

Hi All, I just read here that the JSL syntax for referencing a column using the Name() parser is going away. The new syntax is currently in use and at some point the old syntax will be removed entirely. There's a lot of people here who script, so thought it would be good to post something here. I know I have a lot of code I'll need to change! Better to be ahead of the curve and change it befor...
SDF1

Discussions |
Apr 7, 2021 10:14 AM

886 views | 0 replies