Logo image
Microsoft Excel’s ‘Not The Wichmann–Hill’ random number generators
Journal article   Peer reviewed

Microsoft Excel’s ‘Not The Wichmann–Hill’ random number generators

B.D. McCullough
Computational statistics & data analysis, v 52(10), pp 4587-4593
2008

Abstract

Microsoft attempted to implement the Wichmann–Hill RNG in Excel 2003 and failed; it did not just produce numbers between zero and unity, it would also produce negative numbers. Microsoft issued a patch that allegedly fixed the problem so that the patched Excel 2003 and Excel 2007 now implement the Wichmann–Hill RNG, as least according to Microsoft. We show that whatever RNG it is that Microsoft has implemented in these versions of Excel, it is not the Wichmann–Hill RNG. Microsoft has now failed twice to implement the dozen lines of code that define the Wichmann–Hill RNG.

Metrics

12 Record Views
33 citations in Scopus

Details

UN Sustainable Development Goals (SDGs)

This publication has contributed to the advancement of the following goals:

#4 Quality Education

InCites Highlights

Data related to this publication, from InCites Benchmarking & Analytics tool:

Web of Science research areas
Computer Science, Interdisciplinary Applications
Statistics & Probability
Logo image