alphil2001 said:

**Hi All,**

Ive just joined this forum and am new to all of this!

Can anyone tell me if by using the excel statistical tools add-in can help choose the right numbers for the UK lotto?

I have come up with some was of predicting ranges which is right sometimes, but cant seem to be able to use the standard error and standard deviation? what do these numbers represent?

Also when the stats are worked out, what do the kurtosis and skewness numbers represent in relation to the mean and meadian?

thanks

hope my questions are clear

kind regards

alphil2001

You have to be more splicit; what data do you want to analyse with excel?

If you have a file with past draws of your lottery, you have to count and get frequencies of numbers or groups of numbers and then you can analyse those frequencies.

If you have little statistical experience it will be more difficult.

Let's say you count the frequencies of each number of your lottery during 200 draws as this (this is hyphotetical not real):

Freq of #1: 30

Freq of #2: 33

.....

Freq of #49: 27

You put the frequencies in a column of excel (e.g. from A1 to A49) and select them all. Now you click in Tools Menu and pick "Add-in". Choose Analysis Toolpack and there you have many statistical tests (descriptive , ...). If you choose one, excel just calculate for the selected data you specify.

Excel can calculate many things for you but it's not possible to give you the right numbers for UK.

If you don't know some statistical concepts, just go a newsgroup related and ask your questions there. You see ... lotto players don't like to show their statistical knowledge to others

Frank