Intended for healthcare professionals

Student Education

Making sense of quantitative data

BMJ 2001; 323 doi: https://doi.org/10.1136/sbmj.0107new (Published 01 July 2001) Cite this as: BMJ 2001;323:0107new
  1. Wai-Ching Leung, lecturer in public health medicine1
  1. 1University of East Anglia

Wai-ching Leung tells you the best way of dealing with your data

I discussed in a previous article how surveys are used to collect information from a large number of people.1 In surveys, closed - that is, forced choice-format questions are most often used, as they allow quantitative analysis to be carried out and the results to be generalised.

Imagine that you aim to investigate the possible effects of part time jobs on their course achievements among medical students in your medical school. You have just got 1000 questionnaires back, each with responses on details about their jobs, course assessment results, and personal details totalling more than 20 responses from each student. How are you going to make sense of them and present the information to other students? Armed with only a paper, a pencil, and a calculator, it will probably take many hours just to work out the average responses for each question asked. Just to calculate the correlation coefficient between any two variables would involve literally thousands of arithmetic operations and errors are almost inevitable. This is why the statistical software and a systematic method of analysing such quantitative data are essential.

Organising the information

The range of computer software available might initially seem daunting-from simple spreadsheet package - for example, Excel - simple statistical packages - for example, Minitab, SPSS - to more complicated statistical packages - for example, SAS. However, they all share a simple format for organising the information. Furthermore, once data files are collected in this format they can be interconverted. Data are basically organised as in a spreadsheet - each row holds the information relating to one subject while each column holds the information on each variable.

Coding and entering data

Coding data means a simple and consistent way of representing each observation and making them easier to be …

View Full Text

Log in

Log in through your institution

Subscribe

* For online subscription