JMP User Community

Latest Discussions

How to check if values in one datatable exist in another datatable

All, I have 2 data tables (Table A and Table B) . Table A has a couple of 1000 rows while Table B has a couple of million rows . They have a common column lets say Col C - I want to get the rows of Table B which have matching values in Col C . for( i = 1, i <= N Rows( TableA ), i++, SelectedRows = TableB << Get Rows Where(TalbeB:ColC == TableA:ColC1 ); ); While this works to some ...
uday_guntupalli

Discussions |
Oct 10, 2016 1:33 PM

13667 views | 3 replies
Process Capability

Hello,Trying to add a list of the variables (“Process Variables”) in Process Capability plot.It works for single item from the list, but it does not work for whole list. lTest = Data Table("dtGoal") << get column names( numeric); Data Table("dtGoal") << Process Capability( Process Variables( eval(lTest[i]) ), // it works for any i// Process Variables( eval(lTest) ), // does not work _...
vladbondarenko0

Discussions |
Oct 7, 2016 8:49 PM

11378 views | 4 replies
Graph Builder histogram y-axis

I am trying to create frequency histograms of fish lengths in Graph Builder with both an X (species) and Y (lake) grouping variable. How do I display the y-axis as % frequency? The current histograms have no y-axis.
joebuck

Discussions |
Oct 7, 2016 7:07 AM

10638 views | 2 replies
How to "Suppress Eval" ?

Hellotrying to put a formula that simply counts (increments) based on the occurences of the same asset_num in time. I like this formula to be calculated one time and then either suppress eval OR even delete formulae.Any help will be appreciated. below, I tried suppress eval(false) to let the formula calculate and then suppress eval(true) to suppress it... it did not work. thanks::MyCntDwn2 = Funct...
altug_bayram

Discussions |
Oct 6, 2016 8:28 AM

12889 views | 3 replies
How to save residuals from logistic regression?

I did logistic regression in the Fit Model platform, but could not find a place to save residuals. Any ideas? Thank you very much!
xiaoyaj0

Discussions |
Oct 6, 2016 6:37 AM

12413 views | 4 replies

Previous
Next

Latest Discussions

How to save residuals from logistic regression?

I did logistic regression in the Fit Model platform, but could not find a place to save residuals. Any ideas? Thank you very much!
xiaoyaj0

Discussions |
Oct 6, 2016 6:37 AM

12413 views | 4 replies
How to record data preparation steps to data table

Hi,I have a series of scripts which help a user clean up the data and gathers some background information. It has already been answered how to save this data to the same folder as the data tables either from a platform or the log. I can also save limited data as table variable but not something like an associative array.If I want to ensure this meta-data is kept within the data table is the best ...
stephen_pearson

Discussions |
Oct 5, 2016 7:37 AM

4062 views | 2 replies
Opposite of Default Local

So, just some syntactical sugar.It would be really nice if there was an opposite of declaring local variables for functions.i.e. instead of:example= function({a,b}, {c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w}, c = a+b; d = c+a; //... x = v+w; y = x+b;);print(x,y);I could write:example= function({a,b}, {Default Local, x, y}, c = a+b; d = c+a; //... ...
msharp

Discussions |
Oct 4, 2016 6:58 PM

9019 views | 5 replies
I am having trouble getting any reliable background map to appear, including all WMS link I've tried and the NASA server. Can anyone please help me find a high resolution map of Scotland that I can use as a background map image?

I've been working on this issue for weeks now and still haven't made any progress. My survey data is long/lat tagged and will plot well in Graph Builder and bubble plot. I would really appreciate some help finding a high-resolution background image map of Scotland to use in my data presentations. The simple/detailed earth images are not clear enough; they show up quite pixelated and very hard t...
elliot_meador_s

Discussions |
Oct 4, 2016 6:50 AM

12802 views | 12 replies
How to get the parameters of a bivariate normal density ellipse?

I would like to be able to extract the parameters of an ellipse drawn in a bivariate plot. By parameters I mean, the long and short axes and direction of the long axis, not just means and std devs. Is there a way?
jacaalgo

Discussions |
Sep 29, 2016 7:16 AM

6360 views | 2 replies

Previous
Next

Latest Discussions

Odds ratios for multiway tables

On twitter earlier today, someone asked if the Cochran-Mantel-Haenszel (CMH) odds ratio (OR) test was available in JMP when the stratification variable is not the X in Fit Y by X. Anytime I need to go from two variables to more than two variables, the first place I look is Fit Model. The beauty of fit model is that not only can I use as many variables as I want, but I can consider interactions bet...
DonMcCormack

Discussions |
Aug 10, 2016 3:35 PM

4886 views | 0 replies
How to find ETA squared effect size for MANOVA?

Hello, Does anyone know how to calculate the eta squared value from a manova analysis in JMP? I know that the E and H matrices tab shows the sum of squares for each parameter, but which values do I use to calculate SStotal and SSeffect? In my model, I have 2 control variables (age and gender) and then a two way factorial. If only one of these variables (in addition to both control variables) is si...
nsalmano_stanfo

Discussions |
Aug 8, 2016 7:04 AM

3909 views | 0 replies
Is there an easy way to get the FWHM (full width half max) of a curve using JMP?

Dear JMP community,Is there an easy way to get the FWHM (full width half max) of a spectral curve using JMP? Finding the minima and maxima are fairly straightforward, but then calculating the FWHM seems to be much more laborious in JMP, especially if the data is sparse and we would like to interpolate to get more accurate intersections between the peak and the FWHM value. In my case, the peak is o...
mcjorge

Discussions |
Jul 22, 2016 8:13 AM

5189 views | 0 replies
Co-Kriging with JMP and Matlab

Hi!I was wondering if anyone already tried to work with Co-Kriging, using JMP together with Matlab. As JMP only fits Ordinary Kriging Models (Gaussian Process with Gaussian Correlation Function), I would like to send data (generated with Space Filling JMP Platform) from JMP to Matlab, fit the models there (Matlab), and bring the MODELS back to JMP, to use inside Profile Platform. Do you have any e...
samuelbbaco0

Discussions |
Dec 4, 2015 12:32 PM

3617 views | 0 replies
Interpreting canonical structure and scores in discriminant analysis

I'm trying to interpret the relative contributions of my variables in a discriminant function analysis of chemical data for three groups of rocks. In a stepwise, linear, common covariance discriminant function analysis I'm able to generate non-overlapping 95% confidence ellipses for my three groups with no incorrectly assigned data points using 6 variables. My understanding is that the scoring c...
amzipkin

Discussions |
Oct 20, 2015 3:25 PM

3588 views | 0 replies