A worksheet contains all the data that is in a data set. You can have multiple worksheets in one project.

Parts of the worksheet

A worksheet, displayed in the Data window, organizes your data into columns and rows. A worksheet can also store constants, matrices, and design objects used in DOE procedures.

You can have multiple worksheets in one project. The active worksheet is identified by three asterisks (***) beside the worksheet name in the title bar. When multiple worksheets are open, commands affect only the data in the active worksheet.

Data can be stored in the following areas of a worksheet.
Columns

Each column contains the data for one variable. Each column has a unique number that starts with a C (C1, C2, and so on). These column numbers are displayed at the top of each column in the worksheet. To give a column a descriptive name, type the name in the shaded cell under the column number.

Constants

Constants are single numbers or text values that you can define and use in formulas and calculations. For example, you can define historical parameters for probability distributions. Using stored constants instead of individual values can save data-entry time and add flexibility to macros.

Stored constants are saved with the worksheet, but they are not displayed with the worksheet. To view stored constants in the Session window, choose Data > Display Data.

All stored constants have a unique number that starts with a K (K1, K2, and so on). You also can name stored constants.

For information on storing and working with constants, go to Work with worksheets and click "Define stored constants".

Matrices

Matrices are rectangular blocks of numbers on which mathematical operations can be conducted. Matrices are often described by their dimensions. For example, the following is a 3 x 4 (row x column) matrix.

14 22 23 44 
15 36 27 38
19 16 31 42

Matrices can be used in equations. In Minitab, you can store matrices with a worksheet and use stored matrices in some commands. Minitab can also store output in matrices for some statistical analyses (for example, the design matrix for regression, GLM, and DOE procedures). All stored matrices have a unique number that starts with an M (M1, M2, and so on). You can also name matrices.

Stored matrices are saved with the worksheet, but are not displayed with the worksheet. To view stored matrices in the Session window, choose Data > Display Data.

For information on storing and working with matrices, go to Overview for Matrices.

How much data can a worksheet contain?

Each worksheet can contain up to 4000 columns, 1000 constants, and 10,000,000 rows. The total number of cells depends on the memory of your computer, up to 150,000,000. This worksheet size limit applies to each worksheet in a Minitab project. For example, you could have two worksheets in your project, each with 150,000,000 cells of data. Minitab does not limit the number of worksheets you can have in a project file. The maximum number of worksheets depends on your computer's memory.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy