210 likes | 276 Views
Preparing a data table: Not all that complicated !!!. By : The CEF professionals 2007. Photo : web. Photo : André Gagné. Photo : web. ?. Why this presentation?. To avoid the enormous waste of time often associated with repeated but avoidable data handling.
E N D
Preparing a data table: Not all that complicated !!! By : The CEF professionals 2007 Photo : web Photo : André Gagné Photo : web
? Why this presentation? To avoid the enormous waste of time often associated with repeated but avoidable data handling. To facilitate ready understanding of the data set, even many years after it was first created!!!
Data sheets (1/2) Write legibly. Anticipate who might make use of the data. Include the date. Organise by line… Anticipate any contentious cases & try to work around these (% closing of forest cover ou opening ?!)
Data sheets (2/2) Remarque :
The Data TableNames of variables (1/5) Keep as simple & short as possible, but still comprehensible! One variable = one column Several times for the same variable = several columns Break up complex categories: e.g., irrigated & fertilised balsam fir in block 2 To break up the indicators: fir tree irrigated and fertilized in block 2
The Data Table Names of variables (2/5) Place class or categorical variables at the beginning of the table, followed by the response variables. Whether using capital or small letters, be consistent, as certain programs are case-sensitive (R)!!! Things to avoid : Special characters (/$%?&) Spaces Be clear and precise, and include a comment sheet where all abbreviations are explained OR If you are in Excel, use «Insertion / Comments»
latérale Names of variables (3/5)
Names of variables (4/5) The «remarks» column in a data sheet = imparts flexibility to a data table by allowing: inclusion in an analysis or exclusion from an analysis CHECK YOUR DATA
The Golden RuleOne Line = One Sample Avoid the pain of having to start the process all over, or having to make more or less complex data manipulations.
Original data (1/6) Before all modifications, save a copy of the original table & make modifications to a copy that you can regularly save or back up. Example: terrain2005ori.xls terrain2005_05122006.xls terrain2005_06122006.xls etc.
Original data (2/6) In your Excel workbook, the sheet farthest to the left should contain ONLY the original data in a CONTINUOUS table
Original data (3/6) NEVER leave cells empty
Original data (4/6) Missing data should be indicated by « . » Careful, always differentiate missing values from actual zero (0) values!!!
Original data (5/6) Be consistent with your codes : ABBA ≠ abba ≠ Abba Coding of numerical data with « . » or « , » will depend on what computer or operating system you use? If you aren’t sure…utilise the decimal key in the calculator section of the keyboard
Original data (6/6) Include cases where species have not been observed (NB in ecology!!!)
Analysis of tables • Move from left to right, ALWAYS keeping a sheet that contains the raw data. Une feuille pour les données originales, les autres pour les tableaux-croisés dynamiques ou les graphiques
Data tables vs. Data bases • A data table is organised by lines and by columns. • A data base is a collection of data sheets & tables that allow you to store a great amount of information.
Conclusion • Remain logical and structured. • Include raw data. • Save and back up, frequently. • «Comments» sheet (measurement units, abbreviations, personnal notes …) • REMEMBER: • The word «DATA» is plural! • The word «DATUM» is singular!