nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I compute correlations: Not quadratic (ABCXYZ by ABCXYZ), but rectangular (ABC by XYZ) (scripting, JSL)

Newbie2Jumpie

Hi,

This time I may have a simple question. I just cannot find anything fitting.

I simply would like to compute correlations. Not “quadratic”, for example coefficients of columns ABCXYZ by ABCXYZ, but “rectangular”, for example coefficients of columns ABC by columns XYZ. Any ideas how I could accomplish that with JMP?

Nothing fancy...

Cheers!
Newbie2Jumpie

Accepted answers

All comments

Mark_Bailey

I have no idea what you mean by "not quadratic" or "rectangular" but you might check out the Multivariate platform or the Correlation() JSL function. Your choice might depend on where the data is stored (data table or matrix object).

Newbie2Jumpie

I just would like to restrict the computations down to two groups of columns (A-F) by (X-Z):

"quadratic"

A B C D E F X Y Z

A ccAA...

E 81 correlation coefficients

Z ccZZ

"rectangular"

X Y Z

A ccAX ...

C 18 correlation coefficients

F ...ccFZ

txnelson

Here is a simple script that will produce what you want:

Names Default To Here( 1 );
dt = Open( "$SAMPLE_DATA/semiconductor capability.jmp" );

xList = {"NPN1", "PNP1", "PNP2"};
yList = {"NPN2", "PNP3"};

nw = New Window( "Correlations",
	Outline Box( "Retangle of Correlations", tb = Table Box() )
);

// Add the Row Labels to the Table Box

tb << append( String Col Box( " ", yList ) );
For( x = 1, x <= N Items( xList ), x++,
	xyCorrList = {};
	For( y = 1, y <= N Items( yList ), y++,
		Insert Into(
			xyCorrList,
			Correlation(
				Column( dt, xList[x] ) << get as matrix || (Column( dt, yList[y] ) <<
				get as matrix)
			)[1, 2]
		)
	);
	tb << append( Number Col Box( xList[x], xyCorrList ) );
);

Newbie2Jumpie

Hi Tx,

The "textbox" is an interesting, though completely approach to me.

How would I adjust this code to get these coefficients in a JMP table?

JMP, at least v14.0, does not like to do this using "textbox".

Kind regards

Newbie

jules

Hi @Newbie2Jumpie,

Looks like you already have a scripting solution from Jim, but I have an Add-in out there that I think does what you want: return a table of correlations between a set of particular Xs and particular Ys rather than all possible combinations (as you would get in Multivariate).

Correlate Y by X Add-In

Hope that helps,

@jules

ron_horne

Hi @Newbie2Jumpie

the others gave you a direct answer to your question. let me offer another solution which i think JMP is really good for.

why not try Pairwise correlations under the red triangle (or in preferences). this table can be exported to a data table and then filtered as you like. i find this much more useful than the big correlation matrices where all the numbers appear twice.