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- Wai-Ching Leung, lecturer in public health medicine1
- 1University of East Anglia
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 …
Log in
Log in using your username and password
Log in through your institution
Subscribe from £184 *
Subscribe and get access to all BMJ articles, and much more.
* For online subscription
Access this article for 1 day for:
£50 / $60/ €56 (excludes VAT)
You can download a PDF version for your personal record.