JMP User Community

Latest Discussions

How to save text file open setting into script

Hello, Problem:I have numerous .txt files. I only care about the data in column 4, starting with row 7 to infinity. I would like to extract all of the data from column 4 from the numerous .txt files and concatenate them into a single table. What is the best way to do this? Ideally, I would like to create a script to execute this. Along the same vein, when I use the File - open method to open the ...
Kathorvath

Discussions |
Apr 29, 2021 7:42 PM

6736 views | 5 replies
Is it possible to use Windows Authentication to connect to a server?

Is there a way to use Windows authentication to create a connection?This is what I'm trying to use:conn = Create Database Connection ("DRIVER=SQL Server;SERVER=" || server || ";DATABASE=" || db || ";UID=" || uid || ";PWD=" || pwd || ";");
Herrera5238

Discussions |
Apr 29, 2021 3:24 PM

2501 views | 2 replies
Interpreting data

So, i have watched video after video to try and interpret this data. I surveyed the black river watershed averaging the riparian buffer widths of 13 sites. I am trying to interpret how this might affect sediment size (D50 ) and percent of intolerant at these transects. I know this has no statistically significant results. But my professor said I need to say more then that. I have also done spearma...
tgrandjean1

Discussions |
Apr 29, 2021 12:40 PM

1051 views | 1 replies
Pooled within-groups correlation matrix

i am trying to locate where in JMP is the 'Pooled within-groups correlation matrix.'I have looked at Multivariate and Discriminant analysis. I can see the correlations and the correlation probability output. But i am looking for the 'pooled' within group correlation. Anywhere i can go in JMP? Nick
Nickbuon1

Discussions |
Apr 29, 2021 12:29 PM

3003 views | 5 replies
Creating a delta column

Hi folks,I am trying to create a delta column.the difference is between mean(normalised) - mean(normalised of the "MATCHED" product)I tried the lag function but this doesnt work as no date.Would I have to create a new column "Matched_Value" and set all row values to the Same as the MATCHED valuethen create my delta = Mean(no...) - Matched...
jearls11

Discussions |
Apr 29, 2021 10:05 AM

2736 views | 3 replies

Previous
Next

Latest Discussions

Interpreting data

So, i have watched video after video to try and interpret this data. I surveyed the black river watershed averaging the riparian buffer widths of 13 sites. I am trying to interpret how this might affect sediment size (D50 ) and percent of intolerant at these transects. I know this has no statistically significant results. But my professor said I need to say more then that. I have also done spearma...
tgrandjean1

Discussions |
Apr 29, 2021 12:40 PM

1051 views | 1 replies
Pooled within-groups correlation matrix

i am trying to locate where in JMP is the 'Pooled within-groups correlation matrix.'I have looked at Multivariate and Discriminant analysis. I can see the correlations and the correlation probability output. But i am looking for the 'pooled' within group correlation. Anywhere i can go in JMP? Nick
Nickbuon1

Discussions |
Apr 29, 2021 12:29 PM

3003 views | 5 replies
Saving figures as EPS messes up intervals

Hi everyone I am trying to put some graphs and figures from JMP into my Latex so I'm using EPS to keep the transparency & scalability without losing image quality. Latex doesn't accept EMF to my knowledge. Unfortunately my JMP (version 15.1.0) seems to output any type of intervals as a solid color instead of a corresponding area that is somewhat transparent when using EPS file format. Here is a sc...
Cristianp

Discussions |
Apr 29, 2021 9:06 AM

1721 views | 3 replies
Make a combined data table from text exlporer

Hello everybody,I have some trouble to create my combined data table from a script.I try to make a script to analyse a table with word and samples.I do manually the text explorer of word (called "Termes" in my data table) by samples (called "Num Ech" in my data table) and than i create a combined data table to have a data table with the count of each word by sample.I found a script to do the text ...
MargauxR

Discussions |
Apr 29, 2021 5:37 AM

1509 views | 2 replies
Bivariate Fit - how to delete fitting lines and results

I would like to my plots simple after fitting each values. I have searched some solutions, but it is not working to my case. I want to delete the box containing all of the "Fit Each Value" line items. It looks that it can be done with report(biv)[PictureBox(2)]<<delete;. But unfortunately, "Fit each value" is not "PictureBox". Instead, it looks "Segments" from display trees. How could I address th...
ohkjuns

Discussions |
Apr 28, 2021 11:27 PM

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

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

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

Discussions |
Apr 20, 2021 1:41 AM

2348 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

1009 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

1235 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

931 views | 0 replies