Re: Measuring Turquoise Underwear

Stig Holmquist wrote:
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.

Make that 'a little lower' - my calculated average is approx. 12.72.



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.

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. I leaned towards population rather than sample because the combo 1-2-3-4-5-6 is a complete population - there are no more members, the values of which are unknown.


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.

That's what I said. However the stats book didn't specify that the distribution had to be normal. Apart from the end bits, which are rather small in comparison to 14 million, it probably is very bell-curve-ish.


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


I'm open to suggestions for better methods of analysis.

BTW, I owe you substantial thanks. You're the first person to have a good read of what I'm trying to calculate and make intelligent feedback.

Evil Nigel

.

Relevant Pages

  • Re: Measuring Turquoise Underwear
    ... 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. ... However the stats book didn't specify that the distribution had to be normal. ... Evil Nigel ...
    (rec.gambling.lottery)
  • Re: Measuring Turquoise Underwear
    ... 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. ... However the stats book didn't specify that the distribution had to be normal. ... Evil Nigel ...
    (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)
  • Re: two-sample t-test question.
    ... Are you implying that you want to compare the means of the two ... should i use the standard deviation of the sample mean ... sample mean or the estimate of the population standard deviation. ... "When you get the choice to sit it out or dance, ...
    (sci.stat.math)
  • Re: Measuring Turquoise Underwear
    ... Do you have Excel? ... population standard deviation of the 14M combinations. ... there is a distribution curve for the std.dev. ... Thus it seems to me that any calculation based on 12 is poinless. ...
    (rec.gambling.lottery)