Introduction to Auto Category variables
An Auto Category variable generates a list of the most frequently used words or code labels from a question’s response data. Auto Category variables can be used to analyse open-ended questions or multiple response closed questions. They are often used with word clouds. Auto category variables can help you to Auto category variable and word […]
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. Click to display the Variables window. Click to add a new variable. Specify […]
Calculating time intervals
Listed below are the instructions for creating variables to calculate an amount of time, such as duration of a wait and then put the figure into a time period, based on the difference between a time of arrival variable and a time of departure variable. Data will have already been entered into the questionnaires; including […]
Analysing time responses
Time questions enable respondents to give a specific time either in 12 or 24 hour clock and Time variables can be analysed in a number of ways as follows: Times can be categorised as falling into particular periods in the day, such as ‘rush hour’; ‘mid-morning peak’ or ‘lunchtime’. The difference between two times (for […]
Date function examples
Using a date function to determine the day of the week of a date This example shows the use of the date function weekday. You define a Derived Single Response variable to work out the day of the week for a particular date. Click to display the Variables window. Click to add a new variable. […]
Categorising date responses
Using a Derived Single Response variable is used to group Q1a, “When did you visit the restaurant?” into suitable ranges for analysis on a table or chart. Click to display the Variables window. Click to add a new variable. Specify the Variable details: Name: Date Label: Quarterly visits Type: Derived (the variable will derive its […]
Analysing date responses
Dates are analysed in a number of ways as follows: Date formats The software supports a wide range of date formats. All dates are based on the Gregorian calendar. Day The day number must appear in the range 1 to 31, with optional leading zeros. For example, 01, 02 are acceptable. Checks are made on […]
Categorising quantity responses with a derived variable
The following example uses the Crocodile Rock Cafe Survey. A Derived Variable is set up to allocate the data for Q5 “How much did you spend in total?” into ranges. Click to display the Variables window. Click to add a new variable. Specify the Variable Details: Name: V5 Label: Amount spent Type: Derived (the variable […]
Statistical calculations on tables
You can perform a chi-squared test to see if there is a significant relationship between two variables. You can display indexed counts or sums to give a relative measure of individual cell values. Applying the chi-square test The Chi-square test can be applied to single-response variables. It compares observed (actual) and expected (theoretical) values in […]
Analysing quantity responses
Quantity Response questions are used to collect open-ended numeric responses in a survey. This type of data would usually be values such as amounts of money, volumes, areas etc. Quantity Response data can be analysed as follows: A list of Quantity Responses can be produced either for all respondents or for respondents selected on the […]