A short series aimed at upskilling distance learning students on how to make the best use of excel. In this lecture I cover Broman & Woo's principles of organising data in spreadsheets.
Contents: 00:20: Tidy data principles 01:17: Overview of Broman & Woo's principles 03:00: Consistency, naming and date formats 05:50: Naming examples 10:10: Data entry, missing data, and formula 12:50: Data validation, machine readable and backups 14:50: Test yourself, what problems do you see with this data? 15:30: Tidy data along with me
The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336, VAT Registration Number GB 592 9507 00, and is acknowledged by the UK authorities as a “Recognised body” which has been granted degree awarding powers.