Filtered Survey Analysis

The filtered analysis provides totals to all survey questions when the respondent's answer matches the selected question choice(s). Demographic survey questions can be filtered to analyze various survey populations.

The question type determines if an alphabetical, text, or numeric value is entered in the edit box. Only numerals, the letters A to Z and the characters '[','<', and '>' are entered in the edit box. Text with spaces can be entered to find matching responses to text entry questions. The matching response text is only active during the current session (It is not saved with other preferences.)

If the Not checkbox is marked, the opposite of the matching text is considered a match. For example, if the matching text shows the letter A, a filtered match would normally include all responses that contain A. If the Not checkbox is marked, then matches would include responses that do not include A. Some examples follow:

Single Response Question Type
sample question If your survey asked the person to identify their gender, you can get filtered totals to indicate how the rest of the survey questions were answered. This filtered analysis will show results of how either all males or all females answered the rest of the questions.

sample question With this example, Q. 1 indicates this is question number 1. The (A) indicates an alphabetical entry needs to be entered in the 'Matching:' edit box match will be performed. 'Gender' is the question 1 topic. Entering the letter A in the edit box indicates you want totals for all surveys if the respondent answered A for question number 1.

Multiple Response Question Type
sample question A survey question with check boxes allows the respondent to check one or more boxes. Letters in the edit box must match the letter choices.

sample question With this example, Q. 3 indicates this is question number 3. The (A) indicates an alphabetical entry needs to be entered in the 'Matching:' edit box match will be performed. 'New Job Information' is the question 3 topic. The letters AB in the edit box indicate you want totals for all surveys if the respondent answered either A or B for this question.

Single Scale Question Type
sample question A scale question saves values in the response database. The first text choice is given the value of 1. Non-responses, which are recorded in the database as a 0 would not be included in the analysis. With this example, Q.4 indicates this is question number 4. The (V) indicates a numeric value needs to be entered in the 'Matching:' edit box match will be performed. 'Dept. Cooperation' is the question 4 topic.

sample question Entering the numeral 1, would only calculate totals to the other survey questions if the respondent answered 1 to this question. Entering <3 or 12 in the edit box will have the program calculate totals to the other survey questions if the respondent answered either 1 or 2 to this question, because both are less than 3. The maximum value is the total number of text choices.

Multiple Scale Question Type
sample question
The Multiple scale question type saves values for each part of the question. This example uses values ranging from 1 to 5. This user-defined scale (Excellent to Unacceptable) was chosen when the questions were created. This question type allows the respondent to give duplicate values.

sample question Each of the text choices is listed as an option. In this example, Supervisor is the question topic, Knowledge is the choice topic. With this example, Q.5 indicates this is question number 5. The (V) indicates a numeric value needs to be entered in the 'Matching:' edit box match will be performed. Entering <3 in the edit box will have the program calculate totals to the other survey questions if the respondent answered either 1=Excellent or 2=Good to this question, because both are less than 3. The maximum scale value was determined when the questions were entered.

2-Column Scale Question Type
sample question
The 2-Column scale question type saves values for each part of the question. This example uses 2 different scales. Each scale values ranging from 1 to 5. These scales, and the maximum values for each scale, were set when the questions were created.

sample question Each of the text choices for each column is listed as an option. In this example, CBS (row) was chosen with Picture Quality (column). With this example, Q.6 indicates this is question number 6. The (V) indicates a numeric value needs to be entered in the 'Matching:' edit box match will be performed. Entering 1 in the edit box will have the program calculate totals to the other survey questions if the respondent answered 1 = Excellent to the picture quality for CBS.

Numeric Rank Question Type
sample question
The Numeric Rank question is similar to Multiple scale question type. Both save values for each part of the question. The difference is that ranking does not allow duplicate values. Only one item can be ranked first. A rank question compares each choice to the other choices. A Multiple scale question does not compare the choices to the other choices in the list. This question type calculates the top 5 ranks.

sample question With this example, Q. 7 indicates this is question number 7. The (V) indicates an numeric value needs to be entered in the 'Matching:' edit box match will be performed. 'Client Decision' is the question 7 topic. 'Prices' is the choice topic for selection B. The value 1 in the edit box indicate you want totals for all surveys if the respondent ranked Prices as most important 1 for this question.

3-Column Array (Matrix)
sample question The 3-Column Array (Matrix) question allows multiple checks. The database assigns each checkbox a letter.The letters A to I corresponds to the first column of the nine choices for each question. Letters J to R correspond to positions in the second column of choices. The letters S to Z with the character '[' correspond to positions in the third column.

sample question Letters represent the position of each checkbox. By entering STUV in the edit box, you would separate out only those businesses that lease at least one part of their business location(s).

Numeric Group Question
sample question The Numeric Group question type saves values for each part of the question. The maximum value was set when the questions were created. Normally the maximum value can be up to 99,999,999. However, you can set a lower maximum value. For this question a maximum value to be entered in any of the edit boxes would be set at 100.

sample question If we wanted to separate out those responses that advertised on television, we would enter >0 in the edit box. If we wanted to separate out those responses that spent more than 20% of media budget on television, we would enter >20 in the edit box. If you wanted exactly 3%, you would enter either =3 or 3. The equal sign is optional. A range of values, 10-20 can also be checked by entering the minimum and maximum values separated by a dash.

3-Column Numeric Question
sample question Each edit box is listed as an option. In this example the 4th row (Period 4) and the 3rd column (Science) edit box was the selected option.

sample question A range of values can also be checked by entering the minimum and maximum values separated by a dash, for example 10-20.

Text Entry Question
This question requires text to be entered in the edit box. If the text in the edit box matches any portion of the response text, it is considered a match. The program converts the text in the edit box and the data file to the same case for comparisons if DOG is entered in the edit box, it will match all forms of the word (Dog, dog, DOG, etc).

The six extra fields can be added to each set of survey responses are all text entry questions. This text can also be entered when recording responses from a paper survey, revising the current database, and importing records into the database. Of course, if these fields are not included in the database, they are not available for analysis. The checkbox on the Preferences Menu selection - Survey Titles/Headings must be checked so these fields are included in the survey response database. The six extra fields are the Email User name, Email Address, Email User IP, and 3 User Codes.

For example, if @ibm.com was entered for the matching email address, any survey with @ibm.com would be included in the question calculations. Your results would show how only those respondents with @ibm.com in their email address answered the survey questions.

Date Entry Question
Examples of 5 different date filters to be entered in the edit box are listed below. Dates are stored in the database in YYYYMMDD format, so the search for matches must be in the same physical order.
C = Calendar Month200510Year 2005 and Month 10 (October 2005)
D = Day33rd day of any month
F = Full Date20051225December 25, 2005
M = Month11November (any year)
Y = Year19981998

Text is entered in the edit box. The first character must be the letter C, D, F,M, or Y. The second character is usually the mathematical symbol <, =, or >. If a mathematics symbol is not used, equal is assumed. The rest of the text is numbers indicating the date value to test for the filtered choice. The year must always have 4 digits. Days and months can be 1 or 2 digits. Survey Power will add the leading 0 to the entry for the search if necessary. The mathematics symbols <, =, and > are all valid. Some more examples:

F>20041225Find all matching information if the date greater than December 25, 2004
Y<2000Find all matching information if the year is less than 2000.
M6Find all matching information if the month is June (equal is assumed)
M5-7Find all matching information for months of May to July, any year
C=200108Find all matching information for August 2001. (8th month of 2001)
Y2001-2003Find all matching information for the years 2001 to 2003 (range)

Page last updated: January 26, 2008