Posted by: Gary Ernest Davis on: November 5, 2013

Excel has many statistical functions. Here is a description of one of the most commonly used: AVERAGE

Posted by: Gary Ernest Davis on: November 5, 2013

We learn early in a study of infinite series that the geometric series sums to 1.

Sometimes you will see this sort of reasoning:

so so

which is somewhat suspect in light of Euler’s “argument”:

so .

We need first to know that converges

the term of divided by the term is 1/2 <1.

Another application of the ratio test shows that the series is absolutely convergent:

the of this series is , the term is and their ratio is which approaches as .

If we denote then a simple, and legitimate, calculation shows that which we know to be .

In fact, for any natural number the ratio test shows that the series is absolutely convergent.

A Mathematica® calculation:

**TableForm[Table[{p, Limit[Sum[k^p/2^k, {k, 1, n}], n -> Infinity]}, {p, 0, 10}], TableHeadings -> {None, {“p”, “S(p)”}}]**

yields the following results for :

The first curious thing is that the results are all whole numbers. Why is that?

The second curious thing is that if we enter this sequence of whole numbers into the The On-Line Encyclopedia of Integer Sequences we get a match:

these whole numbers match the number of necklaces of partitions of p+1 labeled beads. They also match the sequence of cumulants of the probability distribution of the number of tails before the first head in a sequence of fair coin tosses. Is that right? If so, why? is the first really interesting case.

A detailed account of these and similar series is dealt with by Mircea Cîrnu “Determinantal formulas for sum of generalized arithmetic-geometric series” Boletn de la Asociacion Matematica Venezolana, Vol. XVIII, No. 1 (2011), 13-25.

Enjoy! It’s connections like these that give mathematicians a buzz.