Count Array from 1 Column Data :     Count Matrix from 2 Column Data :     Transpose Count Matrix from 2 Column Data :

The program on this page is a utility that converts columns of primary observed dsta into arrays or matrices of counts. This creates the tables both for presentation, and also in some cases as data entered into statistical calculations.

The data are tabulated in order of ranks, alphabetically. Three tabulations are available from this page

• Count Array from 1 Column Data :
  • Data entry is a single column of numbers or names.
  • The programs produces an array of counts, in order of ranking.
  • Two tables are produced
    • A Labelled table for presentation, including calculations of percentage
    • An unlabelled array of counts, suitable for data entry to other statistical calculations
• Count Matrix from 2 Column Data :
  • Data entry is a two column of numbers or names.
  • The programs produces a table of counts, in order of ranking.
  • The values of column 1 are translated to rows and values of column 2 into columns
  • Two tables are produced
    • A Labelled table for presentation, including calculations of percentage
    • An unlabelled matrix of counts, suitable for data entry to other statistical calculations
• Transpose Count Matrix from 2 Column Data :
  • This does the same job as the previous section, Count Matrix from 2 Column Data, except that column 1 is translated into the columns of the table, and column 2 translated to the rows of the table. This is used when the primary data contains group designation in column 1 and values in columns 2, but the data analysis requires a table of counts where the groups are in the columns and ranks are in the rows.