If you have ever used SPSS statistics application before, you might know what SOFA is. SOFA stands for Statistics Open For All can be used to be an alternative to paid statistics software SPSS.

SOFA is a user-friendly statistics, analysis, & reporting program. It is free, with an emphasis on ease of use, learn as you go, and beautiful output.
SOFA lets you display results in an attractive format ready to share. And SOFA will help you learn as you go.

The key features of SOFA such as:
Ongoing Development
SOFA Statistics is a new project and features are being added on an ongoing basis. Priority areas are being completed first

Beauty - Attractive Output
Beautiful output is a feature, even in a statistics/analysis program! It means that SOFA output can be used for presentations or automated reporting without manual formatting or reworking. Many statistical programs do not place much emphasis on aesthetics.

Database Friendly
Many statistics programs make you import data from a database before you can use it. Not SOFA. You can connect directly to your database, and all its tables. Just give SOFA the login details. You can even edit data from within SOFA, or apply a simple data filter to focus on the subset of a table you are interested in. SOFA currently supports:
  • MySQL
  • Microsoft Access
  • SQLite
  • PostgreSQL
  • Microsoft SQL Server

The third feature I've mentioned above is the special feature that other statistics software don't have. You can do such a direct connect to DMBS (Database Management System) without having to import the database itself.

For further information about SOFA, please take a closer look to its website.

Install SOFA on Ubuntu
Simply download the .deb file here, and type the following command once downloaded:
  • sudo dpkg -i sofastats-1.1.2-1_all.deb
  • sudo apt-get -f install
SOFA is available for Windows and Mac too, you can download the installer here.