The Data window—the grid of rows and columns where you enter data—is an important part of Minitab, with many features that make working in Minitab easy. Even though it’s an integral part of every Minitab analysis, many users don’t give it much thought until they run into problems when they try to enter, import, or manipulate data. Knowing what the Data window can do and how it works can save you time—and maybe a little frustration—when you use Minitab. Here are a few tips for working effectively in this critical part of the Minitab environment.
ورود داده ها
The Data window offers a number of features that can make the somewhat tedious process of data entry easy. Here’s a sample of those features.
جهت ورود داد ه ها
هنگامی که جهت فلش به طرف پایین باشد با زدن کلید enter سلول فعال به سمت پایین حرکت می کند.
Recode values from the Data window
If you've ever used the find-and-replace feature on a word processor, you know what a time saver it can be—it's quicker and much more accurate than working by hand. Right-click the Data window to access a similar tool that finds and replaces data values.
Create simple patterns with Autofill
Minitab’s Data window can take the tedium out of creating repetitive or patterned values. Just highlight the pattern, and then click and drag to extend it to where you want it.
You can access these and many other features without leaving the Data window. Just right-click the Data window to reformat columns, change value order, insert and move columns, and more.
In many cases, the person who collects data is not the one who analyzes it in Minitab. Because of this fact, data are often collected with the tool at hand, be it a spreadsheet or text file. Fortunately, importing data from a non-Minitab file is often as simple as opening a standard Minitab worksheet. Here’s an example.
Importing an Excel spreadsheet
Suppose that you have an Excel workbook with three sheets and you want to import all of sheets into the Minitab Data window for analysis.
- Choose File > Open Worksheet.
- From Files of type, choose Excel.
- Navigate to and select the Excel file.
- Click Preview to ensure that the spreadsheet is imported into Minitab correctly.
- Click Options to make adjustments in the way the spreadsheet is imported.
- Click OK in each dialog box.
As you can see in the above example, importing even the most complex of files into the Data window isn’t difficult. In fact, you can use the exact same steps to import files in a wide array of formats.
Once your data are in Minitab, you can change the way that they’re organized. Minitab is very accommodating in the way that your data can be formatted, so reorganization is often a matter of personal preference. Often, the layout that is easiest to use for data collection isn’t the easiest to work with later on. Here's an example.
Suppose that you collected data on three items from your product line in an unstacked format (shown on the right). However, as you explore the data, you find that a stacked format would be simpler to analyze.
- Choose Data > Stack > Columns.
- In Stack the following columns, enter the columns to stack.
- Click OK.
Whether you want to stack, unstack, merge, or subset your data, Minitab offers several straightforward tools to restructure your Da