SOFA Statistics had its 50,000th download today, and last month had over 4,600 downloads – a new record.
Archive for the ‘general’ Category
Box and Whisker plots have been added.
In keeping with the SOFA ethos these have been made as attractive as possible:
As with all SOFA output, the Box and Whisker Plots are themed and, like other charts, the content is dynamic and interactive. A minor feature added to this version is a warning about the need to include the “sofa_report_extras” subfolder to see charts.
The following bug fixes have been made:
- Fixed bug preventing comma being used as decimal separator when importing data.
- Fixed bug when making line charts with averages – shows smoothed data line and trend line appropriately. Also only enables or disables checkboxes for smoothed data line and trend line where appropriate.
- Better handling of comtype errors.
- Fixed bug in histogram code when no default limits supplied.
It is easier than ever to get started with SOFA Statistics. A new “Get Started” button has been added to the main form and other buttons have been shifted to better emphasise the most important:
Clicking on the “Get Started” button open a web page with screen shots and step-by-step examples.
It is now easy for first-time users to give their feedback. Was it as useful as they hoped? Is there anything which can be done to improve SOFA? There is a link on the main start form, plus a pop-up option on first exit from SOFA.
The goal is to make SOFA more useful by finding out what worked, and didn’t for users – especially first-time users.
There were two other changes:
- When importing csv files, SOFA now sets the default for ‘Has header row?’ according to a review of the sample contents.
- And an Exit control has been added to all forms where appropriate.
Once again, there have been a number of bug fixes:
- Fixed postgresql quoting error by using single quote values.
- SOFA now uses the default database when making an initial connection. If connecting to a project fails, SOFA reverts to previous project. Postgresql projects insist on default database if user is not ‘postgres’. Gives useful error if an old project has this problem.
- Fixed minor bug in Mann-Whitney output exposed whenever labels with %s in them were used.
- Improved error trapping if error importing wx.lib.iewin.
- Better font for help text on main form according to platform.
- CSV importing copes with single-row data.
- Better font settings for help text on Macs.
- Fixed display bug in Mac when more than 20 values warning shown (smaller font now).
- Chart by now filters out data lacking values in chart by variable.
The most important thing for the project is the feedback we will hopefully receive.
SOFA Statistics has now become the most downloaded general purpose statistics application on SourceForge, having passed the 40,000 download mark. There are plenty of new features forthcoming, and every effort will be made to add them without compromising the commitment to ease of use, learn as you go, and beautiful output.
For line charts, users can now add trend lines and smoothed lines (using a weighted rolling average).
And histograms can now be produced with a normal distribution curve overlaid.
Other improvements include:
- Histograms display better when lots of bins – wider chart and smaller font for x-axis.
- Simplified layout of project selection form and changed preferences form.
- Clearer labels when users are selecting a range of groups rather than discrete groups e.g. in ANOVA.
- Added medians etc to the Wilcoxon Signed Ranks output.//
- An early error message directs the user to the help page on “SOFA Won’t Start”. It also includes connection details in the error message if unable to connect to the default database.
- Only delays next “What’s up” connection date if it successfully gets through.
There have also been some useful bug fixes:
- Bug fix when importing from ODS any data which could potentially be a year e.g. 2631.
- Report quality histograms no longer leave out values falling right on the upper limit.
- Two-tailed vs one-tailed corrections in output display.
- Fixed problem with table names (esp safetblname) surviving test for SQLite validity and breaking future tests.
I suspect that downloading SOFA Statistics is, for most users, the last contact they have with the project or the community. The latest version (1.0.2) addresses this. Approximately 2 weeks after the first use, and every couple of months thereafter, SOFA Statistics pops up a “What’s Happening” web page within the application. This page has links to help, quotes, latest SOFA Statistics news, resources, featured statistics videos etc. I hope it will be of value to users, and help them get the most out of SOFA Statistics and the training etc resources available. This aspect of SOFA is intended to be relatively unobtrusive and it can be closed immediately if so desired with its close button.
Other changes include:
- Added explanation of Mann-Whitney U to output, added degrees of freedom to output wherever possible, added footnotes for p values where lacking, and ensured all p values are to 3 decimal points unless under 0.001 in which case ‘< 0.001' is displayed.
- Better help messages if early problem with comtypes (Windows only) or library dates.
Bug fixes include:
- Fixed bug when reporting on datetime fields as rows or columns in report tables in MySQL, PostgreSQL, Access, and SQL Server.
- Fixed minor bug which meant MySQL importing failed on Macs because it didn’t recognise the platform.
Work will begin soon on the versions leading up to 1.1.
SOFA Statistics is 100% free and open source but affordable commercial support is available to those who would like that here. The latest version is the culmination of several years work and we hope you like it!
Installation note if upgrading: if upgrading from 0.9.24 or below, you will need to rename your /home/username/sofa folder to /home/username/sofastats if you wish to work with old data or settings. If you are using Ubuntu, you must also manually uninstall previous versions of SOFA first so that “sofastats” can overwrite the application icon put there originally by “sofa”.
One of the biggest changes this release is behind the scenes – the folders SOFA Statistics is stored in have changed from “sofa” to “sofastats” to make them more distinct (there are other sofa programs ;-)). This was something important to get done before the version 1.0 release. Although this is a good change for the long-term it means users upgrading from 0.9.24 and below will need to rename their /home/username/sofa folder to /home/username/sofastats if they wish to work with old data or settings. For Ubuntu users, it is also important to manually uninstall previous versions of SOFA first so that “sofastats” can overwrite the application icon put there originally by “sofa”.
More noticeable, is the change to version upgrade checking. Auto-checking for any version upgrades is now the default. The goal is to help users stay up-to-date with bug fixes, improvements etc. Users can disable this feature by selecting the “No checking” option, or only auto-check for major upgrades. This feature only reads the contents of a small text file on the sofastatistics.com domain containing the latest version number.
Other changes include:
- SOFA suggests names more likely to be valid when user selects a file for importing.
- Can now import csv files with a txt extension.
- MySQL and PostgreSQL can now accept blank passwords.
- Better message for user if comtypes problem.
- Windows and Mac versions will no longer accept being launched with Python 2.7 and will give useful messages about fixing the problem. For Windows, the importance of installing the site-packages to python26 rather than python27 is explained.
- Mac version uses new, easier-to-install library to connect to MySQL databases.
The main series of bug fixes relate to recoding data and making new data tables or redesigning them.
- Fixed numerous recode bugs – mostly to do with application of recoded value labels.
- Fixed bug when making a new table with an existing name. Now stays open to give user choice as to what to do next e.g. change table name.
- Fixed misc bugs when deleting/adding/renaming tables while a database other than the default SOFA database is selected.
- Fixed bug running frequency table using MySQL where the category items are long integers.
- Fixed bug where Data List report selected and then the database is changed.
Ideally, the next release should be version 1.0.0
SOFA Statistics has now been downloaded over 30,000 times and the pace has accelerated in recent months. This is encouraging for the project as preparations are made for the version 1.0 release.