Getting Your Data into JMP

•	To copy and paste data from another application, see Copying and Pasting Data.

•	To import data from another application, see Importing Data.

•	To enter data directly into a data table, see Entering Data

•	To open a data table, double-click on the file, or use the File > Open command.

You can also import data into JMP from a database. For more information, see Using JMP.

This chapter uses sample data tables and sample import data that is installed with JMP. To find these files, see Using Sample Data in Introducing JMP.

Copying and Pasting Data

You can move data into JMP by copying and pasting from another application, such as Excel or a text file.

Example: Copying and Pasting Data

1.	Open the VA Lung Cancer.xls file in Excel. This file is located in the Sample Import Data folder.

2.	Select all of the rows and columns, including the column names. There are 12 columns and 138 rows.

3.	Copy the selected data.

4.	In JMP, select File > New > Data Table to create an empty table.

5.	Select Edit > Paste with Column Names to paste the data and column headings.

If the data that you are pasting into JMP does not have column names, then you can use Edit > Paste.

Importing Data

You can move data into JMP by importing data from another application, such as Excel, SAS, or text files. The basic steps to import data are as follows:

1.	Select File > Open.

2.	Navigate to your file’s location.

3.	If your file is not listed in the Open Data File window, select the correct file type from the Files of type menu.

4.	Click Open.

Example: Importing a Microsoft Excel File

1.	Select File > Open.

2.	Navigate to the Samples/Import Data folder.

3.	Select Team Results.xls.

Note the rows and columns on which the data begin. The spreadsheet also contains two worksheets. In this example, you import the Ungrouped Team Results worksheet.

4.	Click Open.

The spreadsheet opens in the Excel Import Wizard, where a preview of the data appears along with import options.

Text from the first row of the spreadsheet are column headings. However, you want text in row 3 of the spreadsheet to be converted to column headings.

5.	Next to Column headers start on row, type 3, and press Enter. The column headings are updated in the data preview. The value for the first row of data is updated to 4.

6.	Save the settings only for this worksheet:

‒	Deselect Use for all worksheets in the lower left corner of the window.

‒	Select Ungrouped Team Results in the upper right corner of the window.

7.	Click Import to convert the spreadsheet as you specified.

When you import Excel files, JMP predicts whether columns headings exist, and if the column names are on row one. The copy and paste method is recommended for the following situations:

•	If the column names are located in a row other than row one

•	If the file does not include column names and the data does not start in row one

•	If the file contains column names and the data does not start in row two

See Copying and Pasting Data and Using JMP for more information about importing Excel files.

Example: Importing a Text File

One way to import a text file is to let JMP assume the data’s format and place the data in a data table. This method uses settings that you can specify in Preferences. See Using JMP for information about setting text import preferences.

Another way to import a text file is to use a Text Preview window to see what your data table will look like after importing, and make adjustments. The following example shows you how to use Text Import Preview window.

1.	Select File > Open.

2.	Navigate to the Samples/Import Data folder.

3.	Select Animals_line3.txt.

4.	At the bottom of the Open window, select Data with Preview.

5.	Click Open.

Initial Preview Window

This text file has a title on the first line, column names on the third line, and the data starts on line four. If you opened this directly in JMP, the Animals Data line would be the first column name, and all the column names and data afterward would be out of sync. The Preview window lets you adjust the settings before you open the file, and see how your adjustments affect the final data table.

6.	Enter 3 in the File contains column names on line field.

7.	Enter 4 in the Data starts on line field.

8.	Click Next.

In the second window, you can exclude columns from the import and change the data modeling of the columns. For this example, use the default settings.

9.	Click Import.

The new data table has columns named species, subject, miles, and season. The species and season columns are character data. The subject and miles columns are continuous numeric data.

Transfer Data from Excel

You can use the JMP Add In for Excel to transfer a spreadsheet from Excel to JMP:

•	a data table

•	Graph Builder

•	Distribution platform

•	Fit Y by X platform

•	Fit Model platform

•	Time Series platform

•	Control Chart platform

Set JMP Add In Preferences in Excel

To configure JMP Add In Preferences:

1.	In Excel, select JMP > Preferences.

The JMP Preferences window appears.

JMP Add In Preferences

2.	Accept the default Data Table Name (File name_Worksheet name) or type a name.

3.	Select to Use the first rows as column names if the first row in the worksheet contains column headers.

4.	If you selected to use the first rows a column headers, type the number of rows used.

5.	Select to Transfer Hidden Rows if the worksheet contains hidden rows to be included in the JMP data table.

6.	Select to Transfer Hidden Column if the worksheet contains hidden columns to be included in the JMP data table.

7.	Click OK to save your preferences.

Transfer to JMP

To transfer an Excel worksheet to JMP:

1.	Open the Excel file.

2.	Select the worksheet to transfer.

3.	Select JMP and then select the JMP destination:

‒	Data Table

‒	Graph Builder

‒	Distribution platform

‒	Fit Y by X platform

‒	Fit Model platform

‒	Time Series platform

‒	Control Chart platform

The Excel worksheet is opened as a data table in JMP and the selected platform’s launch window appears.

Entering Data

You can enter data directly in a data table. The following example shows you how to enter data that was collected over several months into a data table.

Scenario

Blood Pressure Data shows the data from a study that investigated a new blood pressure medication. Each individual’s blood pressure was measured over a six-month period. Two doses (300mg and 450mg) of the medication were used, along with a control and placebo group. The data shows the average blood pressure for each group.

Blood Pressure Data
Month	Control	Placebo	300mg	450mg
March	165	163	166	168
April	162	159	165	163
May	164	158	161	153
June	162	161	158	151
July	166	158	160	148
August	163	158	157	150

Entering Data in a New Data Table

1.	Select File > New > Data Table to create an empty data table.

A new data table has one column and no rows.

2.	Select the column name and change the name to Month. See Entering a Column Name

Note: To rename a column, you can also double-click the column name or select the column and press Enter.

Entering a Column Name

3.	Select Rows > Add Rows.

The Add Rows window appears.

4.	Since you want to add six rows, type 6.

5.	Click OK. Six empty rows are added to the data table.

6.	Enter the Month information by double-clicking in a cell and typing.

Month Column Completed

In the columns panel, look at the modeling type icon to the left of the column name. It has changed to reflect that Month is now nominal (previously it was continuous). Compare the modeling type shown for Column 1 in Entering a Column Name and for Month in Month Column Completed. This difference is important and is discussed in Viewing or Changing Column Information.

7.	Double-click in the space on the right side of the Month column to add the Control column.

8.	Change the name to Control.

9.	Enter the Control data as shown in Blood Pressure Data. Your data table now consists of six rows and two columns.

10.	Continue adding columns and entering data as shown in Blood Pressure Data to create the final data table with six rows and five columns.

Changing the Data Table Name

1.	Double-click on the data table name (Untitled) in the Table Panel.

2.	Type the new name (Blood Pressure).

Changing the Data Table Name