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 treated as text and not numbers, and sorted alphabetically, so that 1.20 and 1.2 are not the same thing, and 11 comes before 7 and 07 comes before 11

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, alphabeticvally sorted.
• Count Matrix from 2 Column Data :
  • Data entry is a two column of numbers or names.
  • The programs produces a table of counts, sorted alphabetically.
  • The values of column 1 are translated to rows and values of column 2 into columns
• 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.

Please note:

Names and total counts for row and column are included in the count table. These need to be left out if table is used as data entry to other programs

The whole table can be copied and pasted into Excel and further edited

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