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.

In This Topic

Store a row of output for each row of input
Include empty cells
Include missing as a By level
Store distinct values of By variables

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