office: +44 (0) 1491 825644
fax: +44 (0) 1491 832376
QPSMR 2020.2 - What's New
QPSMR Companion 2020.2 has a new facility to make grid variables for tables. All you need to do is select the entries you’d like to include and with two clicks the program will automatically generate two new grid variables. In fact, if your entries have identical names followed by a _ and a letter or number, you need only select one entry and QPSMR will include ALL entries from your project that use that name.
The program creates a variable containing the "elements" with shortened questions texts as the responses, plus header and sig markers, and … where you should add descriptive texts, plus a variable containing the "response texts".
To create the grid (banked) table, open a tables file, click the [New grid table] toolbar icon and drag the "elements" variable into the columns box (the program automatically uses the corresponding "response texts" variable as the rows). The usual global table settings, including format options to control sig testing can be used and if the original questions were filtered, the columns of the grid table will be too.
Once a grid table has been set up in this way, with a simple click the Columns and Rows can be transposed (appropriate format options will be applied by the program).
To see these new grid facilities in action take a look at our YouTube demonstration by clicking the image below.
A new Sum button [S] has been included on the "Variable responses" tab which adds up (counts) the number of times the previous responses were selected. This can be used when creating NETS (overcodes), where the total number of mentions is required, rather than using the standard "through to" .. definition (for example, Q1/1..4) where a respondent is included once only in the NET even if all responses were chosen.
Each time a new [S] response is included, all of the responses that follow the previous [S] response are added up (counted). There is also an analysis setting [Ignore for Sum] which can be applied on any responses that should not be included in the total.
Other analysis extras include controls that can be added to any text used in your spreadsheet tables. You can include bold, italic and underlined text and throw a new line as required.
Using new spreadsheet options, it is possible to round the table figures output (to CSV or your spreadsheet program) so that the cells show the whole number, but when a cell is clicked a specified number of decimal places is displayed.
When using letter markers for sig testing (with formats SHG1 or SHG11) you can now test table columns against other columns under different headers. For example,
Males Area\North (a) +d+
Mid (b) +e+
South (c) +f+
Females Area\North (d)
would mean that column (a) would be tested against columns (b) and (c) under the same header, and also column (d); plus column (b) would be tested against columns (a) and (c) and also column (e); plus column (c) against columns (a) and (b) and also column (f). This setting works both ways, so (a) +d+ would test (d) against (a) and vice versa.
There is also a special setting +?+ which means "test this column against all following columns, or up to the next column with a +?+ marker"; ideal when used with the overlapping formulae format options when total columns are included in the breakdown.
For CATI users, there are lots of new “telephone interviewing extras” including speedier creation of sample data and new menu selections to:
- list appointments
- extract and then save or export the current
- count the status for each current record by sample
and by quota points
- count all call outcomes for each record by sample
and by quota points
- list serial numbers and check for missing or
Last but not least ...
A QDF can now be extracted from a qpsmrinp file (ideal if you are not sure exactly which QDF was used to collect the data)
A header row is automatically added to a triple-s CSV file ready for import
[Data View] [File] [Save as…] allows you a full choice of file types (including UTF8 CSV, classic CSV, XLXS, ASCII and Unicode)
And, a couple of visual enhancements …
The number of records in the data file is now shown at the bottom of the [Data check] window
The [Responses block update] [Summary Rows] dialog box the response definitions are now shown … sometimes the smallest enhancements can be so useful!
To download your QPSMR Companion 2020.2 software click here