+ Reply to Thread
Results 1 to 4 of 4

How to generate random numbers in Beta distribution

  1. 01-28-2019, 10:20 PM #1
    shengjun
    shengjun is offline
    Registered User
    Join Date
    01-28-2019
    Location
    Brisbane
    MS-Off Ver
    Win10
    Posts
    1

    How to generate random numbers in Beta distribution

    I am working on s simulation work and need to use a few thousands random number in Beta distribution. Can someone help me on this. Thanks.
    Reply With QuoteRegister To Reply
  2. 01-29-2019, 06:00 AM #2
    KOKOSEK
    KOKOSEK is offline
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: How to generate random numbers in Beta distribution

    RAND(), RANDBETWEEN(x,y)
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.
    Reply With QuoteRegister To Reply
  3. 02-02-2019, 10:07 AM #3
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: How to generate random numbers in Beta distribution

    Quote Originally Posted by Sulprobil View Post
    Google for
    Wikipedia incomplete beta function
    It is inappropriate to respond with only a suggestion to Google something. Please provide an actual solution or refrain.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  4. 02-02-2019, 04:29 PM #4
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: How to generate random numbers in Beta distribution

    =BETA.INV(RAND(), alpha, beta)
    Last edited by shg; 02-02-2019 at 05:46 PM.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Generate Random numbers from Poisson distribution
    By samot79 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-24-2017, 12:10 PM
  2. [SOLVED] Generation of random numbers from a Lognormal distribution
    By Romoluzzi in forum Excel General
    Replies: 5
    Last Post: 09-14-2013, 09:26 AM
  3. Random distribution of numbers...
    By Darth269 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-22-2013, 06:11 AM
  4. [SOLVED] Custom Distribution? (Assign specific probability to generate random numbers)
    By eduardo081092 in forum Excel General
    Replies: 1
    Last Post: 03-26-2013, 02:24 PM
  5. [SOLVED] How do you generate random numbers in a normal distribution?
    By Ladee_bird in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-13-2013, 08:18 AM
  6. vba code to generate random z-scores for normal distribution
    By bruceday in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-30-2012, 02:07 PM
  7. How to generate a random number for a normal distribution between a max and min
    By MPaq in forum Excel General
    Replies: 6
    Last Post: 12-05-2008, 02:31 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1