Analysis Group

T

Name

Description

Analysis of Item relations

Q

Simple-matching similarity for single IID

Note: A matrix of all IIDs against each other would be very slow for larger datasets

Character analysis

Q

Character usage BY Item (crosstab)

Count of character states used for each character/item combination, special states treated as missing

Q

Character usage BY Item (list)

List version; use Excel pivot analysis to make a cross-tabulation

Q

Character usage BY Item, incl U,V,-,TE (crosstab)

Here the count of states includes the special states U,V,-, and TE

Q

Character usage BY Item, incl U,V,-,TE (list)

List version. General note: these queries are useful to check the completeness of character or item data

Q

Character usage cross tabulation (test scoring dependencies; U,V,- = missing)

Which combinations of characters are used how often in the items? 'U'/'-'/'TE' are counted as not used, 'V' as used//CHECK: CORRECT?.

Q

Character usage cross tabulation (test scoring dependencies; U,V,- = used)

Which combinations of characters are used how often in the items? 'U'/'V/'-'/'TE'' are counted as used.

Character cross tabulation

Q

Char-state usage Char 1 x 2 (crosstab)

Cross-tabulation (= 'contingency table') of 2 characters against each other

Q

Char-state usage Char 1 x 2 (crosstab, names)

Names version = uses character names instead of CID numbers

Q

Char-state usage Char 1 x 2 (list)

List version; use Excel pivot analysis to make a cross-tabulation

Q

Char-state usage Char 1 x 2 (list, names)

Names list version = uses character names in addition to CID numbers

Q

Char-state usage Char 1 x 2 x 3 (list)

List version for 3 categorical characters; use Excel pivot analysis to make a cross-tabulation

Q

Char-state usage Char 1 x 2 x 3 (list, names)

Names list version for 3 categorical characters, uses character names in addition to CID numbers

Q

Char-state usage Char 1 x 2 x 3 x 4 (list)

List version for 4 categorical characters; use Excel pivot analysis to make a cross-tabulation

Q

Char-state usage Char 1 x 2 x 3 x 4 (list, names)

Names list version for 4 categorical characters, uses character names in addition to CID numbers

Character cross tabulation (numeric)

Q

Numerical x categorical char (list, names)

Numerical x categorical character, use pivot analysis in Excel = ANOVA design

Q

Numerical x numerical char (list, names)

Two numerical characters = regression design

Q

Numerical x numerical x categorical (list, names)

Two numerical characters are crossed with a categorical character = GLM design

Character state analysis

Q

Char-state usage BY Char (crosstab)

In how many items are the states of each character used? Sorted by char. number (CID)

Q

Char-state usage BY Char (crosstab) only IN/RN

As above, numerical characters only

Q

Char-state usage BY Char (crosstab) only OM/UM

As above, categorical characters only

Q

Char-state usage BY Char (crosstab) sort by name

In how many items are the states of each character used? Sorted by char. name

Q

Char-state usage BY Char (list/percent)

List version. The percentage of each state relative to all states of the same character is calculated

Q

Char-state usage BY Item (list)

List of char./char. states x items; for categorical characters = complete matrix in list form; useful only as basis of further analyses

Q

UM/OM char-state multiplicity BY Char (list/percent)

For each char: How often are 1, 2, 3, ... different states of this char. used in a single item

Q

UM/OM char-state multiplicity BY Char (list/percent, resolving combined CS)

As above, combined states (1&2) are treated like separate states (1/2)

Q

UM/OM char-state multiplicity: Potential additional exclusive (Multistate=0) characters

List characters where any item uses at most a single character state, could be set to Multistate = exclusive

Chart/graph reports

R

Char. state usage of Char 1 x 2 (bar graph using CS-Name; like a crosstab)

Char. state usage of 2 characters (cross-tabulation as bar graph; using char. state name)

R

Char. state usage of Char 1 x 2 (bar graph using CS; like a crosstab)

 Char. state usage of 2 characters (cross-tabulation as bar graph; using the state code; state names are given in a legend)

R

Char. state usage of Char 1 x 2 (bubble graph using CS; like a crosstab)

 Char. state usage of 2 characters (cross-tabulation as a bubble graph, size of bubble -> proportion of items with this combination; using the state code)

R

Character state usage over all items, separate bar graphs for types: UM/OM/RN/IN

In how many items is each state used? (Quantitative)

R

Character state usuage by character (graph), all items + each item separately

Is a state used or not? (Qualitative, first page shows all items together, following are 1 page for each item)

R

Mean, range, min/max of categorical/multistate characters, over all items (Graph)

Box plot like for numerical character, sometimes useful for ordinal char. (note: mean is not really defined for type OM!)

R

Mean, range, min/max of numerical characters (Graph)

Box plot with indications of mean and min/max for each numerical character, over all items of current subset

Checking data

Q

Exclusive character state condition (Multistate=0) violated

List all items where multiple character states are scored(e.g. '1/2'), although the char. is defined as exclusive

Q

List items where all states of a char. are used (states are 'saturated')

If all states have been used (scored), you might consider coding the item as variable (V) in respect to this character instead

Q

List items where both "Present" and "Absent" states are used

If a char. has only two exclusive states like present/ absent, the special state 'V' should be used to indicate variability

Q

List items where both normal and special CS are used

You have used a char. state combination like 1/U or V/1 or 1/-. normally these do not make sense.

Q

List items where 'mandatory' characters are missing

Which items are not using which mandatory characters?

Q

Numerical chars, Max of each statistic (crosstab)

Plausibility test: Display the maximum for each numerical statistic (attribute, e.g. min, mean, max, ranges)

Q

Numerical chars, Min of each statistic (crosstab)

Plausibility test: Display the minimum for each numerical statistic (attribute, e.g. min, mean, max, ranges)

Q

Numerical chars, Min/mean/max of any statistic

Quick plausibility test, it does not matter in which numerical attribute the Min or Max are found.

Q

Numerical statistics, sequence violated (min>mean, etc.)

Plausibility test: The main numerical attributes are checked for min < range < mean < upper range < max

Q

Test for use of "-" ("to"-operator, modifier) in UM type characters

If a char is type UM, 1-3 is equivalent to 1/3, not 1/2/3. You may have coded correctly, but its worth checking

Consistency checks if 'referential integrity' failed

Q

DEP (dependency) records with non-existing char./char.state comb. or inapplicable char.

Use ONLY if you received an error message "relation could not be created" during import

Q

DESCR records without CS record (= Items with non-existing character/char.state combination)

Use ONLY if you received an error message "relation could not be created" during import

Edit or view data

Q

Edit Data + CS

Example of item description join. Use not recommended, use ItemEdit form instead!

Q

Edit Item + Data

Example of item description join. Use not recommended, use ItemEdit form instead!

Q

Edit Modifier templates

Called from button in CharEdit edit form! Organized into usage groups, which can be enabled as predefined modifier set.

Q

Full item data output

This is the base query used to export a project to DELTA or natural language (as RTF) format.

Q

Items with single text character

Can be used as very simple tabular report. You can enter the CID of the text character you want to list.

Q

List linked characters (char groups)

Overview over linked characters. Should be replaced by a graphical overview in the future.

Q

Mean, or middle of ranges/min/max of 1 numerical char.

Displays the "(Min-) LowerRange-Mean-UpperRange (-Max)" formatted data for a single numeric character; plus the mean, or the middle value between Ranges/Min/Max

Q

Mean, ranges, min/max of numerical char. for each item, columns

Displays the main statistical attributes, one column each for Mean, Ranges, Min, and Max; without Notes

Q

Mean, ranges, min/max of numerical char. for each item, columns, incl. Notes

Displays the main statistical attributes, one column each for Mean, Ranges, Min, and Max; plus Notes of all numerical attributes (concatenated into 1 column)

Q

Mean, ranges, min/max of numerical char. for each item, formatted, incl. Notes

Data are formatted as "(Min-) LowerRange-Mean-UpperRange (-Max)"; all Notes collected into 1 column

Q

Show max of LinkGroup

Show the highest LinkGroup number. Normally not very useful.

Q

Show max of NumStates

The character with the most character states has this many states defined. Normally not very useful.

Q

View a list of all analysis queries, forms, and reports provided in the analysis section

This list in the help file has been generated using this query!

Inapplicable characters

Q

Inapplicable chars defined as mandatory

Mandatory + potentially inapplicable is possible, but not recommended

Q

Inapplicable chars used (not updateable)

List items where a character has been used although it should be inapplicable

Q

Inapplicable chars used (write to table TEMP_InapplicableUsed)

List items where a character has been used although it should be inapplicable; creating a table that can be used to join it with the DESCR table for editing

Q

List controlling chars/states with inapplicable chars

List all controlling characters/states together with the inapplicable characters they control

Q

List controlling chars/states with inapplicable chars, 4 levels hierarchy

As above, plus a 4 level deep recursion if an inapplicable char. controls another inapplicable char.

Q

List inapplicable characters (DELTA Format)

List all potentially inapplicable characters, formatted like in the DELTA Dependent/Inapplicable directives

Q

List inapplicable chars with controlling chars/states

List all potentially inapplicable characters together with their controlling characters/states

Reorganize project

Q

Implicit states: Check applicable (= no other state used)

Which items, where characters with an implicit state are not used otherwise, would receive the implicit state?

Q

Implicit states: Insert permanently into item description (_DESCR)

Insert the results of the check implicit query as permanent data (table <projectname>_DESCR)

Q

Unused chars: Insert 'U' as item data (all types)

Insert special state 'U' for each item/char combination where no other data have been set

Q

Unused chars: Insert 'U' as item data (OM/UM only)

Like above, restricted to categorical characters (type UM/OM)

Repair and maintenance

Q

Add character heading default AutoGroups

Add default AutoGroup headings to character headings (special named character groups for identification). Automatically executed when new project is imported or created!

Q

Add CS: Full numeric attributes for all RN/IN

Add the extended numeric states (sample size, Confidence intervals, etc.) to the minimal numeric states.

Q

Add CS: Internal state TE for all text char (TE)

Only for repair of a corrupted char. definition: Insert character state TE into all chars of type text

Q

Add CS: Minimal numeric attributes for all RN/IN

Only for repair of a corrupted char. definition: minimal numeric states are default for all numeric chars.

Q

Add CS: U,V,- for all OM/UM/RN/IN

Add the standard DELTA special states to all categorical and numerical characters

Q

Char. Definition: Move Unit of categorical characters to CharStateName

Already used during import to remove Units from categorical char. and append them to CharStateName

Q

Enable all modifiers for all characters (not recommended!)

Enabling all modifiers results in huge pick lists including inapplicable modifiers like colors for non-color chars.

Q

Item description: Move recognized Notes to Modifier

Try to recognize modifier strings in the Notes field, move them to the Modifier-field. Executed during import.

Q

NumStates: Set to used

Number of states attribute is calculated from the number of states actually used

Q

NumStates: Used <> Defined

Check where the number of states used differs from the number defined

Special character states

Q

Combined categorical char. states, e.g. '1&3' (Char. def.)

In which characters have combined character states been defined?

Q

Combined categorical char. states, e.g. '1&3' (Item list)

In which items have combined character states been used?

Q

Not applicable ('-') used (Item list)

List all character/item combinations where the special state '-' has been used

Q

Not applicable ('-') used explicitly where already implicitly n/a

List all character/item combinations where '-' has been used although this is already defined through character dependency/inapplicability

Q

Not applicable ('-') used explicitly where already implicitly n/a: delete!

Delete all character/item combinations from the query above

Q

Text ('TE') instead of categorical (UM/OM) data allowed (Char. def.)

In which characters has the text override state (TE) been defined?

Q

Text ('TE') instead of categorical (UM/OM) data used (Item list)

In which items has the text override state (TE) been used?

Q

Unknown ('U') used (Item list)

In which items has the special character state 'U' (unknown) been used?

Q

Variable ('V') used (Item list)

In which items has the special character state 'V' (variable) been used?

Tabular reports

R

Item description report w. checkboxes for categorical char., includes notes, numerical/text char.

To be used as a form for "offline" editing. Categorical char appear as checkboxes, numerical and text char. as separate lists

R

Simple tabular character/char. state definition report

Character definition, character states, optionally linked modifiers; includes character headings

R

Simple tabular item description (= data) report

Item name together with description (scored char. state + numerical and text data)

R

Simple tabular item name report, grouped by 'genus'. 2 columns.

("Genus" is defined as the first word in item name)

R

Simple tabular item name report, sorted by % of unused chars (UV- = unused)

Item names, sorted by number of characters in which item is not used (special char. states treated as not present = missing)

R

Simple tabular item name report, sorted by % of unused chars (UV- = used)

Item names, sorted by number of characters in which item is not used (special char. states U/V/-/TE treated as normal states)

R

Simple tabular item name report. 2 columns.

Item names alone

Unused items/characters

Q

Unused Char-states (U/V/- excluded)

Which character states (except for the spec. states U/V/-/TE) have not been used (scored) in any item?

Q

Unused Char-states (U/V/- included)

Which character states (incl. the spec. states U/V/-/TE) have not been used (scored) in any item?

Q

Unused chars per item (%/item-order, UV- = unused)

Number of characters in which item not used (special char. states treated as not present = missing)

Q

Unused chars per item (%/item-order, UV- = used)

Number of characters in which item not used (special char. states U/V/-/TE treated as normal states)

Q

Unused chars per item (%/percent-order, UV- = unused)

Number of characters in which item not used (special char. states treated as not present = missing)

Q

Unused chars per item (%/percent-order, UV- = used))

Number of characters in which item not used (special char. states U/V/-/TE treated as normal states)

Q

Unused item-char combinations (CID-order)

List all items which do not use a given character state, sort by CID

Q

Unused item-char combinations (item-order)

List all items which do not use a given character state, sort by item name

Q

Unused items per char (CID-order, UV- = unused)

Number of items in which char not used (special char. states treated as not present = missing)

Q

Unused items per char (CID-order, UV- = used)

Number of items in which char not used (special char. states U/V/-/TE treated as normal states)

Q

Unused items per char (percent-order, UV- = unused)

Number of items in which char not used (special char. states treated as not present = missing)

Q

Unused items per char (percent-order, UV- = used)

Number of items in which char not used (special char. states U/V/-/TE treated as normal states)