Documentation

Analyse-it for Microsoft Excel v2.20 user-guide, providing step-by-step instructions on how to use and benefit from Analyse-it

What's new in this release?

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.