the effect of change. It also contains Monte Carlo simulation to explore how uncertainty will affect your model and fine-tune it to achieve desired results. (See Figure 1.28.)
Figure 1.28 The Excel Profiler
1.7 JMP Preferences
JMP’s Preferences determine the way JMP appears or behaves on your machine. JMP has been carefully crafted to support the workflow of the data analyst. Its defaults have been selected to reflect common use, which we use in this book. However, JMP also provides options to customize the software to corporate standards or individual tastes. In this section, we will explore how one can customize the look, feel, and options that appear in JMP. Preferences (File Preferences on Windows; JMP Preferences on Mac) are the primary means of setting or changing the defaults in JMP that you will see each time you operate the software – think global settings here. Virtually any function in JMP can be set as a default, including specific tests within any platform, the look of graphs, color schemes, font sizes and styles, and how JMP works with other products such as SAS.
To view the preferences, choose File Preferences or JMP Preferences on a Mac. (See Figure 1.29.)
Figure 1.29 Accessing Preferences from the File Menu
This opens the Preferences window (see Figure 1.30), containing 22 main categories on the left and options within those categories on the right. You can change preferences by checking or unchecking the boxes within the categories on the right or by selecting items from drop-down menus. Changing preferences can affect such things as the graph or result format, the font, the location of a file, and much more, each and every time you use those features in JMP. If you are unsure about making a change to the preferences, we recommend that you wait until you have a need to do so.
Figure 1.30 The Preferences Dialog Window
| Note |
| If you need to make a change within a single graph or result, note that JMP also provides many of these formatting options within the graphs themselves. |
Let’s see how this works. New users on Windows often prefer to turn off the menu auto-hide option (which by design, provides a little more window real estate for graphics and statistics power users), making it a little easier to find the menu options described in this book.
Below we have an illustration of the menu hidden and unhidden (Figure 1.31). Notice the File, Edit, and other menus appear when they are not hidden. When the menus are hidden, you see an ellipsis where the menus would be. Holding your cursor over the ellipsis displays the menus.
Figure 1.31 Illustration of Menu Hidden and Unhidden
To change this auto-hide default to always show the menus, select File Preferences Windows Specific Autohide menus and toolbar Never (Figure 1.32).
Figure 1.32 Removing Menu Auto-Hide
If you want to change the default marker size, style, or color themes used in graphs, select File Preferences Graphs. Included is a handy preview to see how your selections will appear (Figure 1.33).
Figure 1.33 Graph Preferences
1.8 Summary
JMP was developed to help business professionals, scientists, or engineers get answers to the questions and problems that they encounter. The navigation and menus within JMP provide a natural extension of your problem-solving and a direct means to explore your data and generate the results that you need. This book uncovers the structure of JMP’s menus and provides easy steps for producing results. The standardized format of the windows in JMP prompts you through most analysis and graphing. Results can be customized using global detailed preferences.
Chapter 2: Data
2.4 Cleaning and Formatting Data
2.5 Selecting, Highlighting, and Filtering Data: Row States
2.6 Adding Visual Dimension to Your Data
2.7 Shape Files and Background Maps
2.8 The Tables Menu
2.9 Summary
The first step in creating a graph or analysis is to get your data into JMP. With JMP, you can easily import data from many different sources such as Microsoft Excel or ODBC-compliant databases, or you can enter your data directly into a JMP data table. Because most readers already have data in one form or another, this section focuses on getting that data into JMP from another file format. Sometimes data is not in the best condition when you import it. Later in this chapter, we discuss what you can do to format data or deal with missing data. JMP also supports unstructured text and shape files (that can be used to create maps). We will describe the special requirements of using these file types.
As mentioned in the previous chapter, we use Windows as our default operating system to illustrate JMP and its native menus as shown in the below image. JMP instructions for Windows and Macintosh are basically the same, though some operating system differences are noted when they occur.
Example 2.1 Big Class Families
We will be using the Big Class Families.jmp data file to illustrate the steps in this section. This data set consists of 40 middle-school students and their image, name, height, weight, gender, age, and other miscellaneous information. You can access this data set in the Sample Data folder that is installed with JMP: File Open C: Program Files SAS JMP 15 Samples Data Big Class Families.jmp. Alternatively, you can select Help Sample Data Library Big Class Families.jmp.
2.1 Getting Data into JMP
Getting your data into JMP is a familiar process. Like many other desktop applications, you can simply select File Open to import your data into JMP. JMP can handle many different data formats. Table 2.1 shows the default formats JMP recognizes. Other previously installed applications could contain proprietary formats that might also appear as import options. You can import files with these formats as well.
In this section, we show you how to open JMP data tables and how to import Microsoft Excel spreadsheets and text files in JMP. Each of these file formats follows the same basic procedure, but each has special options that enable you to import exactly what you want. JMP interfaces with databases using Open DataBase Connectivity standard (ODBC). Through the Query Builder dialog box, you can easily set up queries of your data and automatically create SQL code that can be saved and repurposed.