How is JMP Different from Excel?

JMP and Excel Differences
Formulas
Excel	Formulas are applied to individual cells.
JMP	Formulas are applied only to entire columns. Calculate Values with Formulas in Work with Your Data describes how to use formulas.
Column Names
Excel	Column names are part of the grid. Numbered rows and labeled columns extend past the data. Numeric and character data reside in the same column.
JMP	Column names are not part of the grid. There are no rows and columns beyond the existing data. The grid is only as big as the data. A column is either numeric or character. If a column contains both character and numeric data, the entire column’s data type is character, and the numbers are treated as character data.
	Understand Modeling Types in Analyze Your Data describes how data type influences platform results.
Tables and Worksheets
Excel	A single spreadsheet contains several tables, or worksheets.
JMP	JMP does not have the concept of worksheets. Each data table is a separate .jmp file and appears in a separate window.
Data Grid
Excel	Data can be located anywhere in the data grid.
JMP	Data always begins in row 1 and column 1.
Analysis and Graph Reports
Excel	All data, analyses, and graphs are placed inside the data grid.
JMP	Results appear in a separate window.