This example uses the file Fill Weights.xlsx, which contains the weights of cereal boxes randomly sampled from three different production lines. Figure 5.87 shows the format of the data.
Figure 5.87 Data Format
Use the File > Open option to import data from a Microsoft Excel file using the Excel Import Wizard. See Import the Data Using the Excel Import Wizard. This method is convenient for any Excel file.
1.
Select Help > Sample Data Library and open Fill Weights.xlsx located in the Samples/Import Data folder.
2.
Type 3 next to Column headers start on on row.
3.
Type 2 for Number of rows with column headers.
4.
Click Import.
Figure 5.88 JMP Table Created Using Excel Import Wizard
1.
Open Fill Weights.xlsx in Microsoft Excel.
4.
In JMP, select File > New > Data Table.
5.
Select Edit > Paste with Column Names.
The Edit > Paste with Column Names option is used when you have column names included in the selection on the clipboard.
Figure 5.89 JMP Table Created Using Paste with Column Names
1.
3.
Select Multiple Series Stack.
4.
Deselect Stack By Row.
5.
Select Eliminate Missing Rows.
6.
Enter Stacked next to Output table name.
7.
In the new data table, Data and Data 2 are columns containing the ID and Weight data.
8.
Right-click the Label column heading and select Delete Columns.
The entries in the Label column were the column headings for the box IDs in the imported data table. These entries are not needed.
Data to ID
Label 2 to Line
Data 2 to Weight
Although ID is given as a number, it is an identifier and should be treated as nominal when modeling. This is not an issue in this example, but it is good practice to assign the appropriate modeling type to a column.
1.
Click the Line column header to select the column and select Cols > Recode.
2.
Change the values in the New Values column to match those in Figure 5.90 below.
Figure 5.90 Recode Column Values
3.
Click Done > In place.
Figure 5.91 Recoded Data Table
Label points by ID in case you want to reweigh or further examine their boxes.
1.
Select Analyze > Fit Y by X.
2.
Select Weight and click Y, Response.
3.
Select Line and click X, Factor.
4.
6.
From the red triangle menu, select Display Options > Box Plots.
8.
In the plot, hover over the points with your mouse to see their ID values, as well as their Line and Weight data. See Figure 5.92.
9.
From the red triangle menu, select Compare Means > All Pairs, Tukey HSD.
Figure 5.92 Oneway Analysis of Weight by Line

Help created on 7/12/2018