A missing value indicates that a specific piece of information is missing. For example, the missing value (*) in the following table indicates that there is no length measurement for part 5.

C1 C2 C3
Part Length Width
1 30.15 0.014
2 29.98 0.015
3 30.02 0.009
4 29.94 0.014
5 * 0.010

Missing values in numeric columns

In numeric columns, missing values are denoted by an asterisk (*). To enter a missing value in a numeric column, do one of the following:
  • Delete the existing value from the cell.
  • Type an asterisk into the cell.
  • If the cell is blank, enter a value into the cell below it.
Important

Do not use a number (for example, -999) to represent missing values. Using a number to represent missing values will cause errors in your analyses. To change specific numbers to asterisks, use Recode to numeric.

Missing values in text columns

When a cell in a text column contains a missing value, the word "Missing" is displayed in gray. To enter a missing value in a text column, do one of the following:
  • Delete the existing value from the cell.
  • If the cell is blank, enter a value into the cell below it.
Important

If you type the word "Missing" or an asterisk into a text column, Minitab treats the value as a text value, rather than a missing value.

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