# choices

Document Sample

```					                                              Simple Searches in Choices 3
The Choices 3 database is available on 1 computer in the Business Library. If someone is using the computer for other purposes, the
reference librarian can ask them to move to another computer.

Demographic Information - Click on the + by Lifestyle (Demographics) in the left column to display the available choices.

RUN ANALYSIS

CREATE                          CREATE
COLUMNS                          ROWS

Example: You want to know which snacks are most popular with people of various ages.

Columns

   Under the Lifestyle (Demographics) heading, click Demographics (Personal Information)
   Click Age in the left column
   Click on the age groups that you want to include
   Click the     symbol to put them into columns (see the CREATE COLUMNS arrow above)

Rows

   Under the Food – Snack/Dessert heading, choose Popcorn Products and then Popcorn Products - Brands
   Click on the brands in the center box that you want to include
   Click the     symbol to put them into rows (see the CREATE ROWS arrow above)

Run the Analysis
Click the RUN ANALYSIS icon         shown in the example above.
Your results will look something like this:

Interpreting the Results

VERT%

    Of all 18 to 24 year olds (moving vertically down the column), 4.63% eat Cracker Jack most often.
    Of all 25 to 34 year olds, 3.41% eat Cracker Jack most often.
    Of all 35 to 49 year olds, 3.97% eat Cracker Jack most often.

HORZ%

    Of all people who eat Cracker Jack most often (moving horizontally)
o 14.9% are age 18 to 24
o 17.2% are age 25 to 34
o 31.8% are age 35 to 49
    Of all people who eat Crunch’n Munch most often
o 18.2% are age 18 to 24
o 21.9% are age 25 to 34
o 29.4% are age 35 to 49

The Index number is the easiest to interpret. 100 represents the national average.

    The index of 142 in the AGE 18 - 24 column for Crunch’n Munch, means that 18 to 24 year olds are 42% more likely than the
average population to eat this snack (subtract 100 from 142)
    The index of 93 in the AGE 35 - 49 column for Crunch’n Munch, means that 35 to 49 year olds are 7% less likely than the
average population to eat this snack (subtract 93 from 100)

Click the Excel icon near the upper right corner. You can print or save to the desktop and email it to yourself.

EG 8/09
Creating Simple Filters in Choices 3
Filters allow you to narrow the scope of the group you are researching. If you only want to study women in various age groups, and
you want to compare them to all women, you can create a simple filter.

(But if you want to compare these women to the total population, men and women, you need to create a complex column heading,
not a filter.)

Simple Filters - If you want to know which snacks are most popular with women of various ages:

   Under the Lifestyle (Demographics) heading, click on Demographics (Personal Information)
   Click Gender in the left column
   Click Female in the center box
   Click on the little yellow guy   above the center box (see the SIMPLE FILTER arrow below)
   Click Age in the left column
   Click on the age groups that you want to study
   Click the     symbol to put them into columns (see the COLUMNS arrow below)
   Under the Food – Snack/Dessert heading, choose Popcorn Products and then Popcorn Products - Brands
   Click on the brands in the center box that you want to include
   Click the     symbol to put them into rows. (see the ROWS arrow below)
   Click the RUN ANALYSIS icon          (see below)

RUN ANALYSIS

CREATE
CREATE
SIMPLE FILTER
ROWS

CREATE
COLUMNS
Your results will look something like this:

Notice that the word WOMEN (the filter) doesn’t appear anywhere on this screen. You will have to remember that you created the
filter.

VERT%

    Of all 18 to 24 year old women (moving vertically, down the column), 4.63% eat Cracker Jack most often.
    Of all 25 to 34 year old women, 3.41% eat Cracker Jack most often.
    Of all 35 to 49 year old women, 3.97% eat Cracker Jack most often.

HORZ%

    Of all women who eat Cracker Jack most often (moving horizontally):
o 14.9% are age 18 to 24
o 17.2% are age 25 to 34
o 31.8% are age 35 to 49
    Of all women who eat Crunch’n Munch most often,
o 18.2% are age 18 to 24
o 21.9% are age 25 to 34
o 29.4% are age 35 to 49

The Index number is the easiest to interpret. 100 represents the national average for women.

    The index of 142 in the AGE 18 - 24 column for Crunch’n Munch, means that 18 to 24 year old women are 42% more likely
than all women to eat this snack
    The index of 93 in the AGE 35 - 49 column for Crunch’n Munch, means that 35 to 49 year old women are 7% less likely than
all women to eat Crunch’n Munch (subtract 93 from 100)

Click the Excel icon near the upper right corner. NOTE: When you use a filter, there will be 2 sheets, Base 1 and Base 2 at the bottom
of the screen. The Base 1 sheet has the results without the filter! You must click on the Base 2 sheet to see the same results that
you had on the Crosstab screen. You can print, or save to the desktop and email it to yourself.

EG 8/09
Creating Complex Filters in Choices 3
Use a complex filter if you want to study a specific population, such as women in various age groups who are married, AND you only
want to compare them to all married women (not all men and women).

(If you want to compare married women in various age groups to the total population, men and women, you need to create a
complex column heading, NOT a complex filter.)

CREATE
CREATE                       ROWS
COLUMNS

AND            OR                    CREATE COMPLEX FILTER

Example 1: You want to know which snacks are most popular with married women of various age groups.

Complex filter

   Under the Lifestyle (Demographics) heading, click on Demographics (Personal Information)
   Click Gender in the left column
   Click Female in the center box

   Click       near the top of the screen (see the ADD arrow)
   Click      near the bottom of the screen (see the AND arrow)
   Go back to Demographics (Personal Information)
   Click Marital Status in the left column
   Click Married in the center box

   Click       near the top of the screen again (see the ADD arrow)
   Click     near the bottom (not the top) of the screen (see the CREATE COMPLEX FILTER arrow)
Columns

   Under the Lifestyle (Demographics) heading, click Demographics (Personal Information)
   Click Age in the left column
   Click on the age groups that you want to include
   Click the      symbol to put them into columns (see the COLUMNS arrow above)

Rows

   Under the Food – Snack/Dessert heading, choose Popcorn Products and then Popcorn Products - Brands
   Click on the brands in the center box that you want to include
   Click the      symbol to put them into rows (see the ROWS arrow above)

Example 2: You want to study people who are either married OR engaged.

To create this complex filter:

   Under the Lifestyle (Demographics) heading, click Demographics (Personal Information)
   Click Marital Status in the left column
   Click Married in the center box
   Click       near the top of the screen (see the ADD arrow)
   Click        at the bottom of the screen (see the OR arrow)
   Go back to Demographics (Personal Information)
   Click Are you currently engaged?
   Click Yes in the center box
   Click       near the top of the screen (see the ADD arrow)
   Click       near the bottom (not the top) of the screen (see the CREATE COMPLEX FILTER arrow)

Run the Analysis
Click the Run Analysis icon     shown in the example above. A single asterisk * in your results means the projections are
relatively unstable and should be used with caution. Two asterisks ** means the projections are from thirty or fewer
interviews. These results are not sufficiently reliable to be used.

Click the Excel icon near the upper right corner. NOTE: When you use a filter, there will be 2 sheets, Base 1 and Base 2 at the bottom
of the screen. The Base 1 sheet has the results without the filter! You must click on the Base 2 sheet to see the same results that
you had on the Crosstab screen.

You can print, or save to the desktop and email the spreadsheet to yourself.
Creating Complex Column Headings in Choices 3
Create a complex column heading if you want to study a very specific population, such as women in various age groups, AND you
want to compare them to total population. (If you want to compare women in various age groups only to other women, and not the
total population, you need to create a complex filter, NOT a complex column heading.)

AND                              CREATE COMPLEX COLUMN

Complex column headings for women of various ages:

   Under the Lifestyle (Demographics) heading, click on Demographics (Personal Information)
   Click Gender in the left column
   Click Female in the center box
   Click     near the top of the screen (see the ADD arrow)
   Click       near the bottom of the screen (see the AND arrow)
   Under the Lifestyle (Demographics) heading, click Demographics (Personal Information)
   Click Age in the left column
   Click on an age group such as 18 to 24
   Click     near the top of the screen (see the ADD arrow)
   Click the   symbol near the bottom of the screen to create the column (see the CREATE COMPLEX COLUMN arrow)
   Repeat these steps to create another column for a different age group

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 4 posted: 10/26/2011 language: English pages: 7