Index
Using JMP
Symbols
^. See insert button on keypad
!= (not equal to) function
413
*= (Multiply To) function
443
/= (Divide To) function
443
& (And) function and conditional clauses
417
< (less than) function
413
<= (less than or equal to) function
413
== (equal to) function
413
> (greater than) function
413
>= (greater than or equal to) function
413
Numerics
1, 2, and 4-byte integers
145
Add files opened by scripts to the Recent Files list 369
add ranges, missing values
153
Add SAS Stored Process 340
adding
graphics and graphics scripts
314
add-ins
Aggregate functions (SQL)
94
allowing short numeric formats
145,
375
Analyze
And (&) function and conditional clauses
417
annotations
setting the default font
386
apostrophes in imported data
58
Application
archive files in project
339
arguments
arithmetic buttons on keypad
213
arrange
Arrhenius Inv function
403
arrow
assignment table property
281
Auto-complete parentheses and braces, in script editor
390
automatic recalc option
268
Auto-save the report to
371
axis
copying and pasting settings
297
divider lines and frames
299
minimum and maximum values
293
specifications for columns
154
backwards compatibility
320,
368
backwards compatibility, tables
320
bars, histogram colors
290
Beta Binomial Distribution function
427
Beta Binomial Probability function
427
Beta Binomial Quantile function
427
Beta Density function
418
Beta Distribution function
418
Beta Quantile function
419
BETWEEN statement (SQL)
94
Binomial Distribution function
427
Binomial Probability function
427
Binomial Quantile function
427
Blink button in row editor
121
Blob to Char function
409
boxes around formulas
223
braces in script editor, auto-complete
390
buttons
Categorical Color Theme 374
Change Plot Scale option
252
Char to Blob function
409
Character Pattern functions
409–
412
save text as Unicode preference
368
select during text import
57
characteristics, rows and columns
131
ChiSquare Density function
419
ChiSquare Distribution function
419
ChiSquare Quantile function
419
circle with strikethrough icon
131
closing
closing JMP Starter window
24
coding, column property
156
Coefficient of Variation
241
Col N Missing function
429
Col Quantile function
429
Col Standardize function
430
colors
shapes added to reports
309–
311
columns
fonts used in headings
386
order of data in reports
157
preselected analysis roles
163
columnwise statistics functions
428
Combine States function
438,
440
communications settings
98,
387
Concat Items function
408
Continuous Color Theme 373
continuous modeling types
144
Continuous Scale command
288
Copy Formula button, using when
copy menu and toolbar items
355
copying
creating
menu items and buttons
350
source columns (when concatenating tables)
186
currency formats
customization sets
customizing
menus and toolbars (Windows)
345
toolbars and menus (Windows)
345
data filter
Data Table Clear Selection
139
data tables
elements of data tables
33
names and notes, placing on reports
370
Data Tables List toolbar
348
data types
date and time formats
146
data view
created from rows panel
38
Date Difference function
437
Date Increment function
437
dates and times
inserting on report window
370
decreasing font sizes
266
defaults
delete button, on formula editor keypad
213
deleting
deselecting parts of a report
265
Design of Experiments.
See DOE
156
Design, table variable
36,
123
Desirability function
432
desirability values, as column properties
158
diamond icon, on a report
265
discontiguous selection
106,
109
Discrete Probability functions
426–
428
distribution
setting column property to automatically fit curve
158
Divide To (/=) function
443
DOE (Design of Experiments)
Double Declining Balance function
444
dragging and dropping
drawing speed of markers
284
dropping
columns when splitting tables
178
columns when stacking tables
174
duplicates when joining tables
191
Dunnett P Value function
419
Dunnett Quantile function
419
duplicating cells and columns
118
editing
names of report tables
281
efficient evaluations
217
elements and element browser in formula
230
eliminating missing rows (when stacking tables)
174
Encapsulated PostScript File
325
End of Field and
End of Line options
57
EPS support in reports
325
equal to (==) function
413
errors, ignoring in formulas
220
evaluating columns’ formulas
viewing evaluations in formulas
220
when creating subsets
168
when splitting columns
179
when stacking columns
175
Excel
Excel files
Excel, selecting worksheets when opening
368
excluded rows, showing in a data view
38
excluding
columns when splitting tables
178
columns when stacking tables
174
duplicates when joining tables
191
rows and columns from analyses
131
exponent button on keypad
213
exporting
column names to text files
321
Extra space at bottom of document, in script editor
390
extracting data from image
306
F Distribution function
420
F Sample Size function
425
factor
for mixture experiments
156
factory defaults
min and max axis values
293
fast marker
field widths
files
saving without Unicode
320,
368
filling columns with data
150
Find/Length expression
405
finding and replacing values
115
fit
column property to draw automatically when analyzing distribution of column
158
fonts
changing in data tables
34
changing size in data tables
266
For quantile statistics option when summarizing tables
238
formula element browser
211
formulas
arguments, opening and closing
224
boxes, hiding and showing
223
data table elements, adding
208
opening and closing arguments
224
orientation in formula editor
223
frame sizes of plots or graphs
290
Full Quadratic Model function
444
function types
Post Decrement (--) and Increment (++)
443
functions
columnwise statistics
428
Future Value function
444
G
Gamma Density function
420
Gamma Distribution function
420
Gamma Poisson Distribution function
426
Gamma Poisson Probability function
426
Gamma Poisson Quantile function
426
Gamma Quantile function
421
global variables, storing a report table
281
GLog Density function
422
GLog Distribution function
423
GLog Quantile function
423
glossary of formula terms
229
Graph
Graph Background Color
374
Graph Builder preferences
378
graph marker theme, default
373
graphics
saving reports as graphics
329
graphics, dragging into graph
304
graphs
copying and pasting contents
297
greater than (>) function
413
greater than or equal to (>=) function
413
GROUP BY command (SQL)
95
grouping variables
using when sorting tables
172
using when splitting tables
177
using in formula editor
221
hard (factor changes), factor, hard or easy to change
158
Hex to Number function
407
hidden rows
showing in a data view
38
Hidden State function
438
hiding
thumbnails of reports
383
hierarchical data filter
277
Highlight Outline Headers option
383
histograms, bar colors
290
Home
horizontal
HTML
Hypergeometric Distribution function
427
Hypergeometric Probability function
428
icons
circle with strikethrough
131
column characteristics
37
ignoring
missing values (when updating tables)
199
images
importance values, entering
158
importing
text from the Script window
61
toolbar and menu customizations
359
Include marginal statistics option
237
Include missing for grouping columns option
253
Include Non Matches option
191
increasing font sizes
266
indent guides, showing in script editor
390
initial
insert button on keypad
213
instruments, connecting
98,
387
Interactions Model function
444
Interest Payment function
444
Interest Rate function
444
Internal Rate of Return function
444
international numeric formats
149
Internet
opening Internet files
61
Johnson Sb Density function
425
Johnson Sb Distribution function
425
Johnson Sb Quantile function
425
Johnson Sl Density function
425
Johnson Sl Distribution function
425
Johnson Sl Quantile function
425
Johnson Su Density function
424
Johnson Su Distribution function
424
Johnson Su Quantile function
424
joining
Joint Photographics Expert Group (JPEG, JPG)
325,
329
journals
JSL scripts
creating from a report
326
suppressing automatic execution
375
viewing in formula editor
220
keypad, formula editor
96
Labeled and Labeled State functions
439
Labeled State function
440
labelled rows
showing in a data view
38
labels
language preference, JMP indexes
369
LEV Distribution function
421
LEV Quantile function
421
limits, specification, control, response
157
line numbers, in script editor
390
Linear Model function
444
lines
lines, dotted or dashed reference lines
300
list checking
local variables
localizing toolbar and button captions
349
locking
columns, preventing from being moved
139
log
showing DisplayBox messages
369
Log window, saving reports to
371
Logistic Density function
421
Logistic Distribution function
421
Logistic Quantile function
421
Loglogistic Density function
421
Loglogistic Distribution function
421
Loglogistic Quantile function
421
Lognormal Density function
421
Lognormal Distribution function
422
Lognormal Quantile function
422
lower control limits (LCL) and spec limits
157
M
magnifying glass tool
290
Major Grid Line Color 374
Make Into Data Table option
253
Make into Matrix command
281
Make Window with Legend command
288
manipulating plots/graphs
289
maps
marker selection mode
373
Marker State function
441
markers
highlighting in plots
281
matching
cases while searching
116
columns when joining tables
195
whole words in search
116
matching columns (update)
199
matching specifications
189,
192
Max (summary statistics)
241
Mean (summary statistics)
241
measuring units, columns
158
Median (summary statistics)
241
menu items
menus
merging same name columns
190
Mersenne-Twister technique
432
Microsoft Word and PowerPoint
329
Min (summary statistics)
241
minimum and maximum axis values
293
Minor Grid Line Color 374
missing
values, updating tables
199
missing data patterns
114
missing value code, SPSS
63
modeling types
Modified Internal Rate of Return function
444
moving
selection in data table
376
Multiple Series Stack
174
Multiply To (*=) function
443
N
N and N Missing (summary statistics)
240–
241
naming
NChooseK Matrix function
402
Neg Binomial Distribution function
427
Neg Binomial Probability function
427
nesting boxes, formula editor
224
Net Present Value function
444
new
nominal
Non matches, include when joining tables
191
Normal Biv Distribution function
422
Normal Density function
422
Normal Distribution function
422
Normal Quantile function
422
not equal to (!=) function
413
notes
as table variables
36,
122
displaying in report windows
370
Number of Periods function
444
Number of Series option
174
numeric
allowing short numeric
375
international formats
149
ODBC drivers for importing data
53
Open All Below command
264
Open All Like This command
264
Open Database Connectivity
323
opening
JMP Starter window
24,
31
SAS stored process report as data table
63
operator names
script editor, adding spaces between words
390
operator tips, showing in script editor
390
operators
in assignment functions
443
Order by count of grouping columns option
253
ordering
ordinal modeling types
144
orientation of formulas
223
outlines
Output Table option
oval tool (simple shape tool)
309–
310
Parametric Model Functions
443–
444
parentheses
script editor, adding spaces inside
390
script editor, auto-complete
390
password protected data sets
80
Paste Special command
329
Pat Conditional function
412
Pat Immediate function
412
patterns of missing data
114
PDF file, headers and footers
334
peel (delete expression)
213
percent of total (summary statistics)
241
Personalization window
32
platforms
plots and graphs
appearances, altering
289
Poisson Distribution function
428
Poisson Probability function
428
Poisson Quantile function
428
Post Decrement (--) and Increment (++) functions
443
power. See Sample Size and Power
preselected analysis roles
163
Present Value function
445
presentations, journal
334
Preserve SAS variable names
322
previewing text on import
56
Principal Payment function
445
printing
projects
automatically open files
340
dragging and dropping files into
340
properties
quotation marks in imported data
58
R
Random Beta Binomial function
434
Random Binomial function
433
Random Cauchy function
433
Random Frechet function
434
Random Gamma function
432
Random Gamma Poisson function
434
Random Geometric function
434
Random Integer function
433
Random Johnson Sb function
433
Random Johnson Sl function
433
Random Johnson Su function
433
Random Logistic function
434
Random Loglogistic function
434
Random Lognormal function
434
Random Negative Binomial function
433
Random Normal function
432
Random Poisson function
434
Random Reset function
435
random sample (subset)
168
Random Triangular function
433
Random Uniform function
432
Random Weibull function
434
range comparison function
413
ranges, summary statistics
241
rearrange open windows
30
rearranging
rectangle tool (simple shape tool)
309
reference lines, adding
300
renaming
reordering
replacing
tables (when sorting)
172
values in a data table
115
Report Invalid Display Box Messages 369
report windows
dates and times, adding
370
Resample Freq function
435
resizing plots/graphs
289
restricting search to selected rows or columns
116
Reverse Into function
408
reverting columns to original order
118
roles
preselected analysis roles
163
root button on keypad
213
row
row selection, direction of movement when pressing Enter/Return
376
row state
row states
coloring rows by column values
134
rows
order of data in reports
157
sorting in data tables
170
creating a data view of selected rows
38
RTF (Rich Text Format) files
326
S
sample size, in tabulate
253
SAS
creating transport files
68
importing password-protected data sets
80
variable names in imported data
66
SAS metadata server
SAS metadata server, automatically connect
392
Save and Save As menu items
319
Save Journals GZ Compressed
369
Save the session when exiting command
372
saving
results to a database
323
spec, control, and response limits
157
saving and evaluating formulas (when concatenating tables)
186
saving without Unicode
320
Scalable Vector Graphic format
329
scaling
Scheffe Cubic function
403
Script All By-Groups menu
268
script editor
auto-complete parentheses and braces
390
extra space at bottom of document
390
indent guides, showing
390
line numbers, showing
390
operator tips, showing
390
spaces in operator names
390
spaces inside parentheses
390
variable value tips, showing
390
scripts
running when a data table is opened
125
scrolling
Select Individual Excel Worksheets command
368
SELECT statement (SQL)
92
selected rows
showing in a data view
38
Selected State function
439,
441
selecting
columns
irregular area of points
283
rectangular area of points
282
rows and columns in data tables
42–
108
rows and columns in plots
282
selection (large plus) cursor
42
sequence data, adding
150
setting
markers according to point values
288
SEV Distribution function
423
SEV Quantile function
423
short, allowing short numeric
145,
375
Show Control Panel option
253
Show indent guides, in script editor
390
Show line numbers, in script editor
390
Show operator tips, in script editor
390
Show Test Build Panel option
253
Show variable value tips, in script editor
390
showing
boxes around formulas
224
Sigma, assigning values
158
simple shape tool (oval or rectangle)
309
Sorting
results by fields in a database (SQL)
93
sorting
Spaces in operator names, in script editor
390
Spaces inside parentheses, in script editor
390
specifying columns when importing text files
58
SQL WHERE clause editor
96
Standard Deviation function
430
Std Dev and Std Err (summary statistics)
241
stored process, copy metadata path
81
Straight Line Depreciation function
445
stripping enclosing quotes on imported data
58
subgroups, summary statistics
238
subsetting
Substitute Into function
408
Subtract To (-=) function
443
Sum Of Years Digits Depreciation function
445
Sum Wgt (summary statistics)
241
summary table, creating
235
supported version of SAS metadata server
68
suppressing formula evaluation
when creating a subset
168
when creating formulas
219
when splitting columns
179
when stacking columns
175
switch terms button on keypad
213
system tables (ORACLE)
90
t Distribution function
423
Tab width, in script editor
390
table properties
table variables
tables
tabs
terms, switching in a formula
213
text
opening add-ins as text
59
TIck marks inside graph frame 374
time, adding to reports
370
Tip of the Day window
toolbars
personalizing (Macintosh)
360–
361
toolbars and menus
personalizing (Windows)
345–
360
Transcendental functions
401–
403
transparency, markers
286
transport files, creating
68
transposing rows and columns
181
treat empty columns as numeric
380
trigonometric function types
403
Tukey HSD P Quantile function
425
Tukey HSD Quantile function
425
two-digit year rule, importing data
58
two-way table of summary statistics
238
U
unary sign function button on keypad
213
save text files preference
368
Uniform plot scale option
253
univariate statistics
236
update
upper control limits (UCL)
157
Use tabs, in script editor
389
User Tables, database connections
90
value ordering
values
high and low for columns (in DOE)
156
variable labels, importing
392
variable value tooltips, showing in script editor
390
variables
Variance (summary statistics)
241
vertical, formula display
223
viewing
subset of rows in a data view
38
W-Z
Week of Year function
436
Weibull Density function
424
Weibull Distribution function
424
Weibull Quantile function
424
weight, preselected roles
163
widths
worksheets, selecting
368