<< Click to Display Table of Contents >> Navigation:  Reference Manual > Formats > Statistics formats

These formats are used to alter the statistical calculations on the table.

See also Significance formats that control the marking of significant differences.

See also Column identifiers for details on how to identify columns for comparison.

All tests are two tailed.

For more information online about significance testing see https://netmr-download.scot/user-documentation/statistics.

AVG (Average)

This logical format produces a row of mean scores for row entries with score values or averages for row values.

Default value is AVG (true).  Use NAVG to turn off.

BST (Base for Stats)

This logical format produces a row of the number of records used in each column to calculate the mean score or average.  It excludes responses with no score value assigned or undefined values.  

Default value is NBST (false).  Use BST to turn on.

DPA (Decimal Places for Averages)

This is the number of decimal places to show for means scores or averages on a table.

The default value is DPA1.

The value must be set in the range DPA0 to DPA15.

DPS (Decimal Places for Statistics)

This is the number of decimal places to show for statistics other that the means scores or averages on a table.

The default value is DPS2.

The value must be set in the range DPS0 to DPS15.

ESS (Effective Sample Size)

This logical format produces causes the statistics calculations to use the effective sample sizes in calculations.

Default value is ESS (true).  Use NESS to turn off to use unweighted bases instead of effective sample bases.

This format has no effect on tables that are not weighted.

EVR (Error Variance)

This logical format produces a row of the error variances for each column.

Default value is NEVR (false).  Use EVR to turn on.

ILH (Indicate Highest Value)

This logical format produces a row of the highest values or scores for each column.

Default value is NILH (false).  Use ILH to turn on.

NOTE: the values must be in ascending order for this format to work properly.

This format cannot be produced on stats only tables.

ILE (Quantiles)

This produces a set of rows of the values or scores at each set quantile for each column.

The default value is ILE0 (not used)..

The value must be set in the range ILE0 to ILE100.

For example ILE4 will produce quartiles in three rows.

See also format MED for medians.

ILL (Indicate Lowest Value)

This logical format produces a row of the lowest values or scores for each column.

Default value is NILL (false).  Use ILL to turn on.

NOTE: the values must be in ascending order for this format to work properly.

This format cannot be produced on stats only tables.

MED (Median)

This logical format produces a row of the median values for each column.

Default value is NMED (false).  Use MED to turn on.

NOTE: the values must be in ascending order for this format to work properly.

This format cannot be produced on stats only tables.

MSE (Mean over Standard Error)

This logical format produces a row of the values for each column.

Default value is NMSE (false).  Use MSE to turn on.

MSE should only be used when the 'expected' mean for the rows is zero:

This can be a paired t test where the table rows are the old value subtracted from the new value (or the other way round if appropriate)

This can a preference test where the rows are Prefer A (score value +100), Prefer B (score value -100), No preference (score value 0).

This format produces a t test value for how unlikely it is that this column came from a sample with a mean of zero.

In CSV/Excel tables, markers + and - show significance levels. These markers only relate to this particular column (not a comparison with the total column).

Format PRO can be used to show the actual probability/significance level.

POP (Population)

This logical format produces causes the statistics to assume that the whole relevant population has been interviewed.

Default value is NPOP (false).  Use POP to turn on.

Many stats formulae use N-1. Using this format N is used instead.

PRO (Probability)

Only used with format MSE to show the significance, default PRO0 not used.

PRO1 show the probability for the MSE t test value

PRO2 show the significance level of the MSE t test value to one decimal place.

PSD (Print Score Decimal places)

This is the number of decimal places to show for score values on responses in the row labels in tables.

The default value is PSD1.

The value must be set in the range PSD0 to PSD15.

PSP (Print Score Plus)

This logical format produces causes the plus sign to be used before positive score values on responses in the row labels in tables.

Default value is NPSP (false).  Use PSP to turn on.

PSV (Print Score Values)

This logical format produces causes the score values on responses to be shown in the row labels in tables.

Default value is PSV (true).  Use NPSV to turn off.

IMPORTANT: we recommend using NPSV and DPW for tables with values (integer or float) as the rows.

See also formats PSD and PSP.

SDV (Standard Deviation)

This logical format produces a row of the standard deviations for each column.

Default value is NSDV (false).  Use SDV to turn on.

SER (Standard Errors)

This logical format produces a row of the standard errors for each column.

Default value is NSER (false).  Use SER to turn on.

SSQ (Sum of Squares)

This logical format produces a row of the sum of squares for each column.

Default value is NSSQ (false).  Use SSQ to turn on.

SUM (Sum)

This logical format produces a row of the sum of all the values/scores used for each column.

Default value is NSUM (false).  Use SUM to turn on.