Statistics Open For All
SOFA - Statistics Open For All
The user-friendly, open-source statistics,
analysis & reporting package.

User Tools

Site Tools



Making Report Tables

Updated Versions of SOFA

This documentation was written for older versions of SOFA but is still basically correct. The “Run” button is now called “Show Results”; and Row Stats Report Tables have now swapped rows and cols so that the stats (mean, median, std dev etc) show across rows and are grouped by columns. Updating all the screen shots is on the to-do list ;-)

Making a Simple Crosstab Table

On the main SOFA form, click on “Report Tables”,

Let's start with a simple report table of Age Group vs Country. NB all of this data is fictitious and designed to allow features of the program to be demonstrated.

  1. For “Table Type” select “Crosstabs”. A cross tabulation shows one or more variables against one or more other variables e.g. Age Group in the rows and Country in the columns.
  2. We need to add a row so click on “Add” under the “Rows” label
  3. Select “Age Group” and either double click it or select “OK”.

Under the “Columns” label click on “Add” and add Country.

In the demonstration pane below you will see a rough illustration of what the table will look like. If you want to see the actual table, click on “Run”.

If “Add to report” is ticked, the output will also be saved to the end of the output file specified at the bottom of the form.

Extra Configuration of Report Table

Next you may want to configure the rows and/or columns. Let's add a total column and columns for row and column percentages.

  1. Click on “Config” under the “Columns” label
  2. Tick “Total” under the “Misc” heading
  3. Tick “Column %” and “Row %” under the “measures” heading
  4. Click on “OK” to see changes in demonstration table. NB to see actual results, click on “Run”.

If you click “Run” with “Add to report” ticked, you can view the result by clicking on the “View” button. This will open your default web browser so you can see the output.

The styling of your table can also be changed - here are some examples of different report tables:

Making a Row Stats Table

Instead of frequencies and percentages, Row Summaries Tables have means, medians, standard deviations etc.

  1. Select “Row Stats” as the report Table Type.
  2. Under the “Cols” label, click on the “Add” button.
  3. The “Variables” dialog will display all numeric variables. Choose one or more.
  4. Clic on “OK” button.

  1. Under the “Cols” label click on the “Config” button.
  2. Select the measures you wish to report on. Mean is preselected by default.
  3. Click “OK”.

Optionally, you can add a row variable e.g. “Age Group”. Row variables for “Row Stats” report tables can have totals.

NB Click on the “Run” button to produce the output. Also note that all the data in the “demo_tbl” is fictitious.

Making a Data List Table

Sometimes you just want to display some data, possibly with a totals row and perhaps with the first column as a label column.

  1. Start by selecting “Data List” as the report Table Type.
  2. Optionally select “Totals Row?” and “First col as label?”.
    NB Totals are only kept for numeric columns.
  3. Click on the “Add” button under the “Columns” label.
  4. Select one or more variables to display. They will display in the order added. Additional variables can be added by clicking on the “Add” button again. To get the desired order it may be necessary to use the “Add” button multiple times.
  5. Click on the “OK” button.

A video is available showing how to make report tables: Making report tables video

Another video is also available showing how to calculate basic statistics like mean, median etc using SOFA Statistics:

Another video is also available showing how to make frequency tables using SOFA Statistics:



help/report_tables.txt · Last modified: 2012/11/02 11:46 (external edit)