JMP User Community

Latest Discussions

Moving Average with Missing Data

I'm trying to calculate a moving average of some data that has some holes in it. I can't seem to figure out how to caculate a moving average that only includes non missing data and that only calculates the result for rows with non missing data. Any suggestions would be appreciated. New Table( "Untitled 5", Add Rows( 30 ), Compress File When Saved( 1 ), New Table Variable( "Moving Avg Window...
terapin

Discussions |
Dec 2, 2016 2:41 AM

18001 views | 6 replies
How do I select rows between date ranges

Hello All, I am trying to figure out how to select rows specific to a range of dates using data from a column by last date. Is there a way to do this in a for loop?
steven_w_daniel

Discussions |
Dec 1, 2016 10:09 PM

19291 views | 8 replies
Create horizontal border to separate y-grouped plots

Hi, I want to create a horizontal border to seperate my y-grouped plots. I have attached a screen shot show with black crosses where I want to create the border.
tobben24

Discussions |
Dec 1, 2016 11:44 AM

4595 views | 2 replies
How do I Enable Interaction Plots?

I am trying to run interactions on my DOE and the option to do this under the Response > Factor Profiling is grayed out and I cannot select. I changed default to "Supress Cotter Designs" and still no luck. It does not even work on the "Reactors" example that JMP provides in the Help library for the specific reason of showing how to do Interaction plots. Any suggestions?
AE9999

Discussions |
Dec 1, 2016 11:24 AM

20007 views | 17 replies
How to manually install Excel add-in for JMP version 13

Dears, Would you inform us on how to proceed on manual installations of Excel® add-in for the JMP13. Recently, my company did the JMP upgrade on our computers, but the technician did not tick this option during the installation. Is there any way to perform it post-installation, similarly to your previous versions? Thanks & regards,D.
Tay

Discussions |
Dec 1, 2016 3:20 AM

12522 views | 1 replies

Previous
Next

Latest Discussions

Create horizontal border to separate y-grouped plots

Hi, I want to create a horizontal border to seperate my y-grouped plots. I have attached a screen shot show with black crosses where I want to create the border.
tobben24

Discussions |
Dec 1, 2016 11:44 AM

4595 views | 2 replies
Script formatting for Variability Charts

Hello, I am trying to script a series of Variability Charts in a single Window, which I could save to a JRN or pptx later. Each chart is intended to display the values (in Y) of different parameters (e.g. Height, Weight, Length) with different combination of independent X axis {due to this reason, I could not script it as By( :Parameter_Class ) } in a single Variability Chart platform. Probl...
ylee

Discussions |
Nov 30, 2016 5:46 PM

7578 views | 2 replies
Can someone help me with PC settings to improve analysis speed?

Dear friends,I have Intel Xeon Processor E5-1650 v3 (15M Cache, 3.50 GHz, 6cores) with windows 7.My system stop responding sometimes. For instance, I have just 12000 data points each with 95 columns. When I do a fit model with full factorial using just 20input variables, system stops responding. Also when I use multivariate analysis, parallel plots etc with the same data it is extremely slow. But ...
sanqub

Discussions |
Nov 29, 2016 8:48 AM

8015 views | 4 replies
Why there is a constant component in the PCA formula

I have been surprised to see a constant component in the saved formula when performing PCA analysis. For example, saving the 1st 2 Principal Components on the following standardized data set (centered and scaled data), Standardized (Centered + Scaled) DataSLengthSWidthPLengthPWidth0.270.19-0.36-0.44-0.30-1.14-0.36-0.44-0.88-0.61-0.94-0.44-1.16-0.870.22-0.44-0.020.46-0.36-0.441.131.261.381.48-1.16...
ILoveJMP

Discussions |
Nov 28, 2016 1:24 PM

5813 views | 3 replies
Removing values from a column

Hi All, I would like to remove values from a column. Normally, I would use a range check column property to do this, but with this particular column, it is also dependendent on another column's value. Is there an easy way to do this? I tried the code below, but unfortunately it makes the entire column blank except for the first row. I thought this might work because the "." represents missing v...
natalie_

Discussions |
Nov 25, 2016 1:16 PM

4262 views | 3 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

5188 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

3616 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