JMP 8 User Guide, Second Edition

Preliminaries......Page 20
Searching in Help......Page 22
Learning About Statistical and JSL Terms......Page 23
Using the Context-Sensitive Help......Page 24
Using This Book in Combination with Other Included Books......Page 25
Creating and Opening Files......Page 26
The Tip of the Day Window......Page 28
Creating New Data Tables......Page 29
Opening Existing JMP Files......Page 30
Opening Text Files......Page 32
Understanding the Text Import Preview Window......Page 34
Opening a Text File in a Text Editing Window......Page 38
Importing Text as Data......Page 40
Opening Excel and OpenOffice Files......Page 41
Opening SAS Data Sets......Page 42
Creating SAS Transport Files in SAS......Page 44
Opening Data from a Database......Page 45
Retrieving Data Using SQL Statements......Page 48
Using the SELECT Statement......Page 49
Using the WHERE Statement......Page 50
Using Aggregate Functions......Page 51
Using the WHERE Clause Editor......Page 52
Reading in Real-Time Data (Windows and Linux Only)......Page 54
Opening a File from the Internet or an Intranet......Page 55
Opening a File from a Server or Another Computer (Windows Only)......Page 56
Creating Journals......Page 57
Example: Making a Journal for a Presentation......Page 59
Encrypting and Decrypting Scripts......Page 63
Entering, Editing, and Managing Data......Page 66
The Data Table Panels......Page 68
The Table Panel......Page 69
The Columns Panel......Page 72
The Rows Panel......Page 73
The Data Grid......Page 75
Cursor Forms......Page 76
About Data Types......Page 77
How to Assign Data and Modeling Types......Page 78
Choosing Numeric Formats......Page 80
Numeric Format Options......Page 82
Adding and Deleting Rows......Page 85
Adding and Deleting Columns......Page 86
Setting Up Initial Data Values......Page 88
Filling Columns with Sequential Data......Page 89
Entering Cell Formulas......Page 90
Recoding Data......Page 91
Viewing Patterns of Missing Data......Page 92
Finding and Replacing Cell Values......Page 93
Reordering Columns......Page 96
Rows and Columns Context Menus......Page 97
Copying, Cutting, and Pasting......Page 98
Moving and Duplicating Values......Page 99
Using the Row Editor......Page 100
Locking Tables......Page 102
Adding Table Variables......Page 103
Adding New Table Variables......Page 104
Example of Using a Table Variable......Page 105
Adding Scripts to Data Tables......Page 106
Adding Scripts without Typing JSL Code......Page 107
Editing Script Names......Page 108
Selecting Rows and Columns......Page 109
Selecting Excluded, Hidden, or Labeled Rows......Page 110
Selecting Cells That Match the Currently Highlighted One......Page 111
Selecting Cells That Contain Specific Values......Page 112
Selecting a Particular Row or Column......Page 113
Randomly Selecting Rows......Page 114
Locating Next and Previously Selected Rows......Page 115
Data Filter Control Panel......Page 116
Adding Additional Groups of Variables to the Control Panel......Page 118
Using Nominal or Ordinal Variables as Filter Columns......Page 119
Selecting Continuous Values as Filters......Page 121
Animation......Page 122
Save WHERE Clause......Page 124
Saving Tables, Reports, and Sessions......Page 126
Saving .jmp Files for use in JMP 5.1.2 or Earlier......Page 128
Saving as a Text File......Page 129
Using Macintosh......Page 130
Using Windows......Page 131
Saving Data Tables to a Database......Page 132
Saving Reports......Page 133
Using Windows or Linux......Page 135
Appending Reports to a Journal......Page 136
Saving Using the Layout Command......Page 137
Saving Parts of a Report in a Graphic Format......Page 140
Saving Sessions Upon Exiting......Page 141
Saving Sessions Manually......Page 142
Creating a JMP Project......Page 143
Saving and Closing a JMP Project......Page 144
Using the Project Menu......Page 145
Notes......Page 146
Specifying Where to Save Files (Windows Only)......Page 147
Properties and Characteristics of Data......Page 148
Excluding Rows and Columns......Page 150
Hiding Rows and Columns......Page 151
Labeling Rows and Columns......Page 152
Giving Rows a Color......Page 153
Assigning Colors or Markers to Rows According to Column Values......Page 154
Deleting All Row Characteristics......Page 156
Giving Columns a Preselected Analysis Role......Page 157
Icon Indicators......Page 158
Assigning Properties to Columns......Page 159
Assigning Currency Formats......Page 160
Giving Columns a Formula to Compute Values......Page 161
Adding Notes to Columns......Page 162
List Checking......Page 163
Range Checking......Page 165
Using Value Labels......Page 166
Ordering Values in Columns......Page 168
Assigning Value Color Ranges......Page 170
Changing Columns’ Default Axis Settings......Page 171
Defining Low and High Values (DOE Coding) for Columns......Page 172
Setting Columns as Factors for Mixture Experiments......Page 173
Specifying How Rows Appear in Analysis Reports......Page 174
Entering Specification, Control, and Response Limits......Page 175
Identifying Factor Changes......Page 177
Assigning Sigma Values to Columns......Page 178
Specifying Columns’ Measuring Units......Page 179
Selecting a Distribution Type for the Column......Page 180
Assigning a Time Frequency to Data......Page 181
Removing Properties......Page 182
Adding Attributes and Properties......Page 183
Using Row State Columns......Page 184
Permanently Highlighting Cells......Page 186
Output Reports......Page 188
Accessing General Report Formatting Options......Page 190
Showing and Hiding Parts of a Report......Page 192
Renaming a Report......Page 193
Editing Data Table Rows using the Row Editor......Page 194
Understanding the p-value Indicator......Page 195
Pasting Reports into Another Program......Page 196
How to Access Analysis Options......Page 197
Saving Your Steps as a Script......Page 198
Reordering Rows (Sorting)......Page 199
Adding Outlines and Borders......Page 200
Changing Numeric Formats and Field Widths......Page 201
Turning a Report Table Into a Data Table......Page 202
Turning a Report Table Into a Matrix......Page 203
Selecting a Rectangular Area of Points......Page 204
Selecting an Irregular-Shaped Area of Points......Page 205
Changing Marker Shape......Page 206
Changing Marker Size......Page 207
Changing the Marker Drawing Mode and Transparency......Page 208
Specifying Marker Transparency......Page 209
Excluding and Hiding Markers......Page 210
Adding Labels to Markers......Page 211
Changing Marker Shape or Colors Based On Values......Page 212
Using Click and Drag......Page 214
Zooming In and Out......Page 215
Changing Line Widths......Page 216
Changing the Background or Histogram Bar Color......Page 217
Scrolling and Scaling Axes......Page 218
Changing the Axis Scale Type......Page 219
Changing the Numeric Format of an Axis......Page 220
Changing the Axis Increments......Page 221
Changing Axis Label Font......Page 222
Copying and Pasting Graph Contents......Page 223
Customizing Tick Marks and Tick Mark Labels......Page 224
Adding Tick Marks and Gridlines......Page 225
Adjusting the Field Width of Labels......Page 226
Rotating Tick Mark Labels......Page 227
Extending Divider Lines and Frames......Page 228
Adding Reference Lines......Page 229
Adding an Annotative Note......Page 230
Adding a Line......Page 232
Adding a Polygon or Spline......Page 233
Adding an Oval or Rectangle......Page 234
Options......Page 235
Customize Graph Menus......Page 237
Copying......Page 239
Reshaping Data......Page 240
Creating a Subset Data Table......Page 242
Stratified Subsets......Page 243
Sorting Data Tables......Page 244
Stacking Columns......Page 246
Example of Stacking into One Column......Page 248
Example of Stacking Into More Than One Column (Using the Multiple Series Stack Option)......Page 249
Example of Contiguous Stacking......Page 250
Splitting Columns......Page 251
Splitting a Column: Basic Example......Page 252
Splitting a Column: Grouping Rows Example......Page 255
Transposing Rows and Columns......Page 256
Examples of Transposing......Page 258
Concatenating Data Tables......Page 260
Example of Concatenating Data Tables......Page 262
How to Join Data Tables......Page 263
Examples of Joining Data Tables......Page 265
Example 1: Join by Row Number......Page 266
Example 2: A Cartesian Join......Page 269
Example 3: Join by Matching Columns......Page 270
Updating a Data Table......Page 275
Example of Updating a Data Table......Page 276
Summarizing Data......Page 280
Summarizing Columns......Page 282
Creating a Summary Table......Page 283
Explanation of Statistics......Page 285
Example of Adding a Statistics Column......Page 287
Tabulating Data......Page 288
How to Create a Table in Tabulate......Page 289
Statistics......Page 290
Columns by Categories......Page 292
Clicking and Dragging Items......Page 293
Using the Window......Page 294
Column Tables and Row Tables......Page 295
Changing Numeric Formats......Page 296
Editing Statistical Key Words and Labels......Page 297
Additional Tabulate Options......Page 298
Creating a Table of Counts......Page 299
Creating a Table Showing Statistics......Page 301
Rearranging the Table Contents......Page 302
Formula Editor......Page 304
Creating a Formula......Page 306
Referencing Columns and Table Variables......Page 307
Incorporating Parameters......Page 308
Inserting Constants......Page 309
Adding Operators......Page 310
Keypad Reference......Page 312
Using Functions......Page 313
Adding Numeric Functions......Page 316
Inserting Logarithmic or Trigonometric Functions......Page 317
Matching Character Patterns......Page 319
Comparing Values......Page 320
Using Conditional Clauses......Page 321
Calculating Quantiles and Probabilities......Page 322
Calculating Discrete Probabilities......Page 323
Computing Statistical Functions......Page 324
Using Dates and Times......Page 325
Processing Row State Data......Page 326
Using Assignment Functions......Page 328
Building a Formula in Order of Precedence......Page 329
Using Formula Editor Options......Page 330
Simplifying Complex Formulas......Page 331
Suppressing Evaluation......Page 332
Ignoring Errors......Page 333
Editing Formulas......Page 334
Deleting Functions......Page 335
Clicking and Dragging......Page 336
Hiding and Showing Boxing......Page 337
Changing a Formula’s Orientation......Page 338
Opening and Closing Arguments......Page 339
Using Basic Formula Editor Features......Page 340
Using Local Variables in a Formula......Page 342
Deleting Characters......Page 343
Using the Match Conditional Function......Page 344
Using the Delete Expression Key......Page 345
Glossary of Terms......Page 346
Personalizing JMP......Page 348
JMP Starter Window......Page 350
Saving Journals in a compressed format......Page 351
Excel Workbook/Worksheet Selection (Windows and Macintosh Only)......Page 352
Formula Evaluation......Page 353
Highlight Movement......Page 354
Extended File Format......Page 355
Customizing Analysis Settings......Page 356
Dates, Times, Names and Notes......Page 357
Setting Graph Height......Page 358
Closing and Saving Reports......Page 359
Marker Drawing Speed Threshold......Page 360
Changing Graph Colors......Page 361
Changing the Display Language......Page 362
Changing Font Types and Sizes......Page 363
Using Greek Letters and Math Symbols......Page 364
Specifying Graphic Formats......Page 365
Adjusting Communications Settings (Windows and Linux Only)......Page 366
Specifying File Locations and Associations......Page 367
Specifying File Locations (Windows and Linux Only)......Page 368
Customizing Text Import/Export Options......Page 369
Specifying Settings for SAS Integration......Page 370
Controlling JMP Updates......Page 372
Personalizing Toolbars (Windows and Linux)......Page 373
Showing/Hiding Toolbars......Page 374
Rearranging Toolbars......Page 376
Rearranging Buttons on Windows......Page 377
Deleting Toolbars on Windows......Page 378
Adding Toolbars on Windows......Page 379
Adding Toolbars on Linux......Page 380
Adding Buttons on Windows......Page 381
Adding Toolbars on Linux......Page 384
Customizing Menus (Windows and Linux Only)......Page 385
Rearranging Menu Items on Linux......Page 386
Example of Rearranging Menu Items......Page 387
Adding Menus on Windows......Page 388
Adding Menu Items on Windows......Page 389
Renaming Menu Items on Windows......Page 392
Creating the Customized File......Page 393
Changing the Default Location of .jmpmenu File (Windows)......Page 394
SAS Integration......Page 396
Connect to a SAS Metadata Server......Page 398
Connect to a SAS Server on a Remote Machine......Page 401
Opening SAS Data Sets......Page 402
Data Preview......Page 403
Column Details......Page 404
Open a SAS Data Set in JMP......Page 405
To import using a WHERE clause......Page 406
Importing a random sample of the data......Page 407
Import Options......Page 408
Running Stored Processes......Page 409
Submitting SAS Code......Page 410
Generating ODS Results......Page 412
Retrieving Generated SAS Data Sets......Page 413
JMP Starter......Page 416
The File Category......Page 418
The Basic Category......Page 420
The Model Category......Page 421
The Multivariate Category......Page 423
The Reliability Category......Page 425
The Graph Category......Page 426
The Surface Category......Page 429
The Measure Category......Page 430
The Control Category......Page 431
The DOE Category......Page 432
The Tables Category......Page 434
The SAS Category......Page 436
Main Menu......Page 438
New......Page 440
Save As......Page 441
Print Setup (Windows) or Page Setup (Macintosh)......Page 442
Cut......Page 443
Run Script......Page 444
Customize......Page 445
Concatenate......Page 446
Markers......Page 447
Delete Rows......Page 448
Formula......Page 449
Reorder Columns......Page 450
Response Surface Design......Page 451
Sample Size and Power......Page 452
Fit Y by X......Page 453
Modeling......Page 454
Multivariate Methods......Page 456
Reliability and Survival......Page 458
Scatterplot 3D......Page 459
Scatterplot Matrix......Page 460
Control Chart......Page 461
Profiler......Page 462
Arrow......Page 463
Magnifier......Page 464
Window List (Windows and Linux only)......Page 465
Make Text Bigger, Make Text Smaller......Page 466
Tile (Linux Only)......Page 467
On Macintosh......Page 468
Indexes......Page 469
Group......Page 470
Move Forward, Move To Front, Move Backward, Move To Back......Page 471
Formula Functions Reference......Page 472
Row Functions......Page 474
Transcendental Functions......Page 476
Trigonometric Functions......Page 478
Character Functions......Page 479
Character Pattern Functions......Page 484
Comparison Functions......Page 486
Conditional Functions......Page 487
Probability Functions......Page 491
Discrete Probability Functions......Page 499
Statistical Functions......Page 500
Random Functions......Page 504
Date Time Functions......Page 507
Row State Functions......Page 508
Parametric Model Functions......Page 512
A......Page 514
C......Page 515
D......Page 517
E......Page 518
F......Page 519
G......Page 520
I......Page 521
J......Page 522
M......Page 523
O......Page 525
P......Page 526
R......Page 527
S......Page 528
U......Page 531
W-Z......Page 532