Share

how to use the standard deviation in lottery 01 to 25 where 15 numbers are drawn?

Avatar

how to use the standard deviation in lottery 01 to 25 where 15 numbers are drawn?
could someone help with how to use the standard deviation 25/15? please

Todd's avatar - Cylon 200.jpg

<Moved to Mathematics forum>

Please post in the appropriate forum ... thank you.

Avatar
In response to dr san

I suspect people would like to respond but are not sure what you're asking. The standard deviation is a statiscal measure of the spread or dispersion of a data set. First we must be clear whether you seek the STD of the entire population of date you're concerned about, or the std of a sample set. In either case the standard devationncan be thought of as the overage distance of an item in the data set  from then mean (average). Again I'm not sure what you're asking, but yiu can calculate the standard deviation of a set of numbers this way (follow the STEPS):
1. Find the mean...add each number, then divide by the number of items.

2. Subtract the mean from each number. You will get an eqjual number of negative and positive value values
3. Square each result in step (2).
4. Add the squares from (Step 3).
5. Now for a sample, DIVIDE the sum of squares obtained in step (4) by the number of items minus 1. KIf the number of items is 10, divide by 9, and so son. You now have what we call the Variance.
6. The standard deviation is simply the square root of the variance, so find he square root of the result in Step 5.
I hope this helps. It could be easily automated i Excel.

Avatar

hello, truedookie,  thanks for viewing the post, ok that's it, can you put it in excel? my lottery is 01 to 25 15 numbers are drawn, can I register for the draws, when you win a good prize will you be rewarded, please? thank you

Avatar

hello 

 draws in 25/15 lottery

02 03 05 06 09 10 11 13 14 16 18 20 23 24 25
01 04 05 06 07 09 11 12 13 15 16 19 20 23 24
01 04 06 07 08 09 10 11 12 14 16 17 20 23 24
01 02 04 05 08 10 12 13 16 17 18 19 23 24 25
01 02 04 08 09 11 12 13 15 16 19 20 23 24 25
01 02 04 05 06 07 10 12 15 16 17 19 21 23 25
01 04 07 08 10 12 14 15 16 18 19 21 22 23 25
01 05 06 08 09 10 13 15 16 17 18 19 20 22 25
03 04 05 09 10 11 13 15 16 17 19 20 21 24 25
02 03 04 05 06 08 09 10 11 12 14 19 20 23 24
02 06 07 08 09 10 11 12 16 19 20 22 23 24 25
01 02 04 05 07 08 09 10 11 12 14 16 17 24 25
03 05 06 07 08 09 10 11 13 14 15 16 17 19 23
01 02 05 06 07 09 13 14 15 18 19 20 21 23 25
01 02 04 06 08 10 12 15 16 18 19 21 23 24 25
02 05 06 07 08 10 12 13 15 17 19 21 23 24 25
01 02 03 05 06 07 09 13 14 16 17 18 19 20 21
02 06 07 08 10 11 14 15 17 18 19 20 22 23 24
02 05 06 07 08 10 11 13 14 15 16 17 20 23 24
03 04 06 07 08 09 10 14 16 17 18 19 20 23 24
01 02 04 05 08 11 14 16 18 19 20 22 23 24 25
01 02 03 04 05 06 07 09 10 12 13 14 15 22 25
01 03 04 05 06 08 10 11 12 14 16 17 18 19 20
01 02 03 05 07 10 11 14 17 19 20 21 23 24 25
01 02 03 04 05 06 07 09 13 14 16 20 22 23 24
05 07 08 09 10 11 13 14 16 17 19 20 21 22 23
03 06 08 10 11 12 13 14 15 18 20 21 22 24 25
01 03 07 09 10 11 12 13 14 16 17 18 19 20 21
01 04 05 06 08 09 13 14 16 17 19 20 21 22 24
01 02 03 04 06 07 08 11 14 17 19 20 21 22 23
01 02 03 04 09 13 14 15 17 19 20 21 22 24 25
01 02 04 06 07 09 10 11 14 15 16 17 20 22 23
01 02 05 07 08 10 11 12 14 16 19 20 21 23 24
01 02 04 07 08 09 10 11 15 16 18 19 20 21 23
01 04 05 06 11 12 13 14 16 17 19 21 22 23 25
01 04 05 07 08 10 11 14 17 19 20 21 22 23 24
01 03 04 05 08 09 10 11 13 15 20 21 22 23 24
01 02 03 06 07 08 09 10 13 14 15 16 22 24 25
02 07 08 09 11 13 14 15 17 18 19 21 22 23 24
01 02 05 07 08 10 12 13 14 16 17 20 21 22 24
02 03 04 09 12 13 15 16 17 18 19 20 21 23 25
01 03 04 05 06 08 11 12 14 15 17 21 22 24 25
01 03 06 07 08 09 10 14 17 18 19 20 22 23 24
03 04 05 06 10 11 12 13 14 18 19 21 23 24 25
01 02 03 05 07 09 14 16 17 18 19 21 23 24 25
01 02 04 05 06 08 10 11 14 18 19 21 23 24 25
01 02 03 04 05 06 08 10 11 13 15 18 20 22 25
02 05 06 07 11 13 15 16 17 18 19 20 21 22 23
02 04 05 06 08 11 13 15 16 19 20 21 22 23 24
01 02 03 06 07 09 10 11 12 13 19 20 21 23 25
01 03 05 06 07 08 11 13 14 16 17 20 21 22 23
01 02 04 08 09 11 12 13 15 16 21 22 23 24 25
01 02 03 06 07 09 11 12 14 17 18 19 20 23 24
02 04 05 06 07 08 09 12 14 16 18 20 21 22 24
02 03 04 05 06 07 08 09 12 13 15 16 18 19 25
01 02 05 09 12 13 14 15 16 17 19 20 22 23 24
01 02 03 04 06 07 08 11 12 17 19 20 21 22 25
03 04 05 06 11 12 13 14 15 16 17 18 19 20 22
01 03 05 06 07 08 10 11 13 14 15 19 20 23 25
01 02 03 04 05 08 11 16 17 18 19 22 23 24 25
01 04 05 09 11 12 13 14 15 16 19 20 22 23 25
01 03 07 08 09 11 13 14 15 16 17 18 20 24 25
04 08 09 10 11 12 13 16 17 19 20 21 22 24 25
01 02 03 06 07 08 09 10 13 14 17 18 20 23 25
01 02 04 07 10 15 16 17 18 19 20 21 22 23 25
01 02 04 08 10 11 14 15 16 17 20 21 22 23 24
05 07 08 09 10 11 12 13 15 16 20 21 22 23 24
01 02 03 05 06 07 08 09 10 12 16 17 22 23 25
01 04 07 08 09 10 11 15 17 18 19 20 21 23 24
01 02 03 05 06 09 10 12 14 15 16 19 20 24 25
01 03 05 06 08 09 11 13 14 15 16 18 21 22 23
01 02 05 07 08 11 12 13 15 16 17 18 23 24 25
01 02 05 07 10 11 13 14 15 16 17 18 19 21 25
01 02 03 04 05 06 08 11 13 15 16 18 22 23 25
01 03 04 05 06 07 08 10 11 13 15 16 17 20 25
01 03 05 08 09 10 12 13 15 16 17 19 21 23 25
02 03 04 06 08 09 11 14 17 18 20 21 22 24 25
01 02 03 05 06 07 08 12 13 15 16 17 18 20 23
01 02 03 05 09 12 14 15 17 18 20 22 23 24 25
01 02 03 04 05 07 09 10 14 15 17 18 20 22 25
01 02 03 04 05 06 07 10 11 13 15 16 17 19 21
01 04 05 06 08 09 12 13 15 17 18 19 20 22 23
01 02 03 05 06 08 10 11 12 13 14 20 23 24 25
01 02 04 06 08 12 15 16 17 19 20 22 23 24 25
01 02 05 07 08 09 11 13 14 15 16 18 21 22 23
02 04 05 06 08 09 12 13 14 17 18 19 23 24 25
01 02 03 05 08 09 10 11 13 15 18 20 22 24 25
01 02 04 05 08 09 10 11 12 14 17 18 19 24 25
01 06 11 12 13 15 16 17 19 20 21 22 23 24 25
01 02 03 08 10 11 12 15 17 20 21 22 23 24 25
01 04 09 10 11 12 13 14 15 16 17 20 22 23 25
01 02 04 06 08 12 13 14 15 17 18 19 21 22 24
02 04 05 06 07 09 10 13 17 18 19 20 21 23 24
02 04 08 09 11 12 13 15 16 17 18 21 22 23 24
01 02 03 04 05 10 11 12 14 15 17 18 19 20 22
03 04 06 09 10 12 14 16 17 18 19 21 22 23 24
03 04 06 10 12 13 14 15 17 19 20 22 23 24 25
01 02 05 06 08 10 11 15 17 18 20 22 23 24 25
01 02 03 04 07 10 11 13 14 16 17 20 21 24 25
01 03 04 08 09 10 11 12 13 14 16 17 22 23 25
01 03 06 07 09 10 13 14 16 17 19 20 21 23 24
01 02 03 04 07 09 10 11 12 18 19 21 22 23 25
01 02 03 04 05 07 08 10 11 16 17 18 22 23 25
05 06 07 10 11 13 14 15 16 18 19 21 22 24 25
04 06 07 08 09 10 11 12 13 15 17 19 21 22 25
01 02 03 04 05 06 10 12 13 14 15 17 22 23 25
01 03 04 06 07 08 09 11 12 15 17 18 21 24 25
01 02 04 07 08 09 11 12 14 15 16 18 22 23 25
01 03 05 07 09 11 12 13 16 18 20 21 23 24 25
01 03 04 05 06 12 13 14 17 19 20 21 22 23 25
01 05 06 10 11 12 13 15 17 18 19 21 22 24 25
01 02 03 04 06 10 11 14 15 17 18 19 20 21 23
01 02 04 05 06 08 11 12 13 14 19 20 21 24 25
01 02 03 06 07 08 09 10 11 14 20 21 22 24 25
01 04 05 06 07 09 11 12 13 16 17 18 20 21 25
01 02 09 10 11 12 13 14 16 18 19 20 21 23 25
05 06 07 09 10 11 12 13 14 15 17 18 20 23 25
02 04 05 06 08 12 13 14 15 18 19 21 22 23 24
01 04 06 08 09 10 11 15 17 18 20 21 22 23 24
01 03 05 07 08 11 12 13 15 16 18 19 20 21 24
01 02 04 05 07 09 10 11 12 16 17 18 23 24 25
01 02 04 05 08 09 10 13 15 17 18 20 22 23 25
04 05 06 07 11 12 13 17 18 19 20 21 22 23 24
02 03 04 06 07 09 14 15 16 18 19 20 21 24 25
02 03 04 06 07 09 10 11 12 15 16 21 22 24 25
01 02 03 04 06 07 08 13 14 16 18 21 22 24 25
01 02 03 04 05 07 10 11 12 13 18 19 22 23 25
02 03 04 06 11 13 14 15 16 17 19 20 21 23 25
02 05 06 07 09 11 13 15 18 19 20 21 22 23 25
02 03 04 05 06 09 10 12 13 15 17 19 23 24 25
02 04 05 06 07 08 11 12 13 15 19 20 22 23 25
01 03 04 05 07 09 10 11 14 15 16 17 22 23 25
01 03 04 05 08 09 11 13 15 18 19 20 21 22 23
01 03 05 07 08 10 11 12 13 14 16 17 19 22 25
01 02 05 07 08 10 13 14 15 18 19 20 21 22 25
01 02 03 05 06 09 12 13 14 15 17 21 22 23 24
02 06 08 09 10 11 12 13 16 17 18 19 20 21 25
02 03 04 05 07 08 11 13 15 16 17 21 22 24 25
01 02 07 09 12 14 15 16 17 18 19 21 22 23 24
01 02 03 06 09 10 12 13 15 18 19 20 22 24 25
01 03 07 08 09 10 12 13 16 17 18 19 20 24 25
01 02 04 05 06 07 09 15 16 17 18 19 22 23 24
01 02 08 09 11 13 15 16 17 19 21 22 23 24 25
01 02 04 07 09 11 12 14 17 19 20 21 22 24 25
01 02 03 09 10 11 13 14 15 17 18 20 22 24 25
01 02 05 08 10 11 12 13 14 16 17 22 23 24 25
01 02 04 05 06 10 11 12 13 16 19 21 22 23 25
01 02 04 05 08 09 12 13 16 17 20 21 22 24 25
02 05 07 09 10 13 15 16 17 18 19 20 23 24 25
01 03 05 06 07 08 09 11 14 19 21 22 23 24 25
03 04 05 07 09 10 11 12 13 14 16 18 20 23 24
03 04 05 06 07 08 13 15 17 19 20 22 23 24 25
01 02 04 05 08 11 12 13 17 18 20 21 23 24 25
01 02 03 05 06 09 10 11 13 14 15 16 18 23 24
02 04 05 08 10 11 14 15 16 18 19 20 21 22 24
01 03 04 08 09 10 11 12 13 14 15 19 20 22 23
01 02 04 06 07 09 10 12 14 16 18 19 21 24 25
02 07 08 09 10 11 12 15 16 17 18 19 20 22 23
01 02 03 04 05 06 08 10 11 14 15 17 20 24 25
01 03 04 09 10 11 12 14 15 16 17 19 20 21 24
01 05 08 11 13 15 16 17 18 20 21 22 23 24 25
01 02 03 04 05 06 08 11 12 13 16 18 20 23 24
01 02 03 05 06 07 09 13 14 15 20 21 23 24 25
01 02 03 05 06 08 10 11 14 15 18 21 22 23 24
01 02 04 06 08 09 12 13 14 15 17 18 19 22 25
02 03 04 08 09 10 13 14 15 18 19 20 21 22 23
01 02 03 06 08 09 10 13 14 16 18 19 22 23 24
01 02 03 04 07 10 12 15 16 17 19 20 22 23 24
01 04 05 06 07 08 09 10 11 12 15 16 20 21 24
01 03 04 05 06 07 08 10 13 16 18 20 22 23 25
01 03 04 10 11 12 13 15 16 17 21 22 23 24 25
01 02 04 06 07 09 10 11 12 13 18 20 21 22 25
02 03 04 05 07 08 11 15 19 20 21 22 23 24 25
01 02 04 07 09 10 11 12 13 15 17 20 23 24 25
02 03 05 06 07 11 12 13 14 15 16 18 19 21 24
02 04 10 11 12 13 15 16 17 18 21 22 23 24 25
02 06 07 08 10 11 13 15 16 17 19 20 21 23 24
02 03 04 06 08 09 10 14 16 19 20 21 23 24 25
02 03 04 05 07 09 13 14 15 17 19 22 23 24 25
01 02 03 04 05 06 07 08 10 11 15 17 20 24 25
01 04 05 06 07 08 14 15 16 17 19 20 21 22 23
02 03 04 07 08 09 11 13 14 17 19 21 22 23 25
02 04 06 07 08 11 13 14 16 19 20 21 23 24 25
01 03 07 08 09 10 11 15 16 17 18 19 21 23 25
01 02 04 06 07 08 09 11 12 15 17 19 20 23 25
02 04 05 06 11 12 13 16 17 18 19 22 23 24 25
01 03 11 12 13 15 16 17 18 19 21 22 23 24 25
02 03 05 08 10 11 13 16 19 20 21 22 23 24 25
01 02 04 05 06 07 09 13 16 18 19 20 22 23 24
01 03 04 05 07 08 11 13 14 15 16 18 19 23 24
02 05 08 09 10 12 13 15 17 18 19 20 21 22 23
01 02 03 04 05 06 11 13 14 15 16 21 22 23 24
01 02 03 04 05 08 09 10 14 15 16 19 20 21 25
02 07 08 09 10 12 13 14 15 17 18 21 22 23 25
02 03 04 06 07 08 09 11 12 14 17 18 19 22 23
02 03 04 05 10 14 15 16 17 19 20 22 23 24 25

Avatar
Avatar

I created an excel file, but you can also easily do it.
Start a new Excel spreadsheet.
1. In Cell A1 put in a  header, such as "Nimbers" or anything you choose to call it.
2. Put your 15 numbers in Column A from a2 to a16. 

3. In the B column, type in B1 this, without the quotes:  "=STDEV.S(a2:a16)"

Avatar

ok toke correct  thany you

Avatar

hello true ok conglatulations thank you

Avatar

hello,

It gives error

 

Note that standard deviation is the square root of the variance.

So the formula below is incomplete.

TopEnd of thread (1 page)

Welcome Guest

Your last visit: Wed, Sep 23, 2020, 8:30 pm

Log In

Log InCancel

Forgot your username?

Forgot your password?