+ Reply to Thread
Results 1 to 5 of 5

Lottery statistics

  1. #1
    Registered User
    Join Date
    05-02-2007
    Posts
    6

    Lottery statistics

    I play 6/49 lottery, so there are 6 columns of numbers. I want to get statistics of each number's history. What I want is to know how much withdrawings it was BETWEEN the withdrawings in which the number occured. For example, if for some number information is 12-1-4-5, that would mean that after the number first occured, it occured in 12th withdrawing, after that in 1st withdrawing (which mean immediately after), then in 4th and so on. Information should be provided for all numbers.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    This might help - please see the attachment.

    I'm not sure that this approach has any statistical validity but good luck anyway!
    Attached Files Attached Files
    Martin

  3. #3
    Registered User
    Join Date
    05-02-2007
    Posts
    6
    Ok, maybe I didn't explain it properly. Part of your example is ok, and part is not. Let's look at your example, for number 2. It shows up after 15 withdrawings, that is ok. Then after 4 withdrawings (if we watch it relative to the previous withdrawing, not to the beginning). It should continue in the same fashion (that's the part I did not explained well), so always relative to the previous withdrawing. Number 2 then shows up after 4, and after that after 1 withdrawing. Correct line should be: 15-4-4-1. I'm sorry to bother you so much, otherwise this book is exactly what I wanted.

  4. #4
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967
    My mistake - please use the substitute cope below on the module1 sheet in the VBA editor. I'd forgotten to reset the start point when the second or subsequent occurence was found.

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    05-02-2007
    Posts
    6
    Now it's perfect! Thanks!

+ 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