Loopy lotto result

[gcol]

I got the results from the main lotto website

http://www.national-lottery.co.uk/player/p/results/resultsHistory/resultsHistoryDownload.do

the download file is separated by commas so it's easy to import into a spreadsheet. I didn't change anything just took an average at the bottom of each column.

Your right there hasn't been a 50!!

Ah, I don't use Internet explorer, I use Opera and it didn't give me the option of opening with excel. Have sorted it by using IE7. Cheers.

 

[empip]

If you paste the csv comma separated file into excel and you find the data in one column. ( for example the data quoted copied directly from the web page then pasted into excel sheet )

Select relevant data, use <data> <text to columns> choose delimiters comma or space etc to parse data into seperate columns.

Usually any further pastings of csv or other delimited data will be treated similarly... What to do??

Dave Peterson 6/12/2006 4:39 PM PST

Answer

You can close and reopen excel (yech!)

Or you can put some dummy data into a cell
data|text to columns
delimited
uncheck all the options
and finish up.

Then clean up that dummy data in that cell.

wraith_oz wrote:
>
> When I've used copy and paste of text into a workbook followed by
> Data-Text-to-columns once, excel seems to assume that every future paste of
> text also requires a text-to column conversion even when I don't want that to
> happen. How do I stop this occurring.
>
> thanks
>
> john bell

--

Dave Peterson

I think that means, settings used in the 'data' wizard will be retained for next 'pasting', probably without displaying the 'wizard'.
=============
Furthermore, from a data modelling point of view, using Excel's < Data Analysis > < Random number Generation > Several statistical distributions of generated random numbers can be selected.

...The Random Number Generation analysis tool fills a range with independent random numbers that are drawn from one of several distributions. You can characterize the subjects in a population with a probability distribution. For example, you can use a normal distribution to characterize the population of individuals' heights, or you can use a Bernoulli distribution of two possible outcomes to characterize the population of coin-flip results...

1000 random numbers with 'uniform' distribution, between 1 and 49 have an average within a few decimal places of 25.

 

[holmslaw]

Ask the question again in 14,000,000 years.

 

[wolfboy]

Guys sorry, I never meant exactly 25 opps, guess I should have been more specific.

I have never won more than a tenner either!!

 

[Trazor]

Ask the question again in 14,000,000 years.

Actually the odds will be .....10,068,347,520 to 1 against, being exactly 25.0
As they will be required in a specific order, to fill the columns correctly.

1000 random numbers with 'uniform' distribution, between 1 and 49 have an average within a few decimal places of 25.

Hmmmm, not sure how random numbers can be uniform...

 

[empip]

...The Uniform Distribution, also called a rectangular distribution, is one in which every value has an equally likely chance of occuring. Examples are roll of a die, drawing of a lottery number...

Seems to fit the bill as near as f'k it is to swearing.

 

[ModernMaterials]

S = (n x n+1)/2 .... So 1 to 50 adds up to 1275, divide by 50 gives you 25.5 not 25

but 1 - 49 /2 adds up to 1225 /50 gives you 25 as he first said.

so he was wrong about the sequence it should be 1 - 49 not 1 - 50 but 25 was the correct answer.

 

[Trazor]

S = (n x n+1)/2 .... So 1 to 50 adds up to 1275, divide by 50 gives you 25.5 not 25

but 1 - 49 /2 adds up to 1225 /50 gives you 25 as he first said.

Had you bothered to read the whole thread, we all knew that.

so he was wrong about the sequence it should be 1 - 49 not 1 - 50 but 25 was the correct answer.

So you wish to congratulate him for giving the correct answer to the wrong question............Remarkable.

 

[megawatt]

 

[D_Hailsham]

What is more interesting is to look at the frequency each number occurs. In theory, and given enough time, each number should occur exactly the same number of times. But it does not, as the table below shows.

No - Times
38 - 227
25 - 214
31 - 210
11 - 205
43 - 205
6 - 202
23 - 202
44 - 199
47 - 199
12 - 196
30 - 195
33 - 195
45 - 195
48 - 195
9 - 193
10 - 190
22 - 190
40 - 190
42 - 190
28 - 187
4 - 186
35 - 186
49 - 186
7 - 185
8 - 185
17 - 185
14 - 184
32 - 184
46 - 184
2 - 183
24 - 183
29 - 183
3 - 180
37 - 180
1 - 179
26 - 179
27 - 179
21 - 177
18 - 176
34 - 175
39 - 175
15 - 174
19 - 173
36 - 172
5 - 170
20 - 165
16 - 164
41 - 161
13 - 157

There may be some truth in the idea that the number 13 is unlucky!

 

[doitall]

That may be true DH but there's 157 millionaires who think otherwise

 

[D_Hailsham]

That may be true DH but there's 157 millionaires who think otherwise

My initial reaction was: of course, why did I not think of that? But something made me think again and I realized that this is not correct, which explains the delay in responding.

There were 141 occasions when 13 was a main ball but some of these could have been a rollover, because those who chose 13 did not have all the other numbers correct. On 16 occasions the 13 was the bonus ball so the punter would not have won the top prize.

There is no way of calculating how many winners have had 13 as one of their numbers.

 

[^woody^]

Never mind the all past numbers, does anyone know tonights 6 numbers?

 

[doitall]

Actually there was 217 Millionaires with number 13.
Draw No 17-28-79-89-90-95-108-112-118-146-161-211-212-221-224-225-236-2
42-253-265-273-292-300-315-331-338-339-351-395-401-416-438-478-
489-506-511-517-529-530-577-584-596-624-636-639-659-661-676-687-
689-692-743-764-765-779-788-803-809-833-846860-895-898-902-903-
905-912-921-928-973-987-1001-1007-1023-1028-1030-1032-1043-1047-
1066-1108-1124-1153-1160-1180-1197-1218-1223-1225-1240-1251-1252
-1254-1255-1275.

Draw 221 6 people won £709,579
Draw 351 8 people won £392,465
Draw 401 4 people won £782,534
Draw 416 8 people won £715,534
Draw 489 5 people won £858,629
Draw 541 5 people won £567,052
Draw 641 5 people won £567,388
Draw 672 9 people won £711,607
Draw 823 7 people won £333,848
Draw 851 3 people won £793,532
Draw 986 5 people won £980,846
Draw 1010 11 people won £774,505
Draw 1199 3 people won £925,940
Draw 1201 3 People won £891,682
Draw 1203 3 people won £845,147
Draw 1239 3 people won £724,242
Draw 1247 3 people won £785,425

Draw Numbers with 13 that rolled over.
83-86-101-129-249-332-381-422-505-593-706-711-727-742-795-825-830
-927-955-1002-1055-1083-1126-1133-1159-1213-1236-1259-1261

And the first ever Number drawn, for those that can’t remember was No30, and the first bonus ball was No10

Finally the most likely set of numbers to win a prize is.
01-07-22-25-31-47