JMP User Community

Latest Discussions

How does JMP derive 95 percentile of a data set with limited data points?

For a data set with 16 points shown below,IDData1-2.538022-0.988773-0.596794-0.454445-0.265736-0.20277-0.1079880.12442290.156302100.162865110.469599120.667054130.787399141.209767151.414172161.718419 Tabulate the data generates the following stats:Min-2.53802Mean0.097223Quantiles500.140362Quantiles951.718419Max1.718419Std Dev1.023793 I am curious to know how JMP derives 95 percentile or for any ran...
ILoveJMP

Discussions |
Nov 9, 2016 3:39 PM

9593 views | 1 replies
JSL - Creating a table from existing table

Hi All, So I have this issue where I would like to make a new table, out of an existing table, but want to pull values out of specific rows and add them to new columns. My existing table looks something like this: Subject Value1 Value 2 Value 3NC1 26.2 13.1 6.2NC2 28.5 14.3 45.6PC1 22.5 12.5 75.3VC1 63.9 ...
drblove

Discussions |
Nov 9, 2016 1:12 PM

9488 views | 1 replies
How do I join two data tables without losing data?

I am trying to Join two tables. I am using three common Source Columns as matches. When I get the new output table, it is missing data. I have selected 'Merge same name columns' and 'Include non-matches' before creating the new table. The three Source Columns appear to be exact matches in the rows that have missing data. What would cause me to lose data when creating the new table? I am not script...
ShannonK

Discussions |
Nov 9, 2016 11:35 AM

29871 views | 11 replies
Adding a column, and adding a different string for each loop

I am putting together some code where I'm trying to loop through openning files and adding the file to the end of the file for a table. So if openning three files basically it appends it to the end of the first file for the table, but I'm having two issues, but will just talk about the one here. I add a column to the output table path, so I could keep track of where it was going. So here is the ...
drblove

Discussions |
Nov 9, 2016 7:58 AM

9711 views | 2 replies
Regex to pull file from path with JSL

I am sure this is a straightforward answer to this question, but if I have the following: full_path[i] = "C:\dir1\dir2\dir3\dir4\file.xlsx"and I want to get just "file.xlsx" and the directory depth is variabile, i.e. maybe 2 directories maybe 5, how would I do it? In Perl I would split the string into an array by the \ and grab the last part of the array, but not sure how to do this in JSL. Any ...
drblove

Discussions |
Nov 9, 2016 7:35 AM

16058 views | 5 replies

Previous
Next

Latest Discussions

How to customize axis labels?

Yes, I know there's an Axis Settings option but it doesn't appear to be able to give me what I need... Basically, I need to able to vary the tick increment. I have data for days 0, 3, 7, 10, and 14 and I need those to be the x axis labels. I can't do an increment of 3 or of 4 because then, obviously, one or several of those days would not be on the x axis. Is there any way that I can customize/cho...
bswhitti

Discussions |
Nov 8, 2016 7:20 AM

5170 views | 3 replies
Legend based on 2 columns

Dear all, I have a huge data table like following Continent State City PopulationUSA Pennsylvania Philadelphia ---- USA Pennsylvania Harrisburg ----USA California San DiegoUSA California San Fransisco Europe France Pa...
rahulsmils

Discussions |
Nov 7, 2016 11:29 AM

4360 views | 1 replies
How do I perform a nested gauge R&R across a process range

Hello, I am quite familiar with designing and executing crossed Gauge RR studies within JMP. Recently, I was asked to perform a nested study as the process under observation is destructive. For background, we are trying to establish the effectiveness of an automated inspection system tasked with measuring the size of nanoliter volume spots applied to a piece of plastic. The volume of fluid is so l...
jecuzens

Discussions |
Nov 4, 2016 1:21 PM

5127 views | 1 replies
SAS PROC MIXED and JMP Output are Different

Dear All,I am trying to compare the results of SAS PROC Mixed and JMP mixed model. I thought the results would be the same, but they are not. I hope JMP can give the same results of SAS PROC MIXED. Could anyone help me with it?My SAS code as following:PROC MIXED DATA = DATA;CLASS Sub Condition Stimuli;MODEL Y = Condition / SOLUTION;RANDOM Sub;RANDOM Stimuli(Condition);run;The results for the fixed...
laughtpp

Discussions |
Nov 3, 2016 8:59 AM

8145 views | 6 replies
How to Autorun the JMP Script every 1 hour.

I have jmp script. I would like it to run every 1 hours to see trends. Please let me know if it is possible.
ashishmehra870

Discussions |
Oct 13, 2016 7:07 PM

4493 views | 1 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

4868 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

3882 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

5149 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

3588 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

3570 views | 0 replies