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" );
3.
|
Run your script to import the Microsoft Excel file by selecting Edit > Run Script.
|
•
|
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.
|
With your new data table open, select Analyze > Distribution.
|
2.
|
3.
|
Click OK.
|
4.
|
5.
|
In the Distribution window, select Save Script > To Clipboard from the red triangle menu next to Distributions.
|
6.
|
Place your cursor in the script window a line or two after your Open() expression and select Edit > Paste.
|
8.
|
Select Graph > Scatterplot 3D.
|
9.
|
10.
|
Click OK.
|
12.
|
Select Analyze > Multivariate Methods > Multivariate.
|
13.
|
14.
|
Click OK.
|
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 )
)
);
1.
|
2.
|
Specify a filename (for example, Weekly Report).
|
3.
|
Click Save.
|
2.
|
Select Edit > Run Script.
|
//!
1.
|
Select File > Open.
|