Use Tabulated Statistics when you have data that are categorized by one or more
categorical variables. You can determine various statistics for combinations of categories
across two or more categorical variables.
For information about examples and interpretation, go to Overview for Descriptive Statistics.
Variables
Complete the following steps to tabulate the data.
- In Categorical row variables, enter up to 3 columns that contain the categories that define the rows of the table.
- In Categorical column variables, enter up to 2 columns that contain the categories that define the columns of the table.
-
In Summarized variables (optional), enter the columns that contain the associated variables to summarize. An associated variable is a continuous variable that is grouped by categorical variables.
By default, the mean is the only statistic the table displays. To display additional statistics, select Summary Statistics from the drop down that is beside the variable name. Some statistics require you to enter additional values.- Percentile
- If you select Percentile, you must enter a value in Percentile value. The value must be between 0 and 100. For example, if you enter 50, Minitab displays the 50th percentile.
- Percent between two values
- If you select Percent between two values, you must enter numeric values in First value and Second value. The value you enter for First value must be less than or equal to the value you enter for Second value. Minitab displays the percentage of observations that is between the two values. This includes observations equal to the two values.
- Percent equal to specified values
- If you select Percent equal to specified values, you must enter one or more values in Values. The values must be the same type of data as the column you entered in Summarized variables. Minitab displays the percentage of observations that is equal to the values that you enter.
For more information on table layouts, go to Arrangement of output tables.
In this worksheet,
Strength is the
summarized variable and contains fiber strength measurements.
Machine is the column
variable and indicates the machine that produced the fiber.
Operator is the row
variable and indicates the person operating the machine.
| C1 | C2 | C3 |
|---|---|---|
| Strength | Machine | Operator |
| 38 | 1 | 1 |
| 40 | 2 | 2 |
| 63 | 3 | 3 |
| 59 | 4 | 1 |
| 76 | 1 | 2 |
| ... | ... | ... |
Categorical Variable Summary Statistics
Select the summary statistics for categorical variables that you want to display in your
table.
- Count
- Display the observed count for each combination of row and column variables.
- Row percent
- Display the percentage that each cell represents of the total observations in the table row.
- Column percent
- Display the percentage that each cell represents of the total observations in the table column.
- Total percent
- Display the percentage that each cell represents of all the observations in the table.
Display Options
Select how you want to display marginal statistics and missing data. You can include missing
data in the output table and calculations.
- Display marginal statistics
- Select to display the marginal statistics. Marginal statistics provide information about the rows and columns of your table, such as the totals.
- Display missing values
- Select to display missing values. Minitab excludes all rows with any missing variables unless you include missing data. Select Include displayed missing values in calculations to include missing values in the calculations. For more information, go to How to interpret missing values in a table.
