SERIESSUM

Name

SERIESSUM( x ,n ,m , coeff )

Definition

This function returns the sum of a positive series. 

Syntax

x - input value to the power series

n - first power to which x is to be raised

m - step size that n is increased by, on each successive power of x.

coeff - An array of coefficients that multiply each successive power of x.

#VALUE! - Occurs if any of the supplied arguments are non-numeric.

Step 1 : To begin to use SERIESSUM formula, start with the Excellentable you would like to edi

Step 2 : Then type the SERIESSUM formula into the cell you have chosen to display the outcome:

Step 3 : Type in the complete SERIESSUM formula for a cell as shown below:

Step 4 : Excellentable will generate the outcome when hitting enter. 

	A	B	C
1	State	Coefficient as numbers	Population	Total area in mi2	Land area in mi2	Water area in mi2
2	Alabama	0.785398163	4833722
3	Alaska	1	735132
4	Arizona	-0.5	6626624
5	Arkansas	0.04166	2959373
6	California	-0.001388	38332521
7
8		0.707100887

	D	E	F
1

House seat(s)

52,420 (135,767)

50,645 (131,170)

1,775 (4,597)

665,384 (1,723,337)

570,641 (1,477,950)

94,743 (245,383)

113,990 (295,233)

113,594 (294,207)

396 (1,026)

53,179 (137,733)

52,035 (134,770)

1,143 (2,960)

163,695 (423,968)

155,779 (403,466)

7,916 (20,502)

7

1

9

4

53