Random Number Generator Using a Normal Distribution

Article translations Article translations
Article ID: 143350 - View products that this article applies to.
This article was previously published under Q143350
Expand all | Collapse all

On This Page

SYMPTOMS

In the versions of Microsoft Excel listed above, the Random Number Generator, using a normal distribution with a random seed, does not produce the same set of random numbers more than once. However, using other distributions with a random seed will continually produce the same set of random numbers.

RESOLUTION

To correct this problem, upgrade to either Microsoft Excel 97 for Windows or Microsoft Excel 98 Macintosh Edition.

STATUS

Microsoft has confirmed this to be a problem in the versions of Microsoft Excel listed at the beginning of this article. This problem was corrected in Microsoft Excel 97 for Windows and Microsoft Excel 98 Macintosh Edition.

MORE INFORMATION

The Random Number Generator returns independent random numbers drawn from a distribution. By using the same distribution with a random seed, the Random Number Generator can be used to produce the same set of random numbers over and over again.

REFERENCES

In Microsoft Excel Version 7.0

For more information about the Random Number Generation analysis tool, click the Answer Wizard in Help and type:
how do I generate random numbers

In Microsoft Excel Version 5.0

Microsoft Excel, "User's Guide," version 5.0, Chapter 31, "Using a Data Analysis Tool"

For more information about the Random Number Generation tool, click the Search button in Help and type:
random

Properties

Article ID: 143350 - Last Review: August 15, 2003 - Revision: 1.1
APPLIES TO
  • Microsoft Excel 95a
  • Microsoft Excel 5.0c
  • Microsoft Excel 5.0a for Macintosh
Keywords: 
kbbug kbprb KB143350
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com