What a Data File Looks Like
Useless: Typical Tables of Survey Results
The term 'data file' is a bit misleading, as files are only useful if they contain data in the appropriate format. For example, the data shown below is largely useless. Yes, it shows some results from the survey. However, it is impossible to use this data to compute many useful things. For example, this data cannot be used to work out if males were more likely to be satisfied than females.
Useful: Tables Containing One Row Per Respondent
By contrast, the data below is appropriate for data analysis. This table contains:
- A column for each of the different bits of data collected in the survey (e.g., age is in one column, education is in another).
- A single row at the top containing the headings that describe each column.
- A separate row for each respondent (i.e., all the data for the first respondent is shown the row under the headings, the row beneath this contains the data for the second respondent, and so on).
Getting a Data File for more information about the best way to structure data for analysis.