# Select the analysis options for Store Descriptive Statistics

Stat > Basic Statistics > Store Descriptive Statistics > Options

Select options for calculating and storing statistics when you use a grouping variable.

## Store a row of output for each row of input

Select this option if you want Minitab to repeat the stored statistics in every row of the worksheet that contains data. By default, Minitab stores the statistics one time in the first row of the worksheet. If you have By variables, Minitab stores the statistics in the first number of rows that are equal to the number of By variables or combination of By variables.

### Store statistics once

C1 C2-T C3-T C4
Defects Machine ByVar1 Sum1
100 A A 150
200 B B 500
300 B
50 A

### Store statistics in each row

C1 C2-T C3-T C4
Defects Machine ByVar1 Sum1
100 A A 150
200 B B 500
300 B B 500
50 A A 150

## Include empty cells

If you have multiple By variables, Minitab stores summary statistics for all combinations of the By variable levels, including combinations for which there are no data (empty cells). Deselect this option if you do not want to store the empty cells.

For example, no data was recorded for Density = Low, or Operator = 1 in this worksheet.

### Include empty cells

C1 C2 C3 C4-T C5 C6
Length Density Operator ByVar1 ByVar2 Count1
3.4 High 1 High 1 1
2.7 High 2 High 2 1
4.1 Low 2 Low 1 0
Low 2 1

### Do not include empty cells

C1 C2 C3 C4-T C5 C6
Length Density Operator ByVar1 ByVar2 Count1
3.4 High 1 High 1 1
2.7 High 2 High 2 1
4.1 Low 2 Low 2 1

## Include missing as a By level

Select to include missing values in your By variables as a separate group. Missing values are indicated by an asterisk (*) in numeric data and by the word Missing in text data. By default, Minitab ignores data from rows that have missing values in a By variable.

### Do not include missing values

C1 C2-T C3-T C4
Defects Machine ByVar1 Sum1
100 A A 100
200 B B 250
300 *
50 B

### Include missing values

C1 C2-T C3-T C4
Defects Machine ByVar1 Sum1
100 A A 100
200 B B 250
300 * * 300
50 B

## Store distinct values of By variables

Deselect when you do not want Minitab to include columns that identify the levels of the By Variables.

By default, Minitab stores a column that includes the values of the By variables corresponding to the stored statistics. This options is helpful when the stored statistics are not adjacent to the original columns of data.

### Store By variable

C1 C2-T C3-T C4
Defects Machine ByVar1 Sum1
100 A A 150
200 B B 500
300 B
50 A

### Do not store By variable

C1 C2-T C3
Defects Machine Sum1
100 A 150
200 B 500
300 B
50 A
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy