JMP User Community

Latest Discussions

JSL: Select Where with variable for column name

Hi I'm trying to use select where to count the number of rows which meet criteria in 2 columns using a for loop. In the beginning of my script (not shown) I use a dialog to let the user choose 2 columns and this ends up in a list (collist). I then use an associative array on each to determine the unique values per column. A second dialog allows the user to choose a subset of those unique values pe...
elizperez

Discussions |
Aug 29, 2016 3:56 PM

12317 views | 2 replies
PCA estimation method for missing values (log transformed)

Hi there,I am a beginner in statistics and also with JMP, so I hope someone can help me with my question below. I am trying to use JMPs PCA co-variance module on a relatively small environmental data set of 80 rows x 10 columns (800 values). My goal is to reduce the data set so I can predict whether the 10 variables (in the columns) co-vary across 80 locations (80 rows). The variables have all the...
schmops

Discussions |
Aug 29, 2016 1:04 PM

5653 views | 6 replies
Computing CPK for bimodal data, either large readings or zero (majority)..

Hi,I have data points from measurements of a certain defect. The readings are either zero(majority) or high readings.For example: How do i get the CPK if the USL is 100? Desirable is the zero reading.60.176.87668.343.960.342.866.149.462.149.866.561.258.859.160.367.268.554.661.064.257.700000000000000000000000000000000000000
jabenir

Discussions |
Aug 29, 2016 10:45 AM

5954 views | 2 replies
Joining / Concatenate table but just include new data

Hi all,I have scheduled a JMP script to give me a daily data table each day.What is the best way to Concatenate these tables, but I only want to add new data and not have multiples.Example Table 1 (Day 1) and then table 7 (Day 7), how do you concatente these tables to have Table 1 and all new data in Table7 included, but not multiples. Note, Column names will be the same in each table.
ivan_j_moore

Discussions |
Aug 29, 2016 8:53 AM

8816 views | 5 replies
Setting values to a cell

Hello all,It's been some time since I did any programming in JSL, so I'll be asking some basics questions which I did not find in the manuals.1. How, using a JSL, I can set a specific value to a specific Col/Row?2. I need to do that in a For loop. Let's say I need to run a loop from 1 to number of rows, and assign (for now) the same number to each Row of a Specific column. How do I do that this wa...
miguello

Discussions |
Aug 29, 2016 7:04 AM

13557 views | 2 replies

Previous
Next

Latest Discussions

PCA estimation method for missing values (log transformed)

Hi there,I am a beginner in statistics and also with JMP, so I hope someone can help me with my question below. I am trying to use JMPs PCA co-variance module on a relatively small environmental data set of 80 rows x 10 columns (800 values). My goal is to reduce the data set so I can predict whether the 10 variables (in the columns) co-vary across 80 locations (80 rows). The variables have all the...
schmops

Discussions |
Aug 29, 2016 1:04 PM

5653 views | 6 replies
Computing CPK for bimodal data, either large readings or zero (majority)..

Hi,I have data points from measurements of a certain defect. The readings are either zero(majority) or high readings.For example: How do i get the CPK if the USL is 100? Desirable is the zero reading.60.176.87668.343.960.342.866.149.462.149.866.561.258.859.160.367.268.554.661.064.257.700000000000000000000000000000000000000
jabenir

Discussions |
Aug 29, 2016 10:45 AM

5954 views | 2 replies
Joining / Concatenate table but just include new data

Hi all,I have scheduled a JMP script to give me a daily data table each day.What is the best way to Concatenate these tables, but I only want to add new data and not have multiples.Example Table 1 (Day 1) and then table 7 (Day 7), how do you concatente these tables to have Table 1 and all new data in Table7 included, but not multiples. Note, Column names will be the same in each table.
ivan_j_moore

Discussions |
Aug 29, 2016 8:53 AM

8816 views | 5 replies
Cycle detected for data column

Hello, AllI am making a model that requires some "loop feedback", and it is giving me this error:Do you know how to get around it?I do not have this problem in Excel using the same formulaeThank you,-JoseUPDATE:I was able to make it run, but it will only execute the formula on one row at the time.I am attaching the table script for reference.You will see that two columns are dependent from each ot...
gutloja

Discussions |
Aug 28, 2016 10:56 AM

7553 views | 4 replies
control chart with multiple items how to save summaries in one table

I have a control chart (cc) window with multiple items (i.e. each item has a control chart). In jsl, when I use cc<< Save Summaries, it pops up a summary table for each item. How can I save all summaries in one table with item name identified? Thank you.
qy6b0

Discussions |
Aug 25, 2016 5:29 PM

8224 views | 5 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

4892 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

3916 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

5197 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

3625 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

3595 views | 0 replies