You are viewing documentation for the old version 2.30 of Analyse-it. If you are using version 3.00 or later we recommend you go to the latest documentation.

Indicating missing values

For a continuous scale variable, any observation that cannot be interpreted as a number will be treated as missing. Blank cells, cells containing text, or cells containing anything that isn't a number will be treated as missing observations.

For clarity we recommend using a dash to indicate a missing value, or enter a textual description to document why the value is missing. Excel's cell Notes/Comments can also be used to attach pop-up comments to document cells containing missing observations.

BEWARE  If blank cells are used to indicate missing be aware that an entire row of missing observations will cause Analyse-it to believe it has found the blank row indicating the end of a dataset. If this happens use a dash to indicate missing, then Analyse-it will correctly identify the extent of the dataset.

When importing or copy-pasting data from another application missing values will usually be imported as a dash or as a blank cell. Older statistical software packages often use a special value (usually very large) to indicate missing, which can be replaced with a dash or blank cell using Excel's Find & Replace feature.

(click to enlarge)