Operating ManualAboutQuickCross is Macromill's original tabulation software made exclusively for our researchsystem. Install the software on your PC, and you can cross tabulate or create graphs/
charts with simple operations.
External data in Excel and text formats can also be added.

Main Features
Creation of GT tables

Creation of freeanswer (FA) lists

Creation of crosstabulation tables

Raw data export

Creation of graphs
and charts

Data import

Data processing

GT Tables

Cross Tabulation Tables

1

Examples of Output
Creation of free answer ( FA) lists
You can examine responses to open-ended questions at a glance.

Import External Data
Excel or text-based data can be imported and tabulated.

2

INDEXCreating GT (simple tabulation) tables

page 4Creating GT tables and graphs or charts

page 5

GT table sheet structure

page 6

GT table graph/chart patterns

page 7Creating GT tables by narrowing down respondents based on certain criteria

page 8

Exporting GT tables that have been narrowed down as multiple files (Criterion Variable)

page 9Creating cross tabulation tables (*1) and tabulation tables
with graphs/charts

page 10Creating cross tabulation tables

page 11

Changing the export format of cross tabulation tables

page 12

Setting the narrowing down or divided output of cross tabulation tables

page 13Creating a cross tabulation table with graphs/charts

page 14Creating a 3-Way X tabs

page 15

Processing raw data (*2)

page 16

Performing data processing

page 17[RECODE] to summarize choices

page 19[INTEGRATE] to combine choices

page 21[CLASS] to categorize numerical data

page 23[MCONVERT] to combine the same choices

page 25[Add Subtotals] to add subtotals

page 27[Count for Mean] to calculate the mean number of checks in a multiple answer

page 29

Data processing FAQ

page 31

Creating a free answer (FA) list

page 32

Creating a free answer (FA) list

page 33(Criterion variable) to narrow down a free answer (FA) list to certain criteria anddivide it into sheets

page 34

Importing data

page 36

What is data import?

page 37

The data import guide to importing data

page 38

Data import operating instructions

page 39*1 Cross tabulation is the process of taking the values revealed through simple tabulation and examining the data in greater depth by combining it withinformation such as respondent profile and customized variables.
(This is used to gain insight such as whether there is a difference in responses based on gender, age group, region, or other variables.

*2 Data processing is a function for processing tabulation data such the summarization of choices, the creation of new variables by categorizing numerical
data, and the deletion of samples that match designated criteria. Samples that match designated criteria, and so on.
The images shown in this manual may differ from those at the time of release.

3Creating GT (simple tabulation) tables
Creating cross tabulation tables andtabulation tables with graphs/charts

Creating GT ( simple tabulation) tables
In QuickCross, GT tables and graphs or charts can bepage 5

GT table sheet structure

page 6

GT table graph/chart patterns

page 7Creating GT tables by narrowing down respondents based on
certain criteria

page 8

Exporting GT tables that have been narrowed down as multiple
files (Criterion Variable)

page 9Creating a free answer (FA) list

Creating GT tables and graphs or charts

Processing raw data

created based on the format of questions.

Importing data

4

Creating GT (simple tabulation) tables

Creating GT tables and graphs or charts
With a GT table, you can tabulate the number of responses and their percentages
for each question, and analyze overall trends.
Graphs and charts are automatically created as GT tables are exported.

Creating cross tabulation tables andtabulation tables with graphs/charts

1
Select [GT Table] from the main menu.

2[Specifying export variables]

Processing raw data

The variables with the On mark in the [On/Off]column will be exported to an Excel file.
If you do not wish to export a certain variable, avariable, select it and toggle output by changing
the button from the [ On] mark to the [Off] mark.
Press [All Off] to disable output for all variables.
* Pressing [Reset] restores the default settings.

3
Creating a free answer (FA) list

[Outputting a GT table]
Press [Execute] to export the GT table and graph/chart.

KEYPOINT
The output order can be changed with
[Output Order Setting]. The output
variables can be sorted into the desiredorder by moving the variables across to
the right side.

Importing data

5

Creating GT (simple tabulation) tables

GT table sheet structure
There are three types of GT tables, an "N Table" that shows the number of responses foreach question, a "% Table" that shows the responses in percentages, and an "N%
Table" that shows both the N Table and % Table alongside one another.
A Graph/Chart is exported together with the GT table.
N% Table

Creating cross tabulation tables andtabulation tables with graphs/charts

INDEX

Processing raw data

The INDEX includes links that jump to the corresponding table when selected.

Creating a free answer (FA) list

N Table% TableImporting data

6

Creating GT (simple tabulation) tables

GT table graph/chart patterns
The format of the graph/chart for a GT table varies depending on the question
type. They can be exported according to the following patterns.

Creating cross tabulation tables andtabulation tables with graphs/charts

Multiple Answer(MA)Format allowing only one choice to be selected
The selected percentage is shown.
(If the choices are added up, the percentage will be 100%)

Format allowing multiple choices to be selected
The percentage of responses for each choice are shown.

Matrix(SA)Ranking(RNK)

Format that asks multiple single answer questions
The percentage of responses is displayed for eachquestion.
(If the choices are added up, the percentage will be 100%)

Format where responses are given in a ranking format
For each choice, the percentage of responses that
included it in each ranking is shown.

Processing raw data

Single Answer(SA)Creating a free answer (FA) list
Importing data

7

Creating GT (simple tabulation) tables

Creating GT tables by narrowing down respondents
based on certain criteria
Respondents can be narrowed down using certain criteria to check results for only
a specific subset of respondents.

Creating cross tabulation tables andtabulation tables with graphs/charts

1
From the menu screen, select [GT Table] andthen select the [Filter Setting] tab.

2
[Setting the Filtering Criteria]

Processing raw data

Place a check beside [Filtering Criteria] and set thecriteria variable, operator and value. The choices forthe criteria variable can be checked by pressing the[...] button of the value.
The results can be narrowed down based on up to
five specified criteria.

3[Outputting a GT table]
When [Execute] is pressed, a GT table filteredaccording to the specified criteria is output.

Operator=

Setting multiple values (* examples)… equal to=1-3… any of choices 1, 2 or 3<> … not equal to= 1/2… either choice 1 or 2<

… greater than thevalue on the left

= 1-3/5 … either of choices 1, 2, 3 or 5>

… less than thevalue on the left<>1-3

… excluding choices 1, 2 and 3

the value on the left<= … is equal to or less than
the right value<>1/2… excluding both choices 1 and 2

the value on the left>= … is equal to or morethan the right value<>1-3/5 … excluding choices 1, 2, 3 and 5

Creating a free answer (FA) list

* In this example, as "SEX=1 (male)" was set as criteria, the value
for female is returned as "0".

KEYPOINT
As AND and OR cannot be used
together, when combining two or morecriteria, please use one or the other.

Importing data

When filtering criteria have been specified, [Filter Setting : ON] will be shown to the left of the [Execute] button. Additionally,
the criteria used to narrow down the GT table will be displayed in its INDEX.

8

Creating GT (simple tabulation) tables

Exporting GT tables that have been narrowed
down as multiple files (Criterion Variable)
When you wish to output multiple patterns of a GT table that has been filtered,tables narrowed down for each choice can be output together using the [Criterion
variable] function.

Creating cross tabulation tables andtabulation tables with graphs/charts

1
From the menu screen, select [GT Table] andthen select the [Filter Setting] tab.

2
[Setting criterion variables]
Set the variable to be filtered in [Criterion variable].
After doing so, press the [...] button under [Export
Path] to specify the destination of the exported file.

Processing raw data3
[Outputting a GT table]
Press [Execute] to export multiple GT tables filteredaccording to the specified variables.

Creating a free answer (FA) list

Example: When Gender is set as a criterion variable,
two files are output, containing the results for only
male respondents and only female respondents,
respectively.

When criterion variables have been specified,[Criterion Variable to Divide Output : ON] will beshown to the left of the [Execute] button.
Additionally, the criterion variable and choices will be
displayed in its INDEX.

Importing data

9

Data from male
respondents only

Data from female
respondents only

Creating GT (simple tabulation) tables

Cross tabulation is the process of taking the values revealed in a grand total (GT)and examining the data in greater depth by combining it with information

Creating cross tabulation tables andtabulation tables with graphs/charts

Creating cross tabulation tables andtabulation tables with graphs/chartssuch as respondent gender, age or region, and other questions.

based on gender, how age group or regional differences affect this, and so on)
In QuickCross, when a cross tabulation table is execute,scores that show a particular difference are color coded so that

Processing raw data

(This is used to gain insight such as whether there is a difference in responses

the results can be checked in a way that is easy to understand.
Cross tabulation tables with graph/charts can also be exported.

page 11

Changing the export format of cross tabulation tables

page 12

Setting the narrowing down or divided output of crosstabulation tables

page 13Creating a cross tabulation table with graphs/charts

page 14Creating a 3-Way X tabs

page 15

Creating a free answer (FA) list

Creating cross tabulation tables

Importing data

10

Creating GT (simple tabulation) tables

Creating cross tabulation tables
The values revealed in a GT can be cross tabulated by combining them withinformation such as respondents' gender, age, region, and other questions.

Creating cross tabulation tables andtabulation tables with graphs/charts

1
From the menu screen, select [Cross/Charts].

2[Setting the Banner 2 Variable]
Select the banner variable you wish to crosstabulate, and set it to [Banner 2].

Processing raw data

3
[Setting the
Tabulation Target Variable]
Select the target analysis variable you wish to
cross tabulate, and set it to [Stub].
A preview of what will be produced after variable
export can be checked in the area in the blue box
in the picture.

Creating a free answer (FA) list

>>
>
<
<<

… Sets all variables as export variables

Sets only the selected variables as export… variables

Removes only the selected variables from… the set of export variables
Removes all variables from the set of… export variables

4

Variables can be searchedbased on[Variablee] and [Question].

By selecting a variable andpressing the [Question Info] button,
choice information for the variable
can be checked.

[Exporting a Cross Tabulation Table]
Press [Cross Tabulation] to export.

* Similarly, export your graph/chart by [Graph/Chart] button.

2-Way X tab Table
Importing data

11

KEYPOINT
Parts that differ from the total on a crosstabulation table or graph/chart
are color-coded. The default
setting is to apply color coding
when N is 30 or greater.

The export format of a cross tabulation table can be selected.

Creating GT (simple tabulation) tables

Changing the export format ofcross tabulation tables

Creating cross tabulation tables andtabulation tables with graphs/charts

1[Tabulation Option]
From the menu screen, select [Cross/Charts] and thenselect the [Tabulation Option] tab.

2
[Export Setting]
For a cross tabulation table, [One Cross Table Per Sheet] or [Multiple Cross Tables Per Sheet] can be selected as the export
format. Additionally, the type of table to be exported can be selected from N% Table, N Table and %Table.

[Exporting a Cross Tabulation Table]
Press [Cross Tabulation] to export your cross tabulation table with export instruction.

One Cross Table Per Sheet

Sheets are split based on the number of stubs andexported.

Processing raw data

3
Multiple Cross Tables Per Sheet

Tables are split based on the number of stubs andexported.
Creating a free answer (FA) list

[Simultaneous Tabulation Feature for Cross Tabulation Tables]
Multiple settings can be saved by using multiple Tabulation Tabs.
Additionally, the tabulation tabs to be executed can be selectedwith the [ ][×] toggle.

Importing data

KEYPOINT

12

Creating GT (simple tabulation) tables

Setting the narrowing down ordivided output of cross tabulation tables
As with GT tables, cross tabulation tables can be exported to multiple files basedon filtering and narrowed down criteria.

Creating cross tabulation tables andtabulation tables with graphs/charts

From the menu screen, select [Cross/Charts] andthen select the [Filter Setting] tab.

[Setting the Filtering Criteria]
To set the filtering criteria, enter the criteria andother information based on the same procedures
described in "Creating GT tables by narrowing
down respondents based on certain criteria" onpage 8Processing raw data

[Exporting a Cross Tabulation Table]
Press [Cross Tabulation] to export a table filteredaccording to the specified criteria.
The filtered criteria will be displayed in the INDEXof the cross tabulation table once filtering criteria
are specified.
* [Filter Setting : ON] is displayed at the bottom left of thescreen.

Creating a free answer (FA) list

[Setting criterion variables]
Criterion variables are specified in the same way
as described in "Exporting GT tables that havebeen narrowed down as multiple files (Criterion
Variable)" on page 9[Exporting a
Cross Tabulation Table]
Press [Cross Tabulation] to export multiple tablefiltered according to the specified criteria.
Importing data

13

The filtered criteria will be displayed in the INDEXof the cross tabulation table once filtering criteria
are specified.
* [Criterion Variable to Divide Output : ON] is displayed at thebottom left of the screen.

A cross tabulation table with graphs/charts can be created with the sameprocedures as "Creating cross tabulation tables."Creating GT (simple tabulation) tables

Creating a cross tabulation tablewith graphs/charts

Creating cross tabulation tables andtabulation tables with graphs/charts[Setting a Cross Tabulation
Table with Graphs/Charts]
For a tabulation table with graphs/charts, set
the banner 2 and stub respectively with thesame procedures described in "Creating
cross tabulation tables" on page 11[Exporting a Cross Tabulation
Table with Graphs/Charts]
Press the [Graph/Chart] button to exporttables with graphs/charts.

Processing raw data

When the Stub is an SA (Single Answer), a
bar graph is exported to the right side of thegraph/chart.

Line Graph
Tabulation tablewith graph/chart

Creating a free answer (FA) list

[Setting Line Graphs]
A line graph can be exported for each axis
item in a tabulation table.
From the [Cross/Charts] button,
select the [Graph/Chart Options] tab.

Importing data

Set the item you wish to plot in a line graphon the right.
Press [Graph/Chart] button to export yourgraph/chart including a line graph.

14

Creating GT (simple tabulation) tables

Creating a 3-Way X tabs
In QuickCross, 3-Way X tabs that combine two banner variables on the axis can becreated.

Creating cross tabulation tables andtabulation tables with graphs/charts[Selecting the tabulation
method]Select [3-Way X Tab] from
[Tabulation Method].

1[Setting Banner 1]
Select the variable you wish to set to theoutside of the cross tabulation table bannerand set it as [Banner 1].

Processing raw data

2
[Setting the Banner 2
Variable]
Select the variable you wish to set to theinside of the cross tabulation table bannerand set it as [Banner 2].

Creating a free answer (FA) list

3
[Setting the Tabulation
Target Variable]
Select the target analysis variable on the
cross tabulation table and set it to [Stub].
A preview of what will be produced after
variable export can be checked in the blue
bordered area.

4

One Cross Table Per Sheet

Banner 1

Banner 2

Importing data

Exporting a Cross
Tabulation Table]
Press [Cross Tabulate] or [Graph/Chart]
button to export a 3-way X tabulation tableor tables with graph/chart.
* Tables can also be exported in the Multiple Cross Tables Per Sheet format.
For information about how to configure export settings and the layout of the Multiple Cross
Tables Per Sheet format, see "Exporting a Cross Tabulation Table" on page 1215

Creating GT (simple tabulation) tables

With data processing, data can be processed such as to compile all the choices

Creating cross tabulation tables andtabulation tables with graphs/charts

Processing raw data
within a question or compile separate questions as one variable.
By performing data processing (Create New Variable),

page 17[RECODE] to summarize choices

page 19[INTEGRATE] to combine choices

page 21[CLASS] to categorize numerical data

page 23[MCONVERT] to combine the same choices

page 25[Add Subtotals] to add subtotals

page 27[Count for Mean] to calculate the mean number of checks
in a multiple answer

page 29

Data processing FAQ

page 31

Creating a free answer (FA) list

Performing data processing

Processing raw data

data can be viewed from various perspectives (Banners).

Importing data

The images shown in this manual may differ from those at the time of release.

16

Creating GT (simple tabulation) tables

Performing data processing
You can change the format of the data, such as modifiying the data split to
five-year age increments or tabulating it in ten-year age increments, and combine
multiple variables into a new variable.

Creating cross tabulation tables andtabulation tables with graphs/charts

From the menu screen, select [Data Processing].

1[Processing Type]
Select [Processing Type] and[Processing Method] based on the purpose.
> Press [Create Process].

Processing raw data2
You will then go to the Data Processing
Register Page.

Creating a free answer (FA) list

Types of Data Processing (Processing Type)Create New Variable

Revise Data

Create a new variable using the processing methods,
such as RECODE, INTEGRATE and CLASS.

Sets criteria to revise the data.

Processing Method
RECODE… Compiles the choices of SA or MA answers

INTEGRATE … Combines multiple variables

Importing data

CLASS

… Categorizes numerical data

COUNT

… Calculates count for mean of an MA question

multiple of the same choice into
MCONVERT … Combines
an MA question
ADD
JOINT
MTOS
GROUP
COMPUTE

17

Adds up the variables of an… MA or SA question… Combines multiple variables… Converts from MA to SA

Determines Max, Min, Mean and… Sum of Values for numerical values… Performs the four arithmetic operations

ExcludeSets the tabulation base for each variable.

Delete Cases
Deletes cases you do not wish included in the data.

Output List
Lists cases that match the criteria.

Creating GT (simple tabulation) tables

3[Data Processing]On the open screen, set the source variable
used for data processing and the variablename used for the new variable, as well as
choices, criteria and so on.

KEYPOINT
Batch pasting canbe performed.
20s
30s
40s
50s

=
=
=
=

3-4
5-6
7-8
9-10

4

Creating cross tabulation tables andtabulation tables with graphs/charts

Choices and criteria can be pasted
from another Excel file or text file.

Set the new variable criteria on each dataprocessing page and press [Execute].

When configuration of the data processing
settings is complete, return to the processing
top page.
Check that the data processing you createdis reflected in the [Data Processing List] andpress the [Execute] button.

Creating a free answer (FA) list

At the bottom of the item columns for GT tabulation and cross tabulation, the new variables resulting from data processing
are added.

Processing raw data

5

Importing data

18

Creating GT (simple tabulation) tables

Create New Variable[RECODE] to summarize choices
You can compile the choices for source variable (SA, MA) answers to create a newvariable.

Creating cross tabulation tables andtabulation tables with graphs/charts

Usage Example: Creating data by age group in ten-year increments
Compile the source variable (AGEID) which is in five-year increments and create a new variable in ten-yearincrements.

Source Variable

New variable

Numbers from "age 20 - 24" and "age 25 to 29" arecombined to create the "20-29" group.
Processing raw data

1
[Create New Variable]

Creating a free answer (FA) list
Importing data

19

From the menu screen,
select [Data Processing] > Select [Create New
Variable] as [Processing Type] and [RECODE]
as processing method,and press [Create Process].

KEYPOINT[Convenient feature when processing
matrix setting]
When the first item in a matrix question
has been selected as the source
variable, by putting a check beside[Repeat Setting], the same RECODE
processing can be performed on theremaining matrix items.

Creating GT (simple tabulation) tables

2[RECODE Registration]
Select the source variable of the new variable that will be created.

3
Select the [Answer (Ans) Type] of the newvariable.

Creating cross tabulation tables andtabulation tables with graphs/charts

Enter the [Question] that will be the title ofthe new variable as needed.

4
When the choice you wish to compile isselected and [>] is pressed, the operator andcriteria are automatically entered.
The operator can be chosen from [=] (equalto) and [<>] (not equal to).
Enter the labels of the choices for the newvariable.

5
Press [Save].

Processing raw data

* Choices and criteria can be pasted from another Excel
file or text file.

Batch pasting
can be performed.

KEYPOINT
Creating a free answer (FA) list

[Summarize choices]
By using the [Summarize choices]feature, scaled questions such as besummarized and easily created.

Importing data

20

Creating GT (simple tabulation) tables

Create New Variable[INTEGRATE] to combine choices
Create a new variable by combining two or more variables.
Up to ten variables can be combined into one variable at one time.

Creating cross tabulation tables andtabulation tables with graphs/charts

Usage example: A user wishes to create data by gender and age.
A new variable according to age group is created by combining the gender and age.

Source Variable

New Variable

Processing raw data

1
[Create New Variable]

Creating a free answer (FA) list
Importing data

21

From the menu screen, select [Data Processing].
From [Processing Type], select [Create New Variable]
For the Processing Method, select [INTEGRATE] and press [Create Process].

Creating GT (simple tabulation) tables

2[Registering INTEGRATE]
Select the source variable that corresponds tothe new variable that will be created.
Set the criteria horizontally. Up to ten criteria
can be specified.
Choose how to combine variables with "AND"or "OR" operators.

Enter "New Variable" as the variable name, andenter the question.
Select the [Ans type] as needed.
(The default setting is MA)

Batch pasting
can be performed.

Conditional expressions
can be pasted into
multiple columns at once.

* If the name for a [New variable] is not set,
it will be automatically set during registration.

4

Creating cross tabulation tables andtabulation tables with graphs/charts

3Enter the labels of the choices for the newvariable.
Processing raw data

* Choices can also be pasted from another Excel file ortext file.

5
Enter the criteria value for the choice.
When the Criteria Value is used, it can be
set while looking at the choice of the source
variable.

Creating a free answer (FA) list

6
Press [Save].

KEYPOINT[Criteria Value]
Select a choice (source variable) on
the left side, set the criteria value forthe new variable on the right side, andpress [Register].
The operator can be chosen from [=](equal to) and [<>] (not equal to).

Criteria will be
combinedhorizontally.
Importing data

22

Creating GT (simple tabulation) tables

Create New Variable[CLASS] to categorize numerical data
Summarize the source variables of Numerical Value Answer (N) and creates a newvariable for SA.

Creating cross tabulation tables andtabulation tables with graphs/charts

Usage example: A new variable that is summarized into the SA choices iscreated for the values (monetary amounts) entered for Q20.

Source Variable

New Variable

The N(number) and %(percentage) that correspond to each choice are filled in.

Processing raw data

GT Table1[Create New Variable]

Creating a free answer (FA) list
Importing data

23

From the menu screen,
select [Data Processing] > Select [Create
New Variable] as [Processing Type] and[CLASS] as processing method, andpress [Create Process].

KEYPOINT[CLASS shortcut function]* The CLASS shortcut function is aconvenient way to easily create an
age variable in ten-year increments.
When "AGE" is selected as thesource variable, the setting forchoices in ten-year increments as
a new variable isautomatically displayed.

KEYPOINT
Even when numerical data isviewed in a GT table, it is notpossible to ascertain which
category has what number
and what its percentage is.
By performing CLASS, these
are converted into choices,
allowing the results to be
confirmed as N (number)and % (percentage).

[Registering CLASS]
Select the source variable that corresponds tothe new variable that will be created.
Enter the [Question] that will be the title of the
new variable as needed.

3

Batch pasting can be
performed.

4

Creating cross tabulation tables andtabulation tables with graphs/charts

Select the corresponding button from "or over,""greater than," "or under" and "less than".

Creating GT (simple tabulation) tables

2

Enter the numbers for the [Lower Limit] and[Upper Limit] of each choice and input thelabels for the choices of the new variable.

* Choices and Lower Limit / Upper Limit values can also
be pasted from another Excel file or text file.

5

Processing raw data

If the numbers are entered first and [Setchoice labels] is used, the choice labels canbe easily input.

Press [Save].

[Set choice labels]
In addition to choice labels, the specified
units (age in years, Japanese yen, etc.)
can be inserted at the end of eachchoice at one time.
For numbers can also be set.

Creating a free answer (FA) list

KEYPOINT

Importing data

24

Creating GT (simple tabulation) tables

Create New Variable[MCONVERT] to combine the same choices
Create a new MA variable by combining the source variables with the same numberof responses with the same choices.

Creating cross tabulation tables andtabulation tables with graphs/charts

Usage example: Compiling the choices for matrix questions in one table.
Compile choices 1 and 2 of the source variable and create a new variable in MA format.

Source Variable

New Variable

Processing raw data

The cases that responded "agree" or "somewhat agree" (Top1 + Top2) can becompiled and viewed in MA format.
* No Answer includes respondents who "did not select either Top1 or Top2" for each case.

1[Create New Variable]

Creating a free answer (FA) list
Importing data

25

From the menu screen, select [Data Processing] > Select [Create New Variable] as [Processing Type] and [MCONVERT] asprocessing method, and press [Create Process].

Left on the window ... selection of source variables
Creating GT (simple tabulation) tables

2[Registering MCONVERT]From the [Variable of reference] pulldown,
select the first item from the source processing
variable.

3

Creating cross tabulation tables andtabulation tables with graphs/charts

After compiling, select the items that will bechoices under [Entry variable] and set them on
the right with [>].
Select the [Choice Criteria] that will be compiledin the same way and set them on the right.

Right on the window ... setting of new variables

Enter the [Question] that will be the title ofthe new variable as needed.

Processing raw data

4
* The questions and choices for the variables selectedwith [Variable of reference] will be automatically entered.

Press [Save].

KEYPOINT

Creating a free answer (FA) list

5With MCONVERT,even if the questions
are different,as long as the choices are
the same,they can be compiled as one
variable.
Importing data

26

Creating GT (simple tabulation) tables

Useful Functions[Add Subtotals] to add subtotals
Subtotals can be easily added to SA and MA variables from Question Setting.
Usage example: Adding Top2 and Bottom2 subtotals to choices.

Creating cross tabulation tables andtabulation tables with graphs/charts
Processing raw data

1
[Registering variables]
From the menu screen,
select [Question Setting].
Double-click the variable you wish to add asubtotal to, or press [Edit].

Creating a free answer (FA) list
Importing data27

Place a check beside [Add Subtotals] and press
the [Subtotal Setting] button.

[Setting subtotals]
When the choice you wish to compile is selected
and [>] is pressed, the operator and criteria areautomatically entered.
Modify the label of the choice as needed andpress [Save].

4

Processing raw data

When adding a subtotal from the pulldown
menu at the bottom left, choose Top andBottom values and press the [Add] button.

Creating cross tabulation tables andtabulation tables with graphs/charts

3

Creating GT (simple tabulation) tables

2

As you return to the previous screen bypressing [Save], press [Close] at the bottom
right.

If two types of subtotals are set, "S/2" isappended.
For matrix questions, when a subtotal is set for
the topmost item, it is automatically reflected
for all items.

Creating a free answer (FA) list

* "S/" will be appended to the left side of the variable namefor questions with subtotals set.

KEYPOINT

Importing data

The same values can be obtained evenif subtotal processing is performed with
RECODE.
For subtotals created with question
setting, the subtotals are reflected in
GT and cross tables, but not in the raw
data.
When it is necessary to reflect thesubtotals in the raw data, set RECODE
as explained on page 19 - 20

28

Creating GT (simple tabulation) tables

Useful Functions[Count for Mean] to calculate the mean
number of checks in a multiple answer
Calculate the mean number of choices selected in a Multiple Answer (MA)question.

Creating cross tabulation tables andtabulation tables with graphs/charts

Usage example: Calculating the mean value (no. of choices responded to) in Q1.

This allows you to determine the number of answers that have been selected on average.

Processing raw data

1
[Registering variables]
From the menu screen,
select [Question Setting].
Double-click or press [Edit] for the variable
you wish to add Mean Value (No. of choices
responded) to.

Creating a free answer (FA) list
Importing data

29

Creating GT (simple tabulation) tables

2[Setting Count for mean]
Place a check beside the choice you wish to
calculate count for mean for.
* When you wish to exclude respondents who selected
exclusionary choices such as "None of the above apply"
from the number used to calculate the mean ...
Remove the check from the corresponding choice andplace a check beside [Count: Restrict base to the
respondents that selected the choice specified below].

Press [Save].

Remove the checks fromchoices to be excluded
from calculation.

Creating cross tabulation tables andtabulation tables with graphs/charts

3

4* "C" will be appended to the left side of the variablename for questions with count for mean set.

Processing raw data

As you return to the previous screen bypressing [Save], press [Close]
at the bottom right.

Count for mean created with Question
Setting is reflected in GT and cross tables,
but not in the raw data.
Creating a free answer (FA) list
Importing data

30

Creating GT (simple tabulation) tables

Data Processing FAQ
1

How do I save the processing and export settings of a new variable?

From the menu screen, press [Save].

2

How do I edit a new variable that was previously processed (registered)?

Creating cross tabulation tables andtabulation tables with graphs/charts

When modifying processing criteria or texts such as questions or choices, enter the processing screen by
double-clicking on the corresponding variable from the [Data Processing List] or by pressing the [Edit] button to
the right of the variable.
You can make changes through the same procedures as regular processing, and press Register > Execute tomodify.(* Ans type cannot be changed)3

How do I change answer type (Ans type)?

To change Ans type once it has been set, it is necessary to create the variables again. When you press [Copy]
from the Data Processing List screen to copy variables, Ans type can be edited with the processing of the copy
source inherited.
Modify Ans type and press [Register]. (This can also be created from scratch)

4

How do I delete processing that has been created for individual variables?

On the Data Processing List screen, place a check beside [Delete from question setting] and press [Delete] todelete for each variable. Deletion can also be performed from [Question Setting].
Processing raw data

2
3
4

5

How are variable names regularly labeled?

When multiple processing variables have been created from the same variable, they are labeled as NQ●, N1Q●,
N2Q●, and so on. (* ● is the question number of the source variable)

Creating a free answer (FA) list

6

Paste the variable name you wish to assign inthe [New variable] column. If the name is not
specified, it will be automatically input
according to the rules shown in 5.

7

What is "Based On Total
Respondents"?

This is a function to calculate the percentage ofthe number of total respondents, including
respondents who did not answer thecorresponding question, as a parameter.

8
Importing data

31

How do I assign a custom variable name?

What are "No Answer" and "Excluded"?

The percentage of "No Answer" is included in the population, but "Excluded" is not.
Example of No Answer ...
When none of the criteria apply, or when the respondent did not answer (for an optional question, etc.), the datais dropped as "No Answer."
Example of Excluded ...
For example, if only respondents who answered "Know" to a question about awareness in Q1 are asked Q2,
those respondents who answered "Don't know" on Q1 will be recorded as "Excluded" for Q2.

Creating GT (simple tabulation) tables
Creating cross tabulation tables andtabulation tables with graphs/charts

Creating a free answer (FA) list
FA List is a feature that allows the results of open-ended questions

As an additional variable, it is possible to include closed questions' responses
at the same time.

page 33(Criterion variable) to narrow down a free answer (FA) list
to certain criteria and divide it into sheets

page 34

Creating a free answer (FA) list

Creating a free answer (FA) list

Processing raw data

to be exported as a table.

Importing data

The images shown in this manual may differ from those at the time of release.

32Creating GT (simple tabulation) tables

Creating a free answer (FA) list
A free answer (FA) list can be created in Excel format.
Usage example: Determining the FA responses for Q11 and the "gender" and "age" attributes linked to those
responses.

Creating cross tabulation tables andtabulation tables with graphs/charts

Free answer (FA) variables

Additional Variables(Allows attributes and responses linked to an FA variable to be checked)

Processing raw data

1
From the menu screen, select [FA List].

Creating a free answer (FA) list

2
Under [FA variable] select the variables you
wish to create lists for, and set them on theright by pressing [>].
Select the variables you wish to add to the"Free Answer List" from [Additional Variable],and set them on the right by pressing [>].
* Up to 30 variables can be set for each.

Importing data

33

3
When [Execute] is pressed, the FA List will be
exported.

This allows you to filter respondents according to certain criteria and export
the results divided into multiple sheets.

When you wish to divide sheets based on the choices for specific variables (for example when you want to divide
sheets for male and female respondents), the sheets can be output using [Criterion variable].

Set the variable you wish to filter in [Criterion
variable].

Processing raw data

1

Creating cross tabulation tables andtabulation tables with graphs/charts

Usage example: Checking free answers in Q11 separately for "Male" and "Female" respondents.

Creating GT (simple tabulation) tables(Criterion variable) to narrow down a free answer (FA)list to certain criteria and divide it into sheets

2

3
Pressing [Execute] will divide and export sheets
based on the filtered variable(s).

Creating a free answer (FA) list

Set the FA variables and additional variables
using the same procedures described in"Creating a free answer (FA) list" on page 33

KEYPOINT

Additional variable ... information is added to theright side of the free answers (for choices, thechoice number is appended)

Importing data

[Difference between criterion variable andadditional variable]
Criterion variable ... sheets are divided

34

Creating GT (simple tabulation) tables

Creating cross tabulation tables andtabulation tables with graphs/charts

Processing raw data

Creating a free answer (FA) list

Importing data

35

Creating GT (simple tabulation) tables
Creating cross tabulation tables andtabulation tables with graphs/charts

Importing data
CSV and TSV can be added to QuickCross and tabulated.

page 37

The data import guide to importing data

page 38

Data import operating instructions

page 39

Creating a free answer (FA) list

What is data import?

Processing raw data

Text data in formats such as Excel,

Importing data

The images shown in this manual may differ from those at the time of release.

36

Creating GT (simple tabulation) tables

What is data import?
Text data in formats such as Excel, CSV and TSV can be added to QuickCross andtabulated.

Creating cross tabulation tables andtabulation tables with graphs/charts

Main file formats that can be imported

Excel(files with the "xlsx" extension)

CSV Format(files with the "csv" extension)

TSV Format(files with the "tsv" extension)

Data from Microsoft's spreadsheet
softwareText-based data withfields separated by commas

Text-based data withfields separated by tabs

Response types that can be imported
Processing raw data

SA (Single Answer), MA (Multiple Answer), N (Numerical Value Answer) and FA (Free Answer) formats can be imported.
* For MA, "MA 01 Format" or "MA Comma Separated in a Cell Format"

MA (MA 01 Format)

Structure where "1" corresponds to "applies" and "0"corresponds to "does not apply."* The diagram on the right shows when there are two choices.
When there are three or more choices, the data is lined up on the right.

Creating a free answer (FA) list

MA (MA Comma Separated in a Cell Format)

Consists of information in a single cell separated
by commas* The diagram on the right shows when there are two choices.

Importing data

37

The procedures for importing data are broadly split into seven steps.
Check the pages describing each flow for details on the operations.

3. Opening the data to be imported into the QC file

Page 39-(3)4. Selecting detailed settings for the data
to be imported

Page 40-(4)5. Specifying key variables to be linked /checking the data countPage 40-(5)6. Selecting data columns to be imported

Page 41-(6)7. Entering the necessary information in[Question setting]

Page 41-(7)Importing data

Page 39-(2)Creating a free answer (FA) list

2. Opening QuickCross

Processing raw data

Page 39-(1)Creating cross tabulation tables andtabulation tables with graphs/charts

1. Preparing external data

Creating GT (simple tabulation) tables

The data import guide to importing data

Complete38

Creating GT (simple tabulation) tables

Data import operating instructions

1[Preparing external data]

Creating cross tabulation tables andtabulation tables with graphs/charts

1. QC file (File 1)
2. Prepare the data to be imported (File 2).
See "What is data import?" on page 37
for information about the file formats for the data thatis prepared.
For File 2, the importing of data will go smoothly if
choices are prepared in an Excel or text file after
checking "Ans type" and "Number of choices"in advance.

KEYPOINT

Processing raw data

Always include titles in the first line of data to
be imported.
As the leftmost sheet will be loaded when
external data is imported, place the data in
the leftmost sheet and save it.

2[Opening QuickCross]

Creating a free answer (FA) list

Open the QC file that external data will be
imported into, and select [Data Merge] >[Data Import].

3[Opening the data to be imported
into the QC file]
Importing data

39

"File 1" specifies the QC file that is open.
Select the data to be imported from [Open] for[File 2] and press [Next].

Creating GT (simple tabulation) tables

4[Selecting detailed settings forthe data to be imported]
When importing Excel data ...
Skip the process shown in (4)When importing a text file ...
Select [Character code], [Delimiter] and [String
quotes].

Select the delimiter based on the format of the datathat is being used.
If not specified, leave the default setting for string
quotes as ["] and press [Next].

5

What is a delimiter?
When a file is saved in text format, the delimiter is used
when separating the fields (variables). Characters such ascommas, tabs and spaces are often used.

A. Numbers exactly matched

Processing raw data

Specifying key variables to be linked/ checking the data countSet the variable that will serve as the key that links
to QC file and the data to be imported. Always
specify Key 1 to prevent the key variablefrom being mistaken.
* Two variables can also be specified as the key.

The data count is
the overlapping
part

There are two data import patterns

A ... When the files are an exact match

Creating a free answer (FA) list

When the QC file and the data to be imported are an exact
match, the left and right sides of the circle are "0," with the data
count displayed in the overlapping part.
The circle on the left side is the source QC file that was loaded,
and the circle on the right is the data to be imported.

Creating cross tabulation tables andtabulation tables with graphs/charts

The character code is usually "SJIS," but if the text
shown in the preview column is garbled, change it
to "UTF-8" from the pulldown menu.

B. Not an exact match

B ... When the files are not an exact match
When the QC file and the data to be imported are not an exact
match, the number of data records that did not match are shownon the left and right sides of the circles respectively.

22 cases exist in the importdata but are not present in
the QC file

Importing data

79 cases exist on the
QC file side but are notpresent in the data to
be imported

40

Creating GT (simple tabulation) tables

6
Selecting data columns to be imported
Put a check in the data columns to be imported.
When the data to be imported includes MA questions,based on the data format , select “MA 01 Format” or“MA Comma Separated in a Cell” based on the data
format.
* Seepage 37

for details on the MA data format.

Creating cross tabulation tables andtabulation tables with graphs/charts

If there are identifying characters that you do not wish
to include in the tabulated population, enter them as[not applicable characters.] ("*" in the example in the
diagram on the right)

7Entering the necessary informationin [Question setting]Enter the following information for each variable.
Enter the variable name of the data
to be imported

Processing raw data

Variablename…

Ans type

Select from "SA", "MA," "N" or "FA"… depending on the data to be imported.

* Variable names that consist only of numbers
or which include symbols cannot be used.

Number ofEnter the number of choices in the…
choices
data to be imported

Creating a free answer (FA) list

Table
Heading… Optional setting

Question…

Choicewording

Paste the choices that have been
prepared in advance to the "Choice…
wording" (you can also input the
choices directly)

Explanatory text that describes thedata to be imported* When the response format is "N" or "FA," "Number of choices" and"Choice wording" do not need to be entered.

Example: The information entered in [Question Setting] is displayed in a GT table as follows.

Variable name

QuestionAns type
Importing data

41

Choice wording

Batch pasting can be
performed.

Entering the necessary information in [Question setting]

When there are multiple variables to be imported,
after the variable are set , press [Next data] after
the variables are set, and press [Execute] once all
the question settings are completed.

Batch pasting can be
performed.

Creating cross tabulation tables andtabulation tables with graphs/charts

For MA (MA 01 Format)
When Ans type is the MA and 01 format, enter therange (number of rows) for one variable in[# of choices].

Batch pasting can be
performed.
Processing raw data

* In the case of the diagram on the right, as the number of rows
is "2," the number of choices is also 2.

Creating a free answer (FA) list

For N or FA* When the response format is "N" or "FA,""Number of choices" and "Choice wording" do notneed to be entered.

Creating GT (simple tabulation) tables

For SA or MA (MA Comma Separated in a Cell)

Importing data

42

Entering the necessary information in [Question setting]
Creating GT (simple tabulation) tables

Once question setting for all the data to be imported is complete, press [Execute].
When "Do you want to execute Data Import?" is displayed, press [Execute].

Creating cross tabulation tables andtabulation tables with graphs/charts

When the import is complete, [Completed Data Import] will be
displayed.
Variables imported using the external data function are shown as"Imp" (=Import) under [Question Setting] from the QuickCross menu
screen.
Check that the imported data is properly reflected in the GT tableand data browsing.

Processing raw data
Creating a free answer (FA) list
Importing data

43

To tabulate imported variables, refer to "Creating GT (grand total) tables" on page 4
and tabulation tables with graphs/charts" on page 10

and "Creating cross tabulation tables

Creating GT (simple tabulation) tables

Creating cross tabulation tables andtabulation tables with graphs/charts
Processing raw data

Creating a free answer (FA) list

Importing data

Please also use our basic site for tabulation as areference.
https://www.macromill.com/tabulation/faq/

ver8.1_20210618

44