For the latest version of JMP Help, visit JMP.com/help.


Publication date: 11/29/2021

Enter Data in a Data Table

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

Table 3.1 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.

Table 3.1 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

Enter 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.

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

Figure 3.3 Entering a Column Name 

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 clicking in a cell and typing.

Figure 3.4 Month Column Completed 

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 Figure 3.3 and for Month in Figure 3.4. This difference is important and is discussed in View or Change Column Information in a Data Table.

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 Table 3.1. Your data table now consists of six rows and two columns.

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

Change the Data Table Name

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

2. Type the new name (Blood Pressure).

Figure 3.5 Changing the Data Table Name 

Changing the Data Table Name

Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).