Archive for August, 2012

1.2.1 enables export to spreadsheet and more

Tuesday, August 28th, 2012

The latest version of SOFA Statistics makes it easy (via a plug-in) to export to spreadsheet.

Export Data

SOFA also makes it easier to select multiple variables when making report tables.

Select multiple variables

Additionally, there have been some important bug fixes – mainly for bugs which snuck in during the major change to 1.2.0.

  • Fixed nasty bug breaking demo report tables. A casualty of the changes to the independent display of titles from report tables in 1.2.0 so wide titles didn’t mean wide table cells.
  • Fixed bug with display of percent symbols in report tables. A missing not was the culprit – another casualty of the big refactoring for 1.2.0.
  • Fixed bug with Data List reports – wouldn’t update display after changing sort order of a variable.
  • Sort by value now works properly in Data List reports.
  • Can now handle excessively long values being used as categories in report tables or charts etc. Checks are also now made for excessively long category variable values.
  • If encoding problems, SOFA now tries to use the field encoding e.g. iso-8859-1.

Easy exporting of output to PDF and images

Saturday, August 18th, 2012

SOFA creates HTML web reports ready to share but sometimes you want to share a PDF or include graphs and tables in documents and slideshows. The ‘export output’ extension makes it easy. And the images can be exported in draft for speed or a range of higher quality resolutions e.g. for publication. Export output plug-in

The Export Output plug-in is available at get_extensions.php and is compatible with SOFA 1.2.0, which has just been released.

Version 1.2.0 also offers the following:

  • Scatterplots can have more than one series e.g. different coloured male and female dots on same plot.

    Multiseries scatterplot
  • Individual columns within a data display report table can be sorted. This is extremely useful for checking your raw data, looking for anomalies before analysis.

    Sortable Data List Reports
  • Report tables of summary statistics e.g. mean, median, sd, now show the measures across columns instead of down rows. This makes it much easier to compare results and notice difference.

    New Row Stats Layout
  • Numerous changes to layout and functioning to make SOFA easier to use. For example, the demonstration tables displayed when configuring report tables now use real data instead of random data if the data source is small enough to make updating fast. And the “Show Results” button becomes “Add to Report” when report tables are able to use live data for examples (and the “Add to report checkbox” is hidden). Add to report now defaults to False and remembers the last setting throughout the user session. And some standard GUI items have been repositioned to increase the logic of placement and speed of use.

    Layout Improvements
  • Added IQR (Inter-Quartile Range) to the Row Stats Table.
  • Can now do a boxplots of a single variable (not requiring a variable for it to be By).

    Single Variable Boxplots
  • Now save and show cropped matplotlib charts.
  • Scatterplots are a better size.
  • Excel importing copes with faulty dates better and tells the user where the problem is.
  • Filter dialog now checks if user wants to apply a filter when the settings haven’t been changed. Prevents inadvertent filtering to null.
  • Better font sizes in auxiliary clustered bar charts (matplotlib).
  • GUIs no longer update if the user selects the same database as is already selected.

And there have been plenty of useful bug fixes too:

  • Fixed bug when more colours are required for auxiliary clustered barcharts than in the css.
  • Fixed bug re: linked images with non-English characters not displaying in GUI html window (still issue if user relying on IE6).
  • Fixed bug which made report tables widen if the title or subtitle was wider.
  • Fixed bug where removal of filter in the charting dialog would change third variable dropdown to the last value it had when the filter was applied even if it had subsequently been changed to the Nothing Selected value. The default values are now updated everytime the dropdowns change.
  • Now a guaranteed consistency in series colours across charts even if a series is missing e.g. the middle one, from one of the charts.
  • Misc bug fixes for stats tests where no variability. Better user messages.
  • Independent variable tests cope with new lines in text values.
  • Histograms all get title case titles if no value label instead of upper case.
  • Fixed bug when filtering results in no group a and b values possible in indep2var analyses.
  • Fixed histogram width issue esp if wide numbers e.g. 12000 is wider than 12.
  • Fixed css display problem in webkit internal browsers.

This is an exciting release and hopefully the plug-in will be well received.