How should we repair a class data table that mixes centimetres and millimetres?
EducationOur bridge-model project has a shared column headed “deflection, mm”. Some groups entered their ruler readings in millimetres, while others used centimetres. We can recover most of the units from the original notebooks, but three entries have no unit recorded anywhere we have checked.
A teammate wants to convert every small-looking number on the assumption that it must be centimetres. That would make the table look consistent, but we do not actually know what those three groups measured.
The NIST guide to SI prefixes gives the centi and milli scale factors, so converting a reading with a known unit is straightforward. Our uncertainty is about the labels, not the arithmetic.
How should we show the repair and the remaining unknowns in our report without making the cleaned table look more certain than the original records?