Softpedia >Mac >Business >Wizard >  Changelog

Wizard Changelog

What's new in Wizard 1.9.48

Jun 11, 2021
  • Improved compatibility with documents saved in Wizard 2
  • Improved support for Access database files

New in Wizard 1.9.47 (Jun 11, 2021)

  • Fix an issue with the Wizard 2 information screen on macOS 10.15 and earlier

New in Wizard 1.9.46 (Jun 11, 2021)

  • Fix an issue with the previous version where Access databases would not open
  • Fix an issue where models could not be estimated on the Apple M1 chip
  • Fix several warnings in the Console when running on macOS 11 Big Sur

New in Wizard 1.9.45 (Nov 14, 2020)

  • Improved compatibility with future versions of macOS
  • Improved support for XLSX files generated outside of Excel
  • New support for wilcox.test in the R command generator
  • Fix a bug when toggling indicator values in the Predictions table

New in Wizard 1.9.44 (Nov 5, 2020)

  • SAS binary importer: Improved support for reading compressed files [Feature requires In-App Purchase]
  • SAS transport exporter: Improved compatibility with SAS [Feature requires In-App Purchase]
  • Fix a bug in the Model view where the residuals graph included missing values after exporting to Excel or CSV

New in Wizard 1.9.43 (Aug 18, 2020)

  • Improved support for importing XLS files
  • Improved support for importing Access files
  • Fix a bug when attempting to raise a numeric column to a custom power

New in Wizard 1.9.22 (Jun 4, 2018)

  • XLSX importer: Improved support for Chinese character sets
  • XLS importer: Improved support for large files. Fix crashes and hangs with malicious input
  • SAS catalog importer: Fix hangs with invalid input [Feature requires In-App Purchase]
  • SPSS importer: Add support for new DTIME and YMDHMS formats [Feature requires In-App Purchase]

New in Wizard 1.9.21 (Mar 20, 2018)

  • Access importer: Improved support for files created with Access 2010 and later
  • SPSS importer: Fix "Unable to allocate memory" errors [Feature requires In-App Purchase]

New in Wizard 1.9.20 (Feb 16, 2018)

  • XLS importer: Many files caused Wizard to close without a message
  • Numbers importer: Fix crash when importing an empty table
  • SQL importers: Fix crashes and interface glitches when using Custom SQL
  • PostgreSQL: Improved support for NULL values
  • General stability improvements

New in Wizard 1.9.19 (Feb 8, 2018)

  • Improved support for importing R Data files
  • Fix bug where "Build Model" button was sometimes grayed out
  • Fix an occasional crash during a Friedman test

New in Wizard 1.9.18 (Jan 24, 2018)

  • Fix bug where certain XLSX files could not be opened
  • Support for converting dates in the format "31-Dec-2017"
  • Improved appearance of The Wizard Store (Wizard > Unlock Pro Features...)
  • Reduce file size of exported SPSS files [Feature requires In-App Purchase]

New in Wizard 1.9.17 (Jan 19, 2018)

  • Support for reading compressed SPSS (*.zsav) files [Feature requires In-App Purchase]
  • Support for reading Stata 15 files [Feature requires In-App Purchase]
  • Fix crashes reading malformed files

New in Wizard 1.9.16 (Dec 19, 2017)

  • Raw data view: Fix an occasional crash when sorting data or closing documents
  • Summary view: Fix an occasional crash when exporting The Bottom Line
  • Summary view: Fix a crash when deleting multiple columns from the end of the column list
  • Summary view: Fix an issue where estimation commands sometimes did not appear
  • SAV reader: Improved support for files created by Java SPSS Writer [Feature requires In-App Purchase]

New in Wizard 1.9.13 (Nov 6, 2017)

  • Some strings were incorrectly imported from XLS files
  • Improved text-encoding detection in CSV files
  • Fix a crash after cancelling the creation of an Indicator Variable

New in Wizard 1.9.12 (Nov 6, 2017)

  • Multinomial logit models: Fewer "Not enough data" errors when the outcome distribution is heavily lopsided.
  • Multinomial logit models: Fix a bug in the Predict view when one or more outcome values are filtered out. (Previously, the Predict view would assign positive probability to filtered-out values.)
  • Ordered probit models: Fix a bug in the exported XLS file when one or more outcome values are filtered out. (Previously, Excel would report an error about corrupt or missing data.)

New in Wizard 1.9.12 (Sep 8, 2017)

  • Multinomial logit models: Fewer "Not enough data" errors when the outcome distribution is heavily lopsided.
  • Multinomial logit models: Fix a bug in the Predict view when one or more outcome values are filtered out. (Previously, the Predict view would assign positive probability to filtered-out values.)
  • Ordered probit models: Fix a bug in the exported XLS file when one or more outcome values are filtered out. (Previously, Excel would report an error about corrupt or missing data.)

New in Wizard 1.9.11 (Aug 23, 2017)

  • Improved navigation of topics in the Help file
  • Fix formatting of mean values in the Summary view for durations, currency, etc.

New in Wizard 1.9.10 (Aug 23, 2017)

  • Fixed a number of broken links in the Help file
  • Fixed an interface glitch viewing Predictions after opening a saved file
  • Fixed an interface glitch viewing correlation tests when correlation=1
  • Improved ability to cancel MySQL operations

New in Wizard 1.9.9 (Aug 23, 2017)

  • Database importers: Increase timeout to 3 minutes
  • MySQL importer: Fix bug when importing NULL numeric values

New in Wizard 1.9.8 (Jun 23, 2017)

  • Added support for computing Spearman's rank correlation coefficient
  • Correlation tests now display the correlation coefficient rather than the z-score
  • Improved performance of Standardized columns
  • Improved support for importing POR files [Feature requires In-App Purchase]

New in Wizard 1.9.7 (May 25, 2017)

  • Display the correct number of decimal places in the Filters pane
  • Improved support for importing R workspaces

New in Wizard 1.9.6 (May 8, 2017)

  • Excel importer: fix a bug where columns in XLS files were imported in the wrong order

New in Wizard 1.9.5 (May 2, 2017)

  • Fix a bug where standard errors in the Summary view did not display the correct number of decimal digits
  • Fix a bug where empty sheets in Excel files caused importing to fail
  • Fix a number of uncommon crash issues

New in Wizard 1.9.4 (Apr 10, 2017)

  • Improved compatibility with SAV files when IBM SPSS Statistics is installed on the same machine

New in Wizard 1.9.3 (Apr 3, 2017)

  • Improved support for importing Numbers files
  • Fix a bug parsing 24-hour times in CSV files
  • Fix a number of uncommon crash issues

New in Wizard 1.9.2 (Mar 21, 2017)

  • Improved support for importing XLSX files
  • Fix a crash when importing Numbers files
  • Fix a display glitch when partitioning numeric columns by a fixed interval width
  • Fix a crash when importing SAV files that have a frequency weight [Feature requires In-App Purchase]

New in Wizard 1.9.1 (Mar 16, 2017)

  • Fix a crash when importing from database servers
  • Fix a crash if a date column spanned more than 64 years
  • Fix a save error ("path_within_source is a required value")

New in Wizard 1.9.0 (Mar 14, 2017)

  • FROM THE LOWER DEPTHS OF HELL comes Wizard 1.9, a malign masquerade ball of new features and functionality. If you thought that Wizard could already do everything when it comes to data transformation and analysis, YOU WERE WRONG. In the biggest release since last year's sleeper hit Wizard 1.8, Wizard 1.9 brings you...
  • COLLAPSIBLE FILTERS -- Make the most of screen real estate with the new Pin button -- when activated, it keeps filters applied even when you close the Filters pane.
  • DATES, DATES, DATES -- Import dates in your favorite format, format your dates with four exciting date templates, analyze dates with down-to-the-second precision, partition date/time data with greater flexibility, and create Timestamp columns using the number of seconds from a particular start date.
  • FILE SIZE FORMATTING -- Does your data set include a file size measured in bytes? Now you can format it with easy-to-read units (KB, MB, GB, etc). There's even an option to switch between the decimal convention (1,000 bytes per kilobyte) and the binary convention (1,024 bytes per kilobyte).
  • ITUNES IMPORTER -- Automatically pull in your music collection and see all the new features in action with the new iTunes importer. Visualize your listening habits by time of day, tally up your music collection by artist and genre, and graph file sizes and track lengths just for kicks. To get started, use the new menu item File > Import iTunes Music Library...
  • These are just the big-ticket items -- in addition, Wizard 1.9 boasts countless interface tweaks and bug fixes to make your statistical experience as smooth, seamless, and streamlined as possible. Enjoy it on OS X 10.10 (Yosemite) or later.

New in Wizard 1.8.28 (Jan 31, 2017)

  • Fix a crash when refreshing data from a Numbers document
  • Fix a crash in the CSV importer
  • Fix a bug where space-separated timestamps weren't recognized
  • Improved support for RData files

New in Wizard 1.8.27 (Jan 19, 2017)

  • Fixed crashing issues on OS X Yosemite.

New in Wizard 1.8.26 (Jan 16, 2017)

  • CSV importer now infers the number of displayed digits
  • Fix crash when exporting files on macOS Sierra
  • Fix inability to select specific sheet when linking to a spreadsheet file

New in Wizard 1.8.25 (Jan 15, 2017)

  • XLSX importer: New ability to recognize dates stored as text
  • Bug fix: Export and import options were not displaying on El Capitan and later
  • Fix a crash when canceling an Import

New in Wizard 1.8.24 (Jan 6, 2017)

  • Bug fix: Some types of Numbers files could not be imported
  • Bug fix: "Import URL" did not work over plain HTTP on OS X 10.11 and later
  • Fix a crash when performing a t-test on a group with zero variance
  • Fix a crash when exporting tables with long multi-byte names to XLSX
  • Fix a crash when re-arranging columns in the Summary view with a filter applied
  • Improve performance of "Count Distinct Values" (Pivot view)

New in Wizard 1.8.23 (Dec 7, 2016)

  • All popovers now remain open while switching windows
  • Fix a memory leak when closing a document
  • Fix occasional crash when running a two-way ANOVA
  • Fix a crash when closing a document while in Full Screen mode
  • Fix a crash in the Predict view when a date column takes only one value

New in Wizard 1.8.22 (Dec 3, 2016)

  • Improved compatibility with OS X 10.9 (Mavericks)
  • Respect local date format during data entry
  • "Add Prediction" button was not working properly

New in Wizard 1.8.21 (Nov 28, 2016)

  • Improved compatibility with OS X 10.9 (Mavericks)
  • Fix a crash when analyzing paired-differences data
  • Fix a crash when censoring survival times

New in Wizard 1.8.19 (Nov 12, 2016)

  • Fix a crash when launching on OS X 10.11 (El Capitan)
  • Fix a crash when copying data from dot plots in the Summary view

New in Wizard 1.8.18 (Nov 3, 2016)

  • New ability to copy data from various image views directly to the clipboard
  • New ability to import from Macro-Enabled Excel files (.xlsm)
  • New "Duplicate Column" menu item
  • Text filters now support common prefixes of up to 9 characters
  • Various fixes when treating a column as Row Counts
  • Fix a crash when dragging and dropping in the Summary view
  • Fix a crash in the Pivot view
  • SAS importer: New support for SAS Transport format, and improved support for Baltic and Chinese character encodings [Feature requires In-App Purchase]
  • SAV exporter: Fix a crash when exporting text columns with approximate size of 250 bytes [Feature requires In-App Purchase]

New in Wizard 1.8.17 (Sep 12, 2016)

  • Improved support for parsing numbers containing invisible characters
  • Fix inability to select "Any" condition when censoring a survival time in the Model view
  • Fix a crash when building a model with multiple censoring conditions
  • Fix a crash when text columns contained no data
  • Fix an occasional crash when importing from database servers
  • Fix an occasional crash when exporting to SPSS binary format [Feature requires In-App Purchase]

New in Wizard 1.8.16 (Aug 9, 2016)

  • Fix inability to select "Any" condition when censoring a survival time
  • Fix interface glitch in the Model view
  • New support for exporting long strings to SPSS binary format [Feature requires In-App Purchase]
  • Improved support for reading long strings from Stata binary format [Feature requires In-App Purchase]

New in Wizard 1.8.15 (Jul 2, 2016)

  • Improved exporting to Stata binary format. New support for exporting long strings and Unicode text [Feature requires In-App Purchase]
  • Improved importing of SPPS portable files [Feature Requires In-App Purchase]
  • Fix a rare crash when processing non-UTF-8 text data

New in Wizard 1.8.14 (Jun 20, 2016)

  • Fix ability to edit names of Filter Sets
  • Fix occasional crash after duplicating a table
  • Fix instabilities after importing extremely large numbers
  • Fix scrolling glitch in the Summary view with multiple columns selected

New in Wizard 1.8.13 (Jun 6, 2016)

  • Improved support for reading Stata files with a row limit applied [Feature requires In-App Purchase]
  • Improved support for reading compressed SAS files [Feature requires In-App Purchase]
  • Improved support for writing SPSS files [Feature requires In-App Purchase]
  • Fix an interface glitch when switching between pivots
  • Fix an occasional crash when duplicating a table
  • Fix an occasional crash after Undo
  • Fix an occasional crash when exporting XLSX

New in Wizard 1.8.12 (May 24, 2016)

  • New ability to rearrange columns in the Pivot view via drag-and-drop
  • Switching between data tables now preserves selections in the Pivot view
  • Equal-counts chi-squared test now excludes empty categories (ideal for filtering)
  • Clarify in the Summary view that the t-test is Student's t-test
  • Fix interface glitches in the Pivot view (including inability to delete pivots)
  • Fix an occasional crash in the XLSX exporters

New in Wizard 1.8.11 (May 16, 2016)

  • Fix minor interface glitch in the Pivot view
  • Fix occasional crash in the Model view after editing data

New in Wizard 1.8.10 (May 10, 2016)

  • Fix more "content is unreadable" errors in some exported Excel documents
  • Fix occasional crashes with missing text values present

New in Wizard 1.8.9 (Apr 21, 2016)

  • Fix "content is unreadable" errors in some exported Excel documents
  • Fix an occasional crash in the Pivot view after an Undo
  • Fix minor interface glitches in the Raw Data and Pivot views

New in Wizard 1.8.8 (Apr 13, 2016)

  • "Export as XLS" menu items have been replaced with "Export as Excel". In the majority of cases these files will now be exported in the XLSX format, rather than the older XLS format. This fixes issues with exported data tables and correlation matrices exceeding the size limitations of the XLS format.
  • Many cosmetic improvements to exported Excel files
  • Fix an interface glitch with the "Count" column in the Summary view
  • Fix a crash associated with missing text values

New in Wizard 1.8.7 (Apr 6, 2016)

  • Fix a crash when editing column descriptions with a name filter applied.

New in Wizard 1.8.6 (Mar 29, 2016)

  • Fix a crash when saving in rapid succession
  • Fix a crash after editing a Recode variable
  • In the Summary view, labels on proportion bars were misplaced if the column's categories had been re-ordered

New in Wizard 1.8.5 (Mar 23, 2016)

  • Fix crashes associated with missing values in a date/time column.

New in Wizard 1.8.4 (Mar 16, 2016)

  • Fix an occasional crash when reordering categories within a column
  • Fix an occasional crash with Column > Compute Combinations
  • "Count Distinct" now available for non-category numeric columns
  • Improved support for editing decimal numbers in non-US locales

New in Wizard 1.8.3 (Feb 24, 2016)

  • Fix a crash when connecting to MySQL a database having non-ASCII column names
  • Fix an intermittent crash after importing from a URL

New in Wizard 1.8.2 (Feb 17, 2016)

  • Fix a crash when adding columns to an empty table
  • Fix display issues with Date/Time bar charts in the Covariate view
  • Fix display glitches in the Wizard Store
  • Zero was sometimes displayed as "-0"

New in Wizard 1.8.1 (Feb 15, 2016)

  • Fix a bug that prevented the tutorial from running
  • Fix a bug that prevented exporting data to a SQLite database
  • The full year was not always visible when filtering by a Date column

New in Wizard 1.8.0 (Feb 10, 2016)

  • REFRESH FROM WEB: Ever wish you could grab data directly from the web? Now you can import files directly from the WWW just by clicking "Import URL" and typing in a web address. Wizard will download the file for you, and keep your analysis up-to-date every time you click the "Refresh Data" button. The new feature is ideal for JSON data, but is designed to work with every file format supported by Wizard. To get started, choose File > Open URL, or click the new "Import URL" button in the toolbar.
  • POST-HOC ANALYSIS: A.k.a., "multiple comparisons corrections". If you're hunting for significant p-values, you should usually apply a statistical correction to account for the number of simultaneous tests you're performing -- this keeps your Type I error rate under control (and also keeps the journal referees happy). Now applying the correction is as simple as checking the box labeled "Adjust for multiple comparisons" and entering a number. To avoid confusion, corrected p-values will appear with an asterisk. (The applied correction is technically a Šidák correction, which is slightly more accurate than Bonferroni. You are nonetheless encouraged to celebrate the new feature by belting out "Bonferroni" to the tune of "My Sharona".)
  • NEW TEXT FUNCTIONS: "Concatenate" joins together multiple text columns with an optional separator. "Convert to Numeric" changes the underlying storage of a text column to be numeric. "Count Characters" and "Count Words" lets you compute the lengths of text values, ideal for analyzing natural-language data. If you'd like more text functions, just send me an email with your request and I'll take it under consideration. (Choose "Email the Developer" from the Help menu.)
  • MISCELLANEOUS IMPROVEMENTS: The Raw Data and Pivot views now remember each column's width when you resize it. (Less "resize hell" after re-opening a document.) The Column menu has been cleaned up to display only functions that are relevant to the selected column. The Pivot view allows you to perform "Count Non-missing" on a category column. The "Enter Full Screen" shortcut is now the same as Apple programs (^⌘F). Note that Wizard now requires OS X 10.9 Mavericks or later. If you are running an older operating system, please take time to upgrade your system.

New in Wizard 1.7.24 (Jan 27, 2016)

  • Fix a crash when closing a document while in Full Screen mode on El Capitan
  • Fix a crash associated with Time columns in the Summary view
  • Fix a bug where missing Time values were counted as non-missing in the Summary view
  • Fix a bug where exporting a correlation matrix with categories present produced an invalid CSV file
  • Fix a bug where "Extract Time Component" was not available for time-of-day columns
  • Fix a bug where "Minute of Day" was incorrectly calculated as "Minute of Hour"
  • Fix a bug that sometimes displayed a p-value greater than 1 when running a Mann-Whitney test
  • Fix an interface glitch that sometimes prevented editing numeric cutoffs in the Summary view
  • Improved support for non-US decimal points when creating an Indicator Variable
  • Fix display glitches when opening the Wizard Store on El Capitan

New in Wizard 1.7.23 (Jan 22, 2016)

  • Fix minor interface glitches in the Model view
  • Fix an issue where Date/Time columns displayed out-of-date statistics after dropping rows from the table
  • Improved support for importing XLSX files

New in Wizard 1.7.22 (Jan 15, 2016)

  • Improved compatibility with Numbers 3.6
  • Improved ability to open corrupted documents
  • Fix a crash associated with empty tables

New in Wizard 1.7.21 (Jan 7, 2016)

  • Indicate negative duration values using parentheses
  • Fix a minor interface glitch in the Pivot view when switching between tables
  • Improved support for XLSX files containing colored cells
  • Improved support for SAV files created with Java SPSS Writer [Feature requires In-App Purchase]

New in Wizard 1.7.20 (Dec 17, 2015)

  • Crash fix: Joined text columns sometimes resulted in a crash on OS X 10.11
  • Bug fix: "Extract Date Component" produced non-missing values when the input value was missing

New in Wizard 1.7.19 (Dec 4, 2015)

  • Fix a crash that sometimes occurred when clicking on the pie chart
  • Improved support for SAS, SPSS, and Stata files [Feature requires In-App Purchase]

New in Wizard 1.7.18 (Nov 6, 2015)

  • Added support for Numbers 3.6 files
  • Exporting data from the Summary view now has a progress bar and cancel button
  • Exporting data now writes directly to disk instead of building the file in memory first
  • Many other performance improvements throughout the program
  • Added support for generating the R command for the Friedman test
  • Added support for generating SAS/SPSS commands for repeated-measures tests [Feature requires In-App Purchase]
  • Report the combined significance of constant coefficients for models with multiple sets of coefficients
  • Fix a crash after exporting ROC curves
  • Fix a bug when exporting DTA files with missing values [Feature requires In-App Purchase]
  • Fix a bug where formatting options weren't showing in the Pivot view
  • Fix a number of minor interface glitches
  • Improved support for importing SAS and SPSS command files [Feature requires In-App Purchase]
  • Improved support for SAS catalog files [Feature requires In-App Purchase]

New in Wizard 1.7.17 (Oct 22, 2015)

  • Show ellipses when data is truncated in the Raw Data view
  • Fix a bug where Shapiro-Wilk and one-column Kolmogorov-Smirnov tests on highly repetitious data gave overly conservative results
  • Improved support for exporting Stata .dta files [Feature requires In-App Purchase]
  • Improved support for importing compressed SAS data files [Feature requires In-App Purchase]
  • Improved support for importing SAS catalog files containing a large number of value labels [Feature requires In-App Purchase]

New in Wizard 1.7.16 (Oct 9, 2015)

  • Fix a bug in the CSV importer where "N" was regarded as a missing value
  • Improved support for SAS catalog files [Feature requires In-App Purchase]

New in Wizard 1.7.15 (Oct 2, 2015)

  • Fix a crash associated with Stacked Tables
  • Fix an issue with date/time values sitting on the boundary between two "buckets"
  • Fix a bug in the Predict view when the categories of an outcome variable had been manually reordered

New in Wizard 1.7.14 (Sep 23, 2015)

  • Numeric data imported from Numbers was sometimes incorrectly displayed with currency formatting
  • Treat HH:MM data in CSV files as a time of day, rather than a duration (use "1h 2m" format for duration)
  • Treat "NULL" as missing in CSV files

New in Wizard 1.7.13 (Sep 15, 2015)

  • Improved support for importing multiple tables from RData files
  • Fix a glitch when exporting logistic models to Excel
  • Fix a crash when dividing one column by another in a Stacked Table
  • Fix interface glitches when defining a Recode Variable

New in Wizard 1.7.12 (Aug 7, 2015)

  • Added support for importing from Amazon Redshift (PostgreSQL)
  • Fixed issues when filtering by a date/time column

New in Wizard 1.7.11 (Jul 25, 2015)

  • Fix a crash in the Raw Data view involving Data Filters and date/time columns
  • Fix a number of minor interface issues
  • Improve performance in the Pivot and Summary views for documents having a large number of columns

New in Wizard 1.7.10 (Jul 25, 2015)

  • Fix a crash when closing a document containing a "Count Zeroes" function in the Pivot view
  • Improved support for importing/exporting ranges of missing values in SAV files
  • Improved support for Stata 14 files

New in Wizard 1.7.9 (Jul 9, 2015)

  • Fix a crash when opening a document with a Quantile column
  • Fix a crash when attempting to use a column as its own join key
  • Fix an occasional crash after entering or leaving Full Screen mode
  • Fix a few minor interface glitches
  • Bug fix: the XLS and JSON exporters did not properly respect Data Filters
  • Bug fix: Time-of-day columns derived from other columns were not properly displayed in the Raw Data view
  • Bug fix: weighted log-linear models sometimes produced an error
  • Bug fix: a model's constant term was not included when exporting the coefficient table as XLS
  • Feature: Include prediction intervals when exporting prediction tables

New in Wizard 1.7.8 (Jun 17, 2015)

  • Fix a crash when sorting the Pivot table by a percentile of a text column

New in Wizard 1.7.7 (Jun 11, 2015)

  • Improved support for very large SAS files [Feature requires In-App Purchase]
  • Added support for Stata 14 files [Feature requires In-App Purchase]
  • Change: Display the significance of a model's constant term
  • Fix: Progress bar was sometimes stuck at 100% when importing

New in Wizard 1.7.6 (May 30, 2015)

  • Fix "No database selected" error when refreshing from a database in a saved document
  • Fix display bugs in the Summary view after certain operations (Copy Category Labels, Copy Missing Values)

New in Wizard 1.7.5 (May 20, 2015)

  • Fix a crash when creating numeric columns via the Refresh button
  • Faster importing of large SAS files [Feature requires In-App Purchase]

New in Wizard 1.7.4 (May 13, 2015)

  • Fix a display issue in the Summary view when unchecking filters
  • Fix a crash in the Predict view when a model has either no outcome variables or no explanatory variables
  • Fix "Can't connect" error when attempting to connect to a database using a password containing special characters
  • Support for connecting to databases over IPv6
  • Support for schemas in PostgreSQL
  • Support for character types in PostgreSQL
  • Improved support for importing CSV files with improperly quoted values
  • Improved support for importing variable labels and frequency weights from SPSS files [Feature requires In-App Purchase]
  • Increased maximum length of exported SPSS variable labels from 120 characters to 256 characters [Feature requires In-App Purchase]

New in Wizard 1.7.3 (Apr 29, 2015)

  • New ability to reorder columns in the Raw Data view
  • New exact significance test for small-sample Mann-Whitney tests
  • Bug fix: Reported min and max did not respect filters in the Summary view
  • Fix several minor interface glitches

New in Wizard 1.7.2 (Apr 22, 2015)

  • SPSS and SAS features require In-App Purchase:
  • Import and export case weights (a.k.a. frequency weights, a.k.a. “Treat as Row Counts”) from SPSS files
  • Import missing-value definitions from SPSS files
  • Improved support for reading compressed SAS files
  • New “between” operator for defining missing values

New in Wizard 1.7.1 (Apr 15, 2015)

  • Fix issue when importing multiple tables per sheet in a Numbers document
  • Fix an issue when attempting to import a custom-delimited file without a document open
  • Fix an issue where some of the Summary exporters did nothing

New in Wizard 1.7.0 (Mar 31, 2015)

  • 1-click Data Refresh: Suppose you've imported and cleaned your data, perhaps built a few models -- and then your data changes. Now, thanks to the new "Refresh" button in the toolbar, you can instantly update all of your analyses using fresh data from the original source. Customize how columns are matched up with a convenient popover, and feel free to move or rename the source data file on your computer -- Wizard will automatically keep an eye on it. Command-R to refresh the data, Command-E to configure the link.
  • Revamped menu system: Wizard has a new modular architecture that means you'll only see menus relevant to what you're doing -- that is, Raw Data, Pivot, Summary, Model, and Predict each have their own menu now. Most of the menus are more concise, so you can find what you're looking for faster.
  • JSON support: by popular request, Wizard 1.7 can import JavaScript (JSON) data files. Make sure your data is encoded as an array of objects and Wizard will do the rest. Export any table or result as JSON, too.

New in Wizard 1.6.8 (Mar 12, 2015)

  • Fix an issue with the application failing to launch after several weeks
  • Custom-interval partitions now accept duration strings (e.g. "1d 3h")
  • The CSV importer now accepts timestamps in UTC format
  • Columns imported from Numbers '13 documents were sometimes missing or out of order
  • Added support for importing values from multiple-choice cells in Numbers '09 and Numbers '13 documents
  • Added support for more character encodings when importing SAS and SPSS files (Feature requires In-App Purchase)
  • Exported SAV files now work better with SPSS (Feature requires In-App Purchase)
  • Added support for importing large (2GB+) SAS files (Feature requires In-App Purchase)

New in Wizard 1.6.7 (Feb 27, 2015)

  • Fix a crash when exporting a Pivot table containing missing values to Excel
  • Fix a crash when copying a Stacked table
  • Performance improvements when importing large SPSS files (Feature requires In-App Purchase)
  • Improved support for SPSS command files (Feature requires In-App Purchase)
  • Improved support for dates, times, value labels, and character encodings in SAS files (Feature requires In-App Purchase)

New in Wizard 1.6.6 (Feb 10, 2015)

  • Fix a crash in the SPSS importer (Feature requires In-App Purchase)

New in Wizard 1.6.5 (Jan 31, 2015)

  • Improved support for non-ASCII characters in sas7bdat files (Feature requires In-App Purchase)

New in Wizard 1.6.4 (Jan 22, 2015)

  • Fix a crash when viewing box-plots in the Summary view

New in Wizard 1.6.3 (Jan 15, 2015)

  • Performance and stability improvements on Yosemite

New in Wizard 1.6.2 (Jan 9, 2015)

  • New ability to export "The Bottom Line" (image, test statistic, p-value, etc.)
  • New ability to select multiple Pivot functions at once
  • Use the standard definition of median in case of ties (average of 2 tied values)
  • Improved support for importing number-format information from Excel and Numbers documents
  • Fix bug when attempting to overwrite an existing document
  • Fix a bug with binary response models exported as XLS
  • Minor interface improvements

New in Wizard 1.6.1 (Jan 3, 2015)

  • Fixed a number of minor interface bugs

New in Wizard 1.6.0 (Dec 9, 2014)

  • Duration data: Support for importing and formatting time durations as HH:MM:SS or other formats. Great for analyzing e.g. race results.
  • Combine Pivot functions - You can now add, subtract, multiply, and divide columns in the Pivot table for more insightful reports.
  • Organize filter sets: If you spend a lot of time with Filters, the new version will let you name and organize an unlimited number of filter sets easily. That way you can switch between subsets of the data without having to reselect all the filter conditions individually.
  • Indicator Variables with "OR" conditions: In previous versions, Indicator Variables were equal to 1 when all of the conditions are true. In this version, you have a new option to set the value to 1 when any condition is true.
  • Reorder categories: If you don't like the default ordering of categories in a particular column, you can now drag and drop to rearrange.
  • This release also includes a number bug fixes and stability improvements.

New in Wizard 1.5.7 (Dec 3, 2014)

  • Fix a bug in the way missing values were handled in two-way ANOVA tests

New in Wizard 1.5.6 (Nov 25, 2014)

  • Support DATETIME columns when importing SQLite files
  • The .db extension is now recognized as SQLite
  • Fix a few minor interface bugs
  • Fix a few obscure crashes

New in Wizard 1.5.5 (Nov 12, 2014)

  • Fix several crashes:
  • Viewing confidence intervals of the mean on 10.7 and 10.8 caused a crash
  • Creating a custom covariate partition in the Summary view caused a crash
  • Very long text values sometimes caused a crash
  • Proportional Hazards models with a specified cause of failure caused a crash
  • New features for Contingency Table Analysis:
  • McNemar Test (2 repeated binary measures)
  • Cochran's Q (3 or more repeated binary measures)
  • Stuart-Maxwell Test (2 repeated category measures)
  • "Show Estimation Command" now works in the Summary view, too. (Generates commands for reproducing results in R)
  • Pivot tables have improved support for hierarchical data
  • Column > Subtract now works on date columns
  • Summary view supports cross-column comparisons of category and survival-time data
  • Proportional Hazards models are much faster

New in Wizard 1.5.4 (Nov 6, 2014)

  • Survival curves: dotted lines for censored values, and more grid lines for large graphs
  • Accept percentage values in CSV files
  • Support for importing DBF (dBase) files

New in Wizard 1.5.3 (Oct 31, 2014)

  • Support for Numbers 3.5 documents
  • New repeated-measures tests: Wilcoxon signed-rank test for 2 numeric columns, Friedman test for 3 or more numeric columns
  • Many speed improvements throughout the program
  • Fix a freeze when customizing filters
  • Some date/time values in CSV files were ignored
  • Preserve date/time semantics when creating a new table from a Pivot table
  • Fixed-effect models exported as XLS didn't work properly

New in Wizard 1.5.2 (Oct 17, 2014)

  • A new "Treat as Survival Times" option, which lets you produce survival (Nelson-Aalen) curves, view confidence bands, and perform log-rank tests. Survival analysis is perfect for analyzing failure, relapse, and mortality data, as well as other kinds of event data.
  • Paired t-tests and repeated measures ANOVA: To analyze "before and after" data, just selecting multiple columns in the Summary view and checking the box labeled "Repeated Measures"
  • Text partitions: Now you can group non-category text data into groups, e.g. A-G, H-M, and N-Z.
  • Export image data: The data behind all the graphics in the Summary view can now be exported as CSV or XLS.
  • Zoom to filtered values: There's a new magnifying glass button in the top-right corner of the Data Filters pane that lets you zoom all the graphics to the filtered values.
  • Improved prediction intervals: The Predict view will now draw prediction intervals in the response curve, in addition to displaying the numeric values.
  • Interaction terms: Models can now include separate interaction terms between two explanatory variables. For continuous variables, this is the product of the two terms; for category variables, this is an extra set of dummy variables representing all possible combinations of the two terms. Interaction terms will "just work" in the Predict view and in export XLS models.
  • Reorder outcome categories: If your outcome categories aren't ordered properly, now you can just drag and drop to rearrange them. This

New in Wizard 1.5.1 (Oct 9, 2014)

  • Keep popovers open as you switch windows.
  • New option to hide charts in the Summary view (View > Hide Summary Charts)
  • Improvements to the SAS command importer [Feature requires In-App Purchase]
  • Fix a crash when using a date/time column as a covariate
  • Fix a crash when importing values of infinity or negative infinity

New in Wizard 1.5.0 (Oct 1, 2014)

  • A new "Treat as Survival Times" option, which lets you produce survival (Nelson-Aalen) curves, view confidence bands, and perform log-rank tests. Survival analysis is perfect for analyzing failure, relapse, and mortality data, as well as other kinds of event data.
  • Paired t-tests and repeated measures ANOVA: To analyze "before and after" data, just selecting multiple columns in the Summary view and checking the box labeled "Repeated Measures"
  • Text partitions: Now you can group non-category text data into groups, e.g. A-G, H-M, and N-Z.
  • Export image data: The data behind all the graphics in the Summary view can now be exported as CSV or XLS.
  • Zoom to filtered values: There's a new magnifying glass button in the top-right corner of the Data Filters pane that lets you zoom all the graphics to the filtered values.
  • Purchase Pro features: Non-Pro users can now unlock Pro features on an a la carte basis with In-App Purchases.
  • Improved prediction intervals: The Predict view will now draw prediction intervals in the response curve, in addition to displaying the numeric values.
  • Interaction terms: Models can now include separate interaction terms between two explanatory variables. For continuous variables, this is the product of the two terms; for category variables, this is an extra set of dummy variables representing all possible combinations of the two terms. Interaction terms will "just work" in the Predict view and in export XLS models.
  • Reorder outcome categories: If your outcome categories aren't ordered properly, now you can just drag and drop to rearrange them. This should make Ordered Probit models more immediately useful without having to create ad-hoc columns.

New in Wizard 1.4.15 (Sep 4, 2014)

  • Improve handling of formulas containing errors when importing XLSX files.

New in Wizard 1.4.14 (Sep 1, 2014)

  • Fix incorrect sorting of non-ASCII text
  • Fix a bug in the display of confidence intervals for odds ratios in models

New in Wizard 1.4.12 (Aug 21, 2014)

  • New option to display prediction intervals for multivariate models

New in Wizard 1.4.11 (Aug 16, 2014)

  • NEW: Select a subset of a MySQL / PostgreSQL database using the new graphical query builder. (Or enter your own SQL statements.)
  • NEW: View and optionally exclude the constant term from models
  • NEW: Perform joint significance tests by selecting (Command-clicking) two or more coefficients in the Model view
  • NEW: Control the number of displayed decimal places for predicted values in Preferences
  • Bug fixes:
  • Fix a crash when connecting to a PostgreSQL server under Lion and Mountain Lion
  • Fix a bug where linear regressions couldn't be weighted
  • Fix a bug in the display of R² values for linear models
  • Fix a bug in linear models exported as XLS

New in Wizard 1.4.10 (Aug 8, 2014)

  • IMPORT:
  • Ability to specify the database name if a list of databases can't be obtained from PostgreSQL
  • Ability to import R single object (RDS) files
  • Fix a few bugs when importing RData files
  • MODEL:
  • Ability to model binary outcome variables with a linear model
  • Use chi-squared tests instead of F tests for joint significance testing of non-linear models
  • Test overall model significance by deselecting all explanatory variables (F test or chi-squared test as appropriate)
  • Fix a bug when choosing the omitted category when filters are applied
  • DISPLAY:
  • Ability to resize the Indicator Variable sheet to accommodate long variable names
  • Suppress the thousands separator when extracting the year from dates
  • Fix overlapping text in the hypothesis tester view of the Model screen

New in Wizard 1.4.9 (Aug 4, 2014)

  • Fix a crash when quitting the program from Full Screen mode
  • Support SSL connections to PostgreSQL servers

New in Wizard 1.4.8 (Jul 25, 2014)

  • More convenient links for sending feedback to the developer.

New in Wizard 1.4.7 (Jul 12, 2014)

  • Fix a few glitches in the Predict tab

New in Wizard 1.4.5 (Jun 27, 2014)

  • Fix a crash when opening Wizard under Lion and Mountain Lion

New in Wizard 1.4.4 (Jun 26, 2014)

  • Some Numbers '13 columns were inadvertently skipped on import
  • Various fixes to Joined tables and Stacked tables
  • Various fixes to the Model and Predict views
  • Tooltips in the left-hand source table now look a bit nicer on Mavericks

New in Wizard 1.4.3 (Jun 18, 2014)

  • Fix an issue importing dates from CSV files
  • Fix a crash when exporting XLS data
  • Improve Excel compatibility of exported XLS data
  • Fix an issue when attempting to save after sorting by an aggregate value and then deleting a Pivot

New in Wizard 1.4.2 (Jun 10, 2014)

  • Bug fixes and stability improvements.

New in Wizard 1.4.1 (May 6, 2014)

  • Bug fixes and stability improvements.

New in Wizard 1.4.0 (Apr 29, 2014)

  • FEATURES:
  • Database support: import from SQLite, MS Access, MySQL, and PostgreSQL
  • Numbers '13 support
  • Timestamp / time-of-day support
  • Customizable data partitions. Separate numeric data into groups of equal size, intervals of equal width, or user-defined intervals
  • Best-fit lines on scatterplots, and reference lines on Q-Q plots
  • Visualize critical values and p-values with the new Bottom Line popover (see screenshots)
  • New "Copy Predicted Values" menu item applies a predictive model to the full data set
  • CHANGES:
  • Histograms are much sharper now
  • More tick marks and labels on all the graphics
  • Full access to the Column tools from inside the Raw Data view
  • New preference option: choose a "Friendly" or "Neutral" font for The Bottom Line
  • Filtered and frequency-weighted models run much faster than before
  • Excel output is much prettier -- with bold, italics, and indentation for clarity.
  • NICE TOUCHES:
  • Exporting data now has a progress bar and a Cancel button
  • Support for up to 6 data filters
  • Support for up to 5 pivot columns

New in Wizard 1.3.28 (Apr 24, 2014)

  • Import Boolean (true/false) values from XLS files
  • Fix a display glitch in the Pivot table when applying filters
  • Fix an #N/A! error in exported XLS models

New in Wizard 1.3.27 (Feb 15, 2014)

  • Fix a few #VALUE! errors in exported XLS models

New in Wizard 1.3.24 (Jan 23, 2014)

  • Fix a discrepancy in the displayed p-values for models with a small number of observations

New in Wizard 1.3.23 (Jan 18, 2014)

  • Bug fix: Columns imported from CSV files were sometimes out of order
  • Bug fix: Blank header cells in XLSX documents caused some columns not to be imported
  • Fix a few display glitches in the Raw Data view

New in Wizard 1.3.22 (Jan 3, 2014)

  • Fix a crash when importing XLS files with more than 32,000 rows
  • Fix an issue when importing Numbers '09 documents with many blank footer cells

New in Wizard 1.3.21 (Dec 9, 2013)

  • Fix an unusual crash in the Pivot view
  • Dates imported from CSV files were sometimes off by one day for users in Europe, Asia, and Australia

New in Wizard 1.3.19 (Dec 2, 2013)

  • Improve compatibility with files exported from Numbers '13. (Note that the Numbers '13 file format is not yet supported.)

New in Wizard 1.3.18 (Dec 2, 2013)

  • Fix uncommon freezing issues in the Summary view

New in Wizard 1.3.17 (Dec 2, 2013)

  • Fix an issue importing CSV files that start with a byte-order mark (BOM)
  • Improve error reporting for CSV files that cannot be imported

New in Wizard 1.3.16 (Dec 2, 2013)

  • Fix an issue when importing variable names in XLSX files containing rich-text formatting

New in Wizard 1.3.15 (Dec 2, 2013)

  • Wrap very long chart titles when viewing pie charts
  • Fix an issue with CSV exporting of columns with quotation marks in their names

New in Wizard 1.3.14 (Dec 2, 2013)

  • Fix an issue with importing columns with non-ASCII character names from Numbers documents

New in Wizard 1.3.13 (Dec 2, 2013)

  • Fix a few issues with date columns
  • New rows sometimes appeared in the middle of a data set rather than at the end

New in Wizard 1.3.12 (Dec 2, 2013)

  • Fix importing of true/false fields in XLSX files

New in Wizard 1.3.11 (Dec 2, 2013)

  • Fix an off-by-4-years issue when importing certain XLSX files
  • Fix importing of TSV and CSV files with comment lines that start with the "#" character

New in Wizard 1.3.10 (Sep 10, 2013)

  • NEW Export Pivot tables as CSV or XLS
  • Fix a crash when importing certain XLS files
  • Import time-of-day fields from Excel as a number from 0-24

New in Wizard 1.3.9 (Aug 28, 2013)

  • Fix an intermittent crash in the Summary view
  • Fix inaccurate tooltips

New in Wizard 1.3.7 (Jul 9, 2013)

  • Fix a crash when applying model weights to multiple outcome variables
  • Fix a crash when exporting models as XLS with multiple outcome variables

New in Wizard 1.3.6 (Jun 28, 2013)

  • Support for batch-importing multiple files of the same type
  • New: Count Unique Values function in the Pivot view
  • Fix minor issues with importing from XLS files

New in Wizard 1.3.5 (May 30, 2013)

  • New "Delete Column" menu item when control-clicking a column header in the Raw Data view
  • Fix various issues with Recode variables
  • Adjust standard errors for small sample sizes (unweighted linear models only)

New in Wizard 1.3.4 (May 22, 2013)

  • Fix a display bug in the Summary view when text values contain newlines
  • Fix a crash with models containing both date and non-date explanatory variables
  • Fix a crash when removing a variable from the Model view using the context menu
  • Fix a crash involving text columns joined from another table
  • Fix a crash when deleting a column that is being used to perform a table join

New in Wizard 1.3.3 (May 17, 2013)

  • New menu item: Covariate > Deselect will deselect the active covariate in the Summary view. (You can still deselect by Command-clicking.)
  • New behavior: Deleting a column from the Summary view will immediately select the next column in the table. Ideal for rapidly inspecting / deleting a large number of columns.

New in Wizard 1.3.2 (May 10, 2013)

  • Preserve filter selections when switching between tables
  • Correctly parse numbers surrounded by spaces in CSV files
  • Fix a bug where a blank header cell in an Excel spreadsheet caused subsequent columns not to be imported
  • Fix some issues with PDF export of model images
  • Fix a crash when stacking tables with indicator variables

New in Wizard 1.3.1 (May 3, 2013)

  • Fix a bug where date columns were not always recognized when importing XLSX
  • Fix a crash in the Raw Data view

New in Wizard 1.3.0 (Apr 22, 2013)

  • NEW! Features for working with R — the popular statistical computing package — have graduated from Wizard Pro and are now available in regular Wizard. Import and export R workspace files (.RData), and easily copy models as R code (in the Model view, just choose View > Show Estimation Command). If you've ever been interested in R but felt lost on the command line, Wizard will be your trusted companion.
  • Importing newer Excel files (the XLSX file format). Wizard can now read in XLSX with ease. So if you see any old reviews bemoaning the lack of XLSX support, please note that as of today they are 100% obsolete. Being able to import XLSX is ideal for people who work with large data sets, as the older XLS format cannot store more than 65,000 rows.
  • To make up for several months of missing XLSX support, I went the extra mile with Wizard 1.3 and implemented the ability to import Numbers spreadsheets, that is, files ending in ".numbers". If you choose File > Import Numbers Document, Wizard will scan your spreadsheet and suck in all the data tables that it can find. So if you're a Numbers fan like me, now you can import your data into Wizard without having to export it as XLS first.
  • Fix a crash when zero observations are included in the Model view
  • Fix a bug when importing multiple sheets in XLS documents
  • Fix a bug where Q-Q plots were not properly exported as PDF

New in Wizard 1.2.4 (Mar 28, 2013)

  • New feature: pretty ROC curves for evaluating the performance of binary-outcome models. Just click "ROC curve" in the Model view. More green = better model
  • Improved blank-cell detection when importing Excel spreadsheets
  • Fix crash when joining text columns to foreign tables
  • Fix crash after canceling the creation of a new indicator variable

New in Wizard 1.2.3 (Mar 15, 2013)

  • Set the numeric format directly from the Raw Data view (control-click the column header)
  • Use scientific formatting for very small statistics (e.g. confidence intervals)
  • Fix XLS export for binary-response models
  • Fix a bug relating to long text fields
  • Fix a bug preventing an existing document being "Saved As" itself
  • Fix a bug preventing a document from being saved after deleting a model
  • Minor fixes to the Model interface

New in Wizard 1.2.2 (Mar 7, 2013)

  • Excel import: Improve blank-cell detection

New in Wizard 1.2.1 (Feb 13, 2013)

  • Support for scientific formatting style
  • Export the dispersion parameter of Negative Binomial models
  • Fix a crash when importing older XLS files
  • Fix grayed-out "Join to Table" menu item bug

New in Wizard 1.2.0 (Feb 1, 2013)

  • DATE SUPPORT - THE #1 FEATURE REQUEST:
  • Enter dates manually or import them from any supported file format
  • Compose dates from one or more date component columns (e.g. "year" and "month")
  • View number of records by year, quarter, month, week, or day
  • Pivot numeric data by year, quarter, month, week, or day
  • Compute day of week, day of year, ISO week-numbering year, and more
  • Compute durations: years, months, weeks, or days between two date columns
  • EXCEL EXPORT - THE FEATURE YOU DIDN'T KNOW YOU NEEDED:
  • Export raw data as XLS
  • Export summary, correlation, and coefficient tables as XLS
  • Export models as interactive predictive spreadsheets. This makes a version of the Predict interface available to anyone running Microsoft Excel. See it to believe it!
  • NEW TESTS AND MODELS:
  • Mann-Whitney and Kruskal-Wallis (median test)
  • 2-sample and N-sample Kolmogorov-Smirnov (distribution test)
  • Negative Binomial model (for overdispersed count data)
  • Cox Proportional Hazards model (for failure-time data) -- includes options for stratification, censoring, and multiple causes of failure
  • MISCELLANEOUS FEATURES AND BUG FIXES:
  • Numeric data is now stored in double-precision
  • Support for importing text files with a custom delimiter
  • Address a mysterious crash
  • Many minor tweaks

New in Wizard 1.1.1 (Nov 27, 2012)

  • Fix critical bug where saved multivariate models would not open on Mountain Lion
  • Fix bug in tutorial