Writer Guide

□ Example of survey involving yes/no answers
In a fictitious yes/no survey we aimed to find out if handedness is related to sex. So we put
the question “are you mainly right or left handed?” to a mixed group of people. The raw res-
ults are listed in table 6, the summary is to be found in table 7.
To obtain grouped results as in table 7 do the following:
1. Copy the two right columns “sex” and “handedness” from the raw data in table 6 into
memory and insert them into your spreadsheet.
2. In your spreadsheet again mark these same two columns.
3. Go to the menu Data › Pivot Table › Create and confirm Current Selec-
tion.
4. Drag & Drop the button “Sex” onto the white area Row Fields and the button
“Handedness” both onto the white area Column Fields as well as onto the white area
Data Fields (see illustration 29).
5. Under Options choose Count instead of Sum and press More and there choose
as Type the option % of row.
6. Copy the resulting Cross Table into computer memory.
7. Back in your text file insert the contents of computer memory using the keyboard
shortcut Shift + Ctrl + v and choose the option Formatted text [RTF] (so
as to obtain a formatable table)
31
Illustration 28: The number of decimal places is reduced to 0