Categorising time responses

Categorising time responses using a single derived variable

In this example of use of a Time variable, a Derived Single Response variable is used to group Q1b, “What time did you arrive?” into suitable ranges for analysis on a table or chart.

  1. Click VariablesIcon.png to display the Variables window.
  2. Click NewSurveyIcon.png to add a new variable.
  3. Specify the Variable details:
    • Name: Time
    • Label: Time of arrival
    • Type: Derived (the variable will derive its data from Q1b, the existing time of arrival question).
    • Response: Single (each respondent will fall into only one of the new codes as there is only one time of arrival per case).
  4. Specify the Code Details. Any recognisable time format can be used in the Value specification but if using the 12 hour clock the am and pm suffixes must be applied

OpenEndedTime1.PNG .

  1. Click SaveIcon.png to save the variable. This derived variable can now be used in tables and charts in the usual way.
Table showing Time of arrival by Age

Categorising time responses using a time function

You can also categorise time responses using time functions. This example uses the hour function in a Derived variable to group responses to Q1b, “What time did you arrive?” into suitable ranges for analysis.

  1. Click VariablesIcon.png to display the Variables window.
  2. Click NewSurveyIcon.png to add a new variable.
  3. Specify the Variable details:
    • Name: Arrivalhour
    • Label: Hour of arrival
    • Type: Derived (the variable will derive its data from other existing variables).
    • Response: Single (each respondent will fall into only one of the new codes, as there is only one time of arrival per case).
  4. Set up the code values to categorise by hour.
Variable used to categorise time into hour bands
  1. Click SaveIcon.png to save the variable. You can now use this variable to analyse by respondents’ hour of arrival.
Contents