A clinic is preparing data to train a machine learning model that predicts a patient's risk of type 2 diabetes. An extract of the raw data is shown.
| VisitID | Age | Mass (kg) | Smoker | Visit date | Receptionist |
|---|---|---|---|---|---|
| V101 | 34 | 72.5 | Yes | 2026-03-14 | Ms Patel |
| V102 | 51 | No | 2026-03-15 | Mr Okafor | |
| V103 | 245 | 80.1 | No | 2026-03-15 | Ms Patel |
| V104 | 29 | 65.0 | Y | 16/03/2026 | Mr Okafor |
| V105 | 62 | 90.3 | No | 2026-03-17 | Ms Patel |
| V105 | 62 | 90.3 | No | 2026-03-17 | Ms Patel |
(a) Identify four different data-quality problems in this extract. For each, refer to a specific record or field. [4]
(b) Explain why the Receptionist field should be removed before the model is trained. [2]
- (a) Missing data: V102 has no value for Mass (accept blank / null field)(1)
- (a) Incorrect / impossible value: V103 Age 245 (accept outlier / invalid age; must name V103 or 245)(1)
- (a) Inconsistent formatting: V104 Smoker recorded as "Y" instead of "Yes" or V104 date in DD/MM/YYYY instead of YYYY-MM-DD (either for one mark; do not award twice)(1)
- (a) Duplicate record: V105 appears twice (accept duplicate rows)(1)
- (b) Receptionist is irrelevant data: it has no (causal) relationship with diabetes risk(1)
- (b) Keeping it adds noise / could let the model learn a spurious pattern (e.g. linked to which patients a receptionist sees), reducing accuracy / generalisation (accept wastes computation / increases dimensionality)(1)
- Answer: (a) missing mass (V102); impossible age 245 (V103); inconsistent format Y / date (V104); duplicate V105. (b) irrelevant to the outcome, adds noise / spurious correlations.
- Examiner tip: Each problem must be tied to a record; "some data is missing" without saying where scores nothing.