+ Reply to Thread
Results 1 to 3 of 3

Creating a Table for showing Intervals between random numbers

  1. #1
    Registered User
    Join Date
    07-11-2012
    Location
    Springfield, MA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Creating a Table for showing Intervals between random numbers

    Hi Friends,

    I would like to create a table that provides the intervals between random numbers as they appear in a list.

    For example, let's use dice. If I have a single dice which has 6 numbers and I roll that dice for say 100 rolls, I'm looking to show the number of times each number of the dice appeared AND the distance between the appearance of each number.

    It would look something like this:

    List of Random Numbers between 1 and 6 Numbers on Dice Number of times appeared First appearance at roll Second appearance at roll Third appearance, etc.. at roll
    2 1 3 3 4 9
    6 2 1 1
    1 3 0
    1 4 5 7 8 14
    4 5 1 8
    6 6 2 2 6
    4
    5
    1

    Any assistance is greatly appreciated. Thanks so much!!!

    Wally

  2. #2
    Forum Expert XLent's Avatar
    Join Date
    10-13-2010
    Location
    Essex, UK
    MS-Off Ver
    various
    Posts
    2,591

    Re: Creating a Table for showing Intervals between random numbers

    so, if you assume your values are in A2:A1001 (2 being in A2) with 1 to 6 in B2:B7 respectively then:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    the above calcs would replicate your table above {edit: I think your table is incorrect for #4}

    given dimensions if the items (1 to 6) are likely to be less than the no. of times they can occur it might make sense, visually, to transpose your result table (i.e. 1 to 6 as headers) ?

  3. #3
    Registered User
    Join Date
    07-11-2012
    Location
    Springfield, MA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Re: Creating a Table for showing Intervals between random numbers

    Thanks you so much!!

    This is exactly what I was looking for. I'm very appreciative. While visually it makes sense to use the 1 to 6 as headers, for this purpose, the display horizontally is what I was looking for.

    Again, Thank you!!!

+ 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. Creating random numbers for bingo games
    By dcbeagle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-11-2018, 01:39 PM
  2. [SOLVED] creating and re-creating 'random' numbers from a specific seed that can be recreated
    By OberonViking in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-15-2014, 04:13 PM
  3. Creating random numbers that add up to a specific number
    By PapaCheese in forum Excel General
    Replies: 1
    Last Post: 06-13-2012, 07:00 PM
  4. Replies: 4
    Last Post: 05-15-2010, 06:57 PM
  5. Creating Random numbers in Excel problem
    By mrosendal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2008, 08:37 AM
  6. Random numbers appearing, calculations showing as zero
    By ophelia in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-25-2006, 10:00 AM
  7. creating random numbers
    By pikachiu132 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-15-2005, 01:55 AM

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