Summarizing Data Using Tabulate
The Tabulate platform provides a tool to interactively construct tables of descriptive statistics.
Drag and Drop to Summarize Data
- From an open JMP® data table select Analyze > Tabulate.
- Drag and drop variables from the column list to the drop zone for rows and columns.
- Country (below, left) is in the rows drop zone – the number of observations per country is displayed.
- Horsepower (middle) is in the columns drop zone as an analysis column – the sum for horsepower is displayed for each country.
- Drag and drop one or more summary statistics from the middle panel into the results area. Mean and Std Dev are displayed for each country (below, right).
Tips:
- Click Undo to reverse the last change, or use Start Over to clear the display.
- Click and drag variables in the table to rearrange, or right-click on a variable to delete or change the format.
- To change the numeric formats (i.e., decimal places), use Change Format at the bottom of the window and select the desired format.
- To add new summary panels to the table, drag and drop the new variable to the bottom or left of the table. Here, Type has been added to the bottom of the original table.
- To add additional row or column variables, drag and drop a new variable on either side of the current variable in the table. Here, Type has been added next to Country and Horsepower has been added next to Weight.
- To create a data table, click Done, then select Make Into Data Table from the top red triangle.
Visit Basic Analysis > Tabulate in JMP Help to learn more.