# Insert Ready-Made Formula(s) Menu

Related Online Training modules | |
---|---|

Changing a Pick Any to a Pick One Question | |

Combining All Combinations of Categories | |

Mathematical Functions | |

Template For Replication | |

Adding a 'None of These' | |

Crosstabs with Pick One - Multi | |

Generally it is best to access online training from within Q by selecting Help > Online Training |

Related Videos | |
---|---|

Part 4 of Creating and Modifying Variables (Video) |

## Contents

- 1 Pick Any -> Pick One
- 2 Questions -> Pick Any with All Combinations
- 3 Pick One - Multi -> Pick Any (by Category)
- 4 Pick One - Multi -> Pick Any (Flatten)
- 5 Date -> Moving Average
- 6 Pick Any Question -> Pick Any Question with 'None of these'
- 7 Merge Questions
- 8 Mathematical Functions
- 9 Use as Template for Replication

## Pick Any -> Pick One

Automatically constructs a categorical variable from selected variables (the selected variables should generally be binary variables with values of only 0 and 1).

For example, if you have three binary variables: Aged 18 to 24 (Yes/No), Aged 25 to 34 (Yes/No), Aged 35 or more (Yes/No), they can be converted into a single categorical Age variable (with three categories corresponding to the original binary variables).

This newly constructed question consists of a constructed Categorical Variable and can be edited and manipulated in the same ways as any other categorical variable.

## Questions -> Pick Any with All Combinations

Converts one or more variables into binary variables. For example, if you select an age variable containing six categories, the result will be a new question containing six binary variables, each corresponding to one of the age categories. If you select age and gender, you would create 12 variables (e.g., “Male 18 to 24”, “Female 18 to 24”, “Male 25 to 34”, etc.).

## Pick One - Multi -> Pick Any (by Category)

Converts identically structured categorical variables into netted binary variables.

Some data files have Pick Any variables stored as Pick One – Multi questions (sometimes called *Maximum Multi* or *Max-Multi* format). That is, rather than having multiple variables each taking a value of 0 or 1, they are instead structured so that the first variable indicates the first response given by respondents to a multiple response question, the second indicates the second response, and so on.

An alternative approach to achieving the same outcome is to change the Question Type from Pick One – Multi to Pick Any - Compact.

## Pick One - Multi -> Pick Any (Flatten)

Creates a new **Pick Any** question which has each column nested under each row of the current Pick One - Multi question. This flattens the two dimensional question into one dimension and allows you to crosstab it with others.

## Date -> Moving Average

Opens the Construct Moving Average dialog box, which uses the selected date variable to construct a new variable that allows you to view moving average crosstabs.

See Time Series Analysis for other and more sophisticated methods of computing moving averages.

## Pick Any Question -> Pick Any Question with 'None of these'

Creates a copy of the current **Pick Any** or **Pick Any – Grid **question and adds a 'None of these' category to ensure the NET adds up to 100%. Use this if the NET does not add up to 100% because you are missing a category for respondents that did not choose any of the other categories.

## Merge Questions

Merges two or more Pick Any and/or Pick One questions. Values/variables with the same labels will be combined. Example use: when a Pick One question changes into a Pick Any, but you still have data from old waves that use the Pick One question. This is primarily designed for situations where one group of respondents sees one question and a different group sees another; respondents that see both questions will be given a value of -99.

## Mathematical Functions

Automatically creates a variable that is the sum, minimum, maximum, average, standard deviation or variance of the selected input variables. Can also be used to find or count specific values in the input variables.

Tip: If you select multiple groups of variables with identical labels then Q can combine each matching set.

## Use as Template for Replication

Opens the Template Replication dialog box, which uses the selected formula variable as a template to construct new formula variables.