1.
Open a new script window (File > New > Script).
2.
In your script window, enter the Open() expression to open the Solubil.xls sample import data file. The file is located in JMP’s Samples/Import Data folder.
dt = Open( "$SAMPLE_IMPORT_DATA/Solubil.xls" );
Notes: 
You can also include the Excel Wizard argument in the Open() expression to preview the worksheet before importing it. See Import Data from a Microsoft Excel File in Data Tables for details.
1.
2.
Select all the columns except Labels and click Y, Columns.
3.
4.
Hold down CTRL and select Histogram Options > Show Counts from the red triangle menu for eth.
5.
In the Distribution window, select Save Script > To Clipboard from the red triangle menu next to Distributions.
6.
8.
Select Graph > Scatterplot 3D.
9.
Select all the columns except Labels and click Y, Columns.
10.
12.
Select Analyze > Multivariate Methods > Multivariate.
13.
Select all the columns except Labels and click Y, Columns.
14.
dt = Open( "$SAMPLE_IMPORT_DATA/Solubil.xls" );
Distribution(
	Continuous Distribution( Column( :eth ), Show Counts( 1 ) ),
	Continuous Distribution( Column( :oct ), Show Counts( 1 ) ),
	Continuous Distribution( Column( :cc14 ), Show Counts( 1 ) ),
	Continuous Distribution( Column( :c6c6 ), Show Counts( 1 ) ),
	Continuous Distribution( Column( :hex ), Show Counts( 1 ) ),
	Continuous Distribution( Column( :chc13 ), Show Counts( 1 ) ),
);
Scatterplot 3D(
		Y( :eth, :oct, :cc14, :c6c6, :hex, :chc13 ),
		Frame3D( Set Grab Handles( 0 ), Set Rotation( -54, 0, 38) )
);
Multivariate(
	Y( :eth, :oct, :cc14, :c6c6, :hex, :chc13 ),
	Estimation Method( "Row-wise" ),
	Scatterplot Matrix(
		Density Ellipses( 1 ),
		Shaded Ellipses( 0 ),
		Ellipse Color( 3 )
	)
);
3.
Click Save.
2.
Select Edit > Run Script.
//!
1.
Select File > Open.

Help created on 7/12/2018