Open Record Step 12: Audit Yourself

Write an audit script over your cleaned data: totals, group sizes, duplicate ids, impossible values, and your headline number computed a second way by a different route. Run it and read the output as though someone else produced it. Fix what is broken, and write down what is odd but real. Then draw your chart and apply the four checks, especially the last one: show it to somebody without saying anything and ask what they conclude. If it is not what your data supports, the chart is wrong even though the numbers are right.