Statistics add-in software for statistical analysis in Excel

11-Aug-2015 The numerical accuracy of Analyse-it against the NIST StRD

Business Statistics

A critical feature of any analytical and statistical software is accuracy. You are making decisions based on the statistics obtained and you need to know you can rely on them.

We have documented our software development and validation process previously, but another good benchmark to test statistical software against is the NIST StRD. The Statistical Engineering and Mathematical and Computational Sciences Divisions of NIST’s Information Technology Laboratory developed datasets with certified values for a variety of statistical methods against which statistical software packages can be benchmarked. The certified values are computed using ultra-high precision floating point arithmetic and are accurate to 15 significant digits.

For more information about the NIST StRD see:

https://www.itl.nist.gov/div898/strd/

We tested version 4.00 of Analyse-it against the NIST StRD on an Intel Xeon dual processor PC.

No statistical package achieves perfect accuracy for all the tests and no one package performs best for every test. Most statistical packages use IEEE754 double precision (64bit) floating point arithmetic and due to finite precision, round-off, and truncation errors in numerical operations, are unable to obtain the exact certified value.

In the tests:

  • Analyse-it performed consistently amongst the best on all tests.
  • Analyse-it performed better than some of the most popular well-known statistical packages.

For more information on the performance of Analyse-it against the NIST StRD, and to download the workbooks containing the analyses, see:

/support/NIST-StRD

Previous post
Analyse-it 4.0 released: Support for CLSI guidelines, and Measurement Systems Analysis
Next post
Analyse-it 4.20 released: Support for Excel 2016

Comments

Hi,
I'm a PhD in computer science and an entrepreneur, I work in the field of numerical accuracy of computer calculations for critical applications. Your approach is very interesting, alors I didn't know about this database so thanks a lot for that. But I was wondering, is there a more recent one? It looks like this one is rather old. Is there no demand at all for a new benchmark on this topic ?

Sincerely,
Arnault
Ioualalen
Friday, 28 August, 2015 14:12

Comments are now closed.

Tags
  • All (65)
  • Business (10) 
  • Case studies (2) 
  • Excel (6) 
  • In development (16) 
  • Method validation (19) 
  • Plots (2) 
  • Press releases (1) 
  • Publications (1) 
  • Releases (35) 
  • Statistics (17) 
  • Using Analyse-it (31) 
Latest posts
  • A New Year. A New Edition.
  • Analyse-it v6.10: Survival Analysis and other improvements
  • Analyse-it v5.90: Support for the updated CLSI EP6-Ed2 protocol and inverse predictions
  • Analyse-it 5.50 to 5.65: Recent improvements
  • COVID-19: Calculating the detection limit for a SARS-CoV-2 RT-PCR assay using Analyse-it
  • COVID-19: Calculating PPA/NPA agreement measures using Analyse-it
  • Diagnostic accuracy (sensitivity/specificity) versus agreement (PPA/NPA) statistics
  • COVID-19: Establishing the diagnostic accuracy (sensitivity/specificity) of a test using Analyse-it
  • Why the diagnostic test 'accuracy' statistic is useless
  • Sensitivity/Specificity and The Importance of Predictive Values for a COVID-19 test
Most popular posts
  • Announcing the Analyse-it Quality Control & Improvement Edition
  • Analyse-it 4.0 released: Support for CLSI guidelines, and Measurement Systems Analysis
  • Analyse-it 3.80 released: Principal Component Analysis (PCA)
  • Recent improvements in Analyse-it 3.76 and our first video tutorial!
  • Our software development and validation process
  • The numerical accuracy of Analyse-it against the NIST StRD
  • Quantiles, Percentiles: Why so many ways to calculate them?
  • Handbook of Parametric & Non-parametric Statistical procedures
  • A sombre note: Professor Rick Jones
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.