What does Excel's RAND function really do


Joined
Nov 10, 2006
Messages
2
Reaction score
0
I am trying to match a clients spreadsheet where they are using RAND() to generate values for the cumulative inverse standard normal distribution. According to Excel's built in documentation RAND returns values greater than or equal to zero and less than one. If this was true I believe I should eventually see a random number equal to zero be returned. If that happened then the function NORMSINV(0) would return a value of #NUM!. This has never happened after millions of trials. This leads me to believe that RAND is actually returning values between 0 and 1. Has anyone seen an Excel documentation that confirms this is the case?

Thanks
Dave
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top