+ Reply to Thread
Results 1 to 11 of 11

Using RAND() with Different Distributions!?

Hybrid View

  1. #1
    mas_it_2000@yahoo.com
    Guest

    Using RAND() with Different Distributions!?

    Hi everyone,

    In Excel, by going to Tools/Data Analysis/Random Number Generation,
    then clicking ok and going to "Distribution" window, you can select any
    distribution available (uniform, normal, ....etc.)

    Now, after I make a selection to a distribution, and then using RAND(),
    wont that mean that my random numbers do follow the selected
    distribution?

    Thanks,
    Mike


  2. #2
    bj
    Guest

    RE: Using RAND() with Different Distributions!?

    No. the random number generation in data analysis willl generate a table of
    random numbers with the given distribution, but it does not change the
    Rand() factorr

    "mas_it_2000@yahoo.com" wrote:

    > Hi everyone,
    >
    > In Excel, by going to Tools/Data Analysis/Random Number Generation,
    > then clicking ok and going to "Distribution" window, you can select any
    > distribution available (uniform, normal, ....etc.)
    >
    > Now, after I make a selection to a distribution, and then using RAND(),
    > wont that mean that my random numbers do follow the selected
    > distribution?
    >
    > Thanks,
    > Mike
    >
    >


  3. #3
    bj
    Guest

    RE: Using RAND() with Different Distributions!?

    No. the random number generation in data analysis willl generate a table of
    random numbers with the given distribution, but it does not change the
    Rand() factorr

    "mas_it_2000@yahoo.com" wrote:

    > Hi everyone,
    >
    > In Excel, by going to Tools/Data Analysis/Random Number Generation,
    > then clicking ok and going to "Distribution" window, you can select any
    > distribution available (uniform, normal, ....etc.)
    >
    > Now, after I make a selection to a distribution, and then using RAND(),
    > wont that mean that my random numbers do follow the selected
    > distribution?
    >
    > Thanks,
    > Mike
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1