+ Reply to Thread
Results 1 to 2 of 2

Seeking ability to generate Random Number distribution with given mean and SD.

  1. #1
    Registered User
    Join Date
    12-07-2020
    Location
    Ft Worth, TX
    MS-Off Ver
    365
    Posts
    1

    Question Seeking ability to generate Random Number distribution with given mean and SD.

    I'm preparing data to run stats on for training course.
    Purpose: show Cp and Cpk with varying mean and SD.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,802

    Re: Seeking ability to generate Random Number distribution with given mean and SD.

    Not much to go on here.

    Since mean and SD (assuming this is standard deviation) are the two parameters that describe a normal distribution, perhaps you are asking about generating random numbers from a normal distribution? This is usually done by feeding uniform random numbers (like from Excel's RAND() function) into an inverse normal distribution function (like NORM.INV() https://support.microsoft.com/en-us/...b-2278a9db7e13 ). =NORM.INV(RAND(),mean,standard deviation)

    Was my guess close, or did I completely misunderstand your brief question?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to generate random numbers in Beta distribution
    By shengjun in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-02-2019, 04:29 PM
  2. [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
  3. Replies: 5
    Last Post: 06-21-2013, 10:40 AM
  4. Replies: 1
    Last Post: 03-26-2013, 02:24 PM
  5. 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. Replies: 6
    Last Post: 12-05-2008, 02:31 PM

Tags for this Thread

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