office: +44 (0) 1491 825644
fax: +44 (0) 1491 832376
QPSMR 2019 - What's New
As well as being able to merge (hand-in) responses from a CSV file by matching texts (for example, if a column headed GENDER in the CSV file contained the words Male and Female, and these matched the responses to a question named GENDER in your QDF file) QPSMR Companion can now merge multiple 1s.
If you have data for a multi-coded question split into several columns in your CSV file - that is a column for every response, each headed with the name of the multi-coded question, but all containing code 1s - when using the [Merge data files …] facilities QPSMR Companion will hand the 1 responses from each column into the relevant response for the multi-coded question in your QDF file. For example, a 1 in the third column will be handed into response 3 of the multi-coded question.
Furthermore you can "mix and match", so you can merge by text and sets of 1s at the same time!
Often a simple solution can save the most time! There is now a [Block] facility on the "Entry rename" dialog box, so you can quickly change entry names. This is especially useful if you copy a QDF and need to rename all entries in a section. For example, you might have many questions, filters and variables all containing Q9, which you’d like to change to Q13; using the [Block] button you can search for Q9 and replace that part of the name with Q13 - brilliant!
Block Ranking - Extended Facility
Another time saving feature is the ability to begin and end ranking for multiple entries simultaneously. For example, if you had a set of entries with 99 responses and you wanted all of the responses to each entry to be ranked in order (highest to lowest) on your tables, excluding responses 97 Don’t know, 98 Other and 99 None (which should always be positioned at the end of the table regardless) you would select all entries and use [Edit] [Block update responses] [Ranking] to add the ranking settings starting at the first response, and excluding the last 3 responses.
When creating and running tables, the default setting for format options RLW and CLW have been increased so row labels are now 30 characters wide and columns are 9 characters wide. Format ESS is now set, so if your tables are weighted any statistics calculations will use the effective sample sizes. Formats SMA’+’ and SMB’+’ are also applied, meaning that a plus or minus sign will be used to mark cells that are significantly higher or lower that the total column at the SLA and SLB levels respectively.
The global "Tables overall settings" dialog box, includes a new [Spreadsheet options] button, where you can set on or off many features to further control the spreadsheet output automatically generated when your tables are run.
As default, the spreadsheet output now includes larger table titles in bold, and the row titles are constrained to the first column.
NEW QPSMR Limited YouTube Demonstration
A new video has just been added to the QPSMR Limited YouTube channel - this one is all about analysis using QPSMR Companion – why not take a look HERE.