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  absolutely, which we can do, for example by a use of the ratio test:
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.