1 / 13

DATA PREPARATION and storage

DATA PREPARATION and storage. Part 3. Data storing. Once data are collected, they must be store d in a way that allows processing/analysis. A pile of paper with data is useless!. Data storing. Software requirements. For any type of analysis of macro or micro data: Excel (must) SPSS

pier
Download Presentation

DATA PREPARATION and storage

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DATA PREPARATION and storage Part 3

  2. Data storing Once data are collected, they must bestored in a way that allows processing/analysis. A pile of paper with data is useless!

  3. Data storing

  4. Software requirements For any type of analysis of macro or micro data: • Excel (must) • SPSS • Stata • R

  5. Surveys – data entry into a database

  6. Coding – closed questions Example What is your gender? • Male • Female Will be coded, e.g. as ‘1’ for male ‘2’ for female

  7. Coding – open questions Ex-post coding needed – responsibility of the researcher • Read all the questions and list all possible answers (normally, groups of same/similar answers can be spotted) • Assign a code to each answer category • Enter the codes into the database

  8. Coding – missing values • ‘Missing’ means that a persons did not reply for different reasons • Even such answers must be coded, e.g. -7 = no answer -8 = do not know -9 = not applicable (filtered)

  9. Codebook • To easily understand the data … • Create a codebook, where all the variables are assigned • Variable name • Variable label • Category codes • Category labels

  10. Data entry • Directly codes entered into the database …or • Data entry mask is used (e.g. survey monkey) • Variable ID always needed for each respondent • Check for errors!!

  11. Example – various questions Closed question What applies to your current employment situation? 1. I am currently employed → code 1 2. I do not have a work, but I am looking for it → code 2 3. I do not have a work, but I am not looking for it → code 3

  12. Example – variousquestions

  13. Example – various questions Open question What applies to your current employment situation? I work from time to time I am a public employee I am working for a Ministry I started my own business I am searching for work I am working on my own I have a job, but I do not like it and I am looking for another one I help out at home What would you do?

More Related