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.

جهت ورود داد ه ها

Data Entry Arrow

هنگامی که جهت فلش به طرف پایین باشد با زدن کلید enter سلول فعال به سمت پایین حرکت می کند.

Recode values from the Data window

Recode Values

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

Autofill BeforeAutofill After

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.

Importing data

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

Import Excel Spreadsheet Before

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.

Import Excel Spreadsheet After
  1. Choose File > Open Worksheet.
  2. From Files of type, choose Excel.
  3. Navigate to and select the Excel file.
  4. Click Preview to ensure that the spreadsheet is imported into Minitab correctly.
  5. Click Options to make adjustments in the way the spreadsheet is imported.
  6. 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.

Manipulating data

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.

Stacking data

Stack Data Before

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.

Stack Data After
  1. Choose Data > Stack > Columns.
  2. In Stack the following columns, enter the columns to stack.
  3. Click OK.

Whether you want to stack, unstack, merge, or subset your data, Minitab offers several straightforward tools to restructure your Da

Insert page numbers

You can choose from various page numbering designs that are available in the gallery.


Insert page numbers or Page X of Y page numbers

  1. On the Insert tab, in the Header & Footer group, click Page Number.



    Recode Values

  2. Click Top of Page, Bottom of Page, or Page Margins, depending on where you want page numbers to appear in your document.