What's New

Analyse-it is constantly improving with each release. All improvements are shown below so you can see what's changed, and decide whether an update affects you.

Version 2.20

Added support for Excel 2007 expanded worksheet size: 1,048,576 rows and 16,384 columns.
Fixed crash on Refresh/Collate caused by bug in Excel 2007 Service Pack 2.
Fixed issue on Refresh/Collate when the workbook/worksheet containing the dataset had an apostrophe in the book/sheet name.

Version 2.14

Fixed percent style re-definition warning that sometimes appeared on report output.
Fixed box-plots drawing where connecting lines sometimes appeared.
Change to rounding of degrees of freedom in CLSI precision.
Added option to suffix name of diagnostic test with /H or /L to force ROC algorithm to treat higher/lower values as abnormal.
Added UpdateReport function to allow updating an Analyse-it report from VBA.

Version 2.12

Fixed issue with significant figures formatting on the regression equation (on the scatter plot) for very large coefficients.
Fixed Kruskal-Wallis contrasts p-value to a maximum of 1 (Bonferroni method can, in rare cases,calculate p-values larger than 1).
Fixed cosmetic issue, due to a bug in Excel 2007 charts, where the horizontal X axis appeared sloped.
Update network licence no longer requires re-activation

Version 2.11

Added check to ensure all observations for Weighted Deming regression are greater-than zero.
Changed ROC AUC confidence interval to be bounded between 0..1. No changes made to the AUC confidence interval calculation.
Fixed label on regression output that shows the confidence level %, which always showed as 95% even if a different level was requested. The confidence intervals calculated are correct, and no changes made to the calculations.

Version 2.10

Fixed issue with CV on Weighted Deming Regression, where Analyse-it expected CV as a proportion rather than percentage when one methods CV was specified and other calculated from replicates.
Fixed issue with Mark Outlier tool on non-English regional settings where comma was used as a thousand separator.
Added Help button to test dialog box to open help for the test.
Added index to Help.

Version 2.09

Fixed code-signing certificate expiry issue.
Statistics in chart legends are now formatted to same precision as the source variables.
Fixed display issue, where an advisory label indicating when methods compared using Passing-Bablok have a non-linear relationship (p-value > 0.10) was not shown.

Version 2.08

Fixed labelling of > and >= cut-off operators, which were performing >= and > respectively, on Test Performance > Qualitative in Method Evaluation edition.

Version 2.07

Fixed regression residual histogram scaling on Excel 97-2003.

Version 2.06

Fixed chart axis label positioning that appeared on some non-English language versions of Microsoft Excel.

Version 2.05

Kolmogorov-Smirnov now uses the method of Dallal & Wilkinson (The American Statistician, 1986, Vol 40, No 4, pg 294-296) for computation of p-values. The new method is more accurate for small sample sizes.
Kolmogorov-Smirnov and Anderson-Darling now report the D and A2 statistic directly rather than the sample stabilized A* and D*.
Added 1st and 3rd Quartile to comparative descriptives output.
Added TP / TN / FP / FN to ROC curve output.

Version 2.04

Added Quick Start demo to help.

Version 2.00

New! True Excel 2007 support for the new Office RibbonBar, making working with Analyse-it even easier and faster.
New! Templates and wizards to simplify setting up datasets.
Improved! Almost every test in Analyse-it is updated and improved, with more statistics and confidence intervals.
Improved! Frequency histogram, and dot-, mean- and box-plots can be customised to produce any of the commonly used variations.
Extensive improvements to the Method Evaluation edition (formerly called the Clinical Laboratory module).
Improved! Reports now include larger, easier to read charts, and a cleaner modern look.