When data is collected in Excel spreadsheets, the data often get misinterpreted by statistical software. Below you will find a 1st example spreadsheet with formatting issues, along with a cleaned version of the same database. The numbered circles identify cleaning steps described in the table at the bottom.
