Could you please explain the reasons for not using 9, 99 etc. to represent missing values?
I remember reading somewhere that it is best not to leave any blanks. There’s no way of knowing whether a cell was left blank intentionally (missing data) or accidentally (data entry error). Maybe your recommendation to have a column to record the reason for the missing value will solve this problem.
Clear and practical advice - as always!
Could you please explain the reasons for not using 9, 99 etc. to represent missing values?
I remember reading somewhere that it is best not to leave any blanks. There’s no way of knowing whether a cell was left blank intentionally (missing data) or accidentally (data entry error). Maybe your recommendation to have a column to record the reason for the missing value will solve this problem.