Page 1 of 3 1 2 3 LastLast
Results 1 to 15 of 39
  1. #1
    Join Date
    Aug 2010
    Location
    Canada & TX endless summer
    Posts
    2,119

    Hits by Position

    I have created a spreadsheet that counts the hits by postion for the first 2,974 draws of Canada's Lotto 6/49 (to July 21, 2012). This information should be equally valid for any 6/49 game with one bonus number.

    The data are sorted in 3 ways. The first table tells you how many times each number has appeared in the 6 main numbers and as the bonus number.

    The second table presents the same data as percentages by position. Here you can see what percent of position totals are accounted for by each number. For example, number 1 accounts for 12% of all first positon numbers and numbers less than 10 appear in the first position 72% of the time.

    The third table presents the data as percentages by number. For example, number 48 has 9% of its appearences in the 5th positon, 78% in the 6th position and 13% of its appearences as the bonus number.

    Hopefully this information will be of use to someone. You can download the file at
    [url]https://docs.google.com/open?id=0B68a-JI-D3_pZ3pKd0VhSDVwSjQ[/url]

    Enjoy

  2. #2
    Join Date
    Aug 2010
    Location
    Canada & TX endless summer
    Posts
    2,119

    Exclamation

    It has been brought to my attention that viewers have not been allowed to download this file.

    This has now been corrected and anyone with the link will be allowed to download the file. Sorry if this caused anyone problems.

  3. #3
    Join Date
    Apr 2003
    Location
    UK
    Posts
    1,584
    Hi Icewynd,

    I managed to look at the three tables online but there is nothing that will allow me to download the file.
    I just thought I would let you know.

    Regards,
    PAB


    -∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
    12:45, restate my assumptions.
    Mathematics is the language of nature.
    Everything around us can be represented and understood through numbers.
    If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

  4. #4
    Join Date
    Apr 2003
    Posts
    388
    i also can view it as text. copy and paste is only way to save it.

    if i select share it offers me to submit my email to be allowed to share the spread sheet with the creator.

  5. #5
    Join Date
    Apr 2003
    Location
    UK
    Posts
    1,584
    Thanks for the reply savagegoose,

    I did manage to get the information using COPY & PASTE but for some reason I had to do it one column at a time.
    I think the download was probably time limited in some way.
    Anyway, I have it now.
    Thanks.

    Regards,
    PAB


    -∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
    12:45, restate my assumptions.
    Mathematics is the language of nature.
    Everything around us can be represented and understood through numbers.
    If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

  6. #6
    Join Date
    Apr 2003
    Posts
    388
    hey icy i have some raw data on google spread sheets if its not too much trouble could you run it thru your routine , i like the %'s display.
    i think i have share publically too, here it is

    [url]https://docs.google.com/spreadsheet/ccc?key=0AlwFpybp6ZlndGVhSEpSX2tEVER5SldwcDJYV1lxN nc[/url] raw data is on the left like 20 years ill add the last few months now

  7. #7
    Join Date
    Apr 2003
    Posts
    388
    ok its very biased but i have never picked a decent winner, any help would be good ta

  8. #8
    Join Date
    Apr 2003
    Location
    UK
    Posts
    1,584
    Hi savagegoose,

    I downloaded the file and there are no Pivot Table dropdowns which is strange because on my phone there are.
    Have you tried downloading it, and if so, is it the same for you?

    Regards,
    PAB


    -∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
    12:45, restate my assumptions.
    Mathematics is the language of nature.
    Everything around us can be represented and understood through numbers.
    If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

  9. #9
    Join Date
    Aug 2010
    Location
    Canada & TX endless summer
    Posts
    2,119
    Quote Originally Posted by savagegoose
    hey icy i have some raw data on google spread sheets if its not too much trouble could you run it thru your routine , i like the %'s display.
    Sure, Savage. Might take a day or so, as I am a bit pressed today.

  10. #10
    Join Date
    Apr 2003
    Posts
    388
    oh hell man take as long as you like. i figured you would prob like to look at these numbers, as the game is biased, and you will notice it as soon as you mash the data.

    or if you make a copy and share the copy with me i can mess with it and wont wreck your good work im savagegoose at gmail etc. just an idea

  11. #11
    Join Date
    Apr 2003
    Location
    UK
    Posts
    1,584
    Originally Posted by Icewynd
    I have created a spreadsheet that counts the hits by postion for the first 2,974 draws of Canada's Lotto 6/49 (to July 21, 2012). This information should be equally valid for any 6/49 game with one bonus number.

    The data are sorted in 3 ways. The first table tells you how many times each number has appeared in the 6 main numbers and as the bonus number.

    The second table presents the same data as percentages by position. Here you can see what percent of position totals are accounted for by each number. For example, number 1 accounts for 12% of all first positon numbers and numbers less than 10 appear in the first position 72% of the time.

    The third table presents the data as percentages by number. For example, number 48 has 9% of its appearences in the 5th positon, 78% in the 6th position and 13% of its appearences as the bonus number.
    For anyone who is interested, I have re-created and uploaded a file that Icewynd's original post included.
    It does give some interesting and useful statistics.
    All you need to do is once you have calculated the number of times each number has been drawn in each position and the number of times the Bonus Ball has been drawn for each number is to replace the data in cells C5:I53 with that information.
    Although the file is setup specifically for a 649 Lotto with a Bonus Ball you could easily adapt this to fit other Lotto's.

    Copy & Paste the following link into your browser and hit enter.

    http://www.mediafire.com/view/?9bbyvi4aizcl5vi

    NOTE

    This is Icewynd's work and NOT mine, I have just re-created his data because of the difficulty with the original GoogleDocs file.

    Have fun!

    Regards,
    PAB


    -∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
    12:45, restate my assumptions.
    Mathematics is the language of nature.
    Everything around us can be represented and understood through numbers.
    If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

  12. #12
    Join Date
    Apr 2003
    Posts
    388
    thanks man

  13. #13
    Join Date
    Apr 2003
    Location
    UK
    Posts
    1,584
    You're welcome savagegoose ,

    I hope you find it useful.

    Regards,
    PAB


    -∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-
    12:45, restate my assumptions.
    Mathematics is the language of nature.
    Everything around us can be represented and understood through numbers.
    If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.

  14. #14
    Join Date
    Aug 2010
    Location
    Canada & TX endless summer
    Posts
    2,119
    Thanks PAB. I meant to do the same, but ran out of time yesterday.

    Very kind of you to make this available.

  15. #15
    Join Date
    Apr 2003
    Posts
    388
    here is a pic of my results, i accidently choped off the number 38 , and for life of me cant seem to get the sheet to recalc ther cant be 35 results in colum 3, ohh unless there is an error in the chart like numbers not being in right oprder lol

    ill check

Page 1 of 3 1 2 3 LastLast

Similar Threads

  1. California Fantasy 5 8-22-11
    By Mr_Rich in forum International & State Lotteries
    Replies: 42
    Last Post: 09-29-2011, 12:56 AM
  2. 6/49 Discussion For November 24, 2004
    By gsobier in forum Lotto 649
    Replies: 124
    Last Post: 11-25-2004, 04:33 PM
  3. 6/49 Discussion For October 02, 2004
    By gsobier in forum Lotto 649
    Replies: 65
    Last Post: 10-04-2004, 02:12 PM
  4. 6/49 Discussion For June 26, 2004
    By gsobier in forum Lotto 649
    Replies: 33
    Last Post: 06-28-2004, 03:07 AM
  5. LottoStatisticsXL-BPS TRIAL
    By hot4 in forum Lotto Software
    Replies: 5
    Last Post: 09-23-2003, 01:08 PM

Posting Permissions

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