Re: Measuring Turquoise Underwear

On Sat, 05 May 2007 18:42:08 +0100, Evil Nigel <useweb@xxxxxxxxxx>
wrote:

Stig Holmquist wrote:

Please explain the formula used for std.dev. and what book you used
The std.dev. for sums in the 6/49 game is 32.8, and the std.dev. for
49 integers is 14.14. Where does 12 come from?

Stig Holmquist>


Do you have Excel?
A B C D E F G

1 2 3 4 5 6 =STDEVPA(A1:F1)
1 2 3 47 48 49 =STDEVPA(A2:F2)
=AVERAGE(G1:G2)

The value in G3 = 12.36, a little higher than I calculated the average
population standard deviation of the 14M combinations.

Your calculation of std.dev.for F1 and F2 is based on treating the
data as a population, but they are just samples from a 14 million
large population. Thus if you treat each set as a sample you'll get
1.871 for F1 and 25.211 for F2 with a mean of 13.541.

But there are 43 sets of samples with std.dev. of 1.871 and only one
with 25.211. Also, there is a distribution curve for the std.dev. of
all possible combinations. The shape of that curve is not known.

Thus it seems to me that any calculation based on 12 is poinless.

.

Relevant Pages

  • Re: Measuring Turquoise Underwear
    ... Do you have Excel? ... Since I didn't really know what I was doing and I needed a measure of diverseness, I assumed I could use either population standard deviation or sample standard deviation provided I was consistent throughout. ... there is a distribution curve for the std.dev. ...
    (rec.gambling.lottery)
  • Re: Measuring Turquoise Underwear
    ... population standard deviation of the 14M combinations. ... Make that 'a little lower' - my calculated average is approx. ... there is a distribution curve for the std.dev. ...
    (rec.gambling.lottery)