| Line 1: |
Line 1: |
| − | <div id="6SpaceContent" class="zcontent" align="left"> | + | <div style="font-size:30px">'''SERIESSUM(x,n,m,k)'''</div><br/> |
| | + | *<math>x</math> is the power series value. |
| | + | *<math>n</math> is the initial power value. |
| | + | *<math> m</math> is the step value to increase the n value for each term. |
| | + | *<math> k</math> is the set of coefficients by which each successive power of x is multiplied. |
| | | | |
| − | '''SERIESSUM'''(X, n, m, Coefficients)
| |
| | | | |
| − | where,
| + | ==Description== |
| | + | *This function gives the value of the seriessum of the given set of values. |
| | + | *Seriessum is defined by the following formula<math>:SERIESSUM(x,n,m,a)= a_1x^n + a_2x^{(n+m)} + a_3x^{(n+2m)} + … + a_jx^{(n+(j-1)m)} </math>. |
| | + | *Here x is the powerseries value, n is the starting power value,m is the increasing value of a power and a is the set of coefficients. According to the number of coefficients , the number of terms of the power series also get varies. |
| | + | *For example there 5 values in coefficients, then 5 terms will be there in power series. |
| | + | This function will give the result as error when any one of the argument is nonnumeric. |
| | | | |
| − | '''X''' - represents the input value to the power series.
| |
| | | | |
| − | n - represents the intial power to raise x.
| + | ==Examples== |
| | + | #SERIESSUM(3,2,2,{1,2,3,4,5,6}) = 3512493 |
| | + | #SERIESSUM(1,0,4,{1,2,3}) = 6 |
| | + | #SERIESSUM(2,1,5,{2,4,6,8}) = 536836 |
| | + | #SERIESSUM(0,2,4,{1,2,3,4,5}) = 0 |
| | + | #SERIESSUM(1,0,3,{1,2,3,4,5}) = 15 |
| | | | |
| − | m -represents the step to increase n for each term in the series.
| |
| | | | |
| − | Coefficient - represents the set of coefficients for each successive power of x is multiplied.
| + | ==See Also== |
| | | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="1SpaceContent" class="zcontent" align="left">
| |
| | | | |
| − | It returns the sum of a power series -
| + | ==References== |
| − | | |
| − | SERIES(X, n, m, k) =a<sub>1</sub>X<sup>n </sup>+ a<sub>2</sub>X<sup>(n+m)</sup> + a<sub>3</sub>X<sup>(n+2m)</sup>
| |
| − | | |
| − | +.......+a<sub>i</sub>X<sup>(n+(i-1)m)</sup>
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="7SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | If any parameters is nonnumeric, SERIESSUM returns NaN.
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="12SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="left">
| |
| − | | |
| − | SERIESSUM
| |
| − | | |
| − | </div></div>
| |
| − | ----
| |
| − | <div id="8SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | Lets see an example in (Column3, Row1)
| |
| − | | |
| − | <nowiki>=SERIESSUM(R1C1, 0, 4, R3C1:R4C1)</nowiki>
| |
| − | | |
| − | SERIESSUM returns 0.135294.
| |
| − | | |
| − | </div>
| |
| − | ----
| |
| − | <div id="10SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Syntax </div><div class="ZEditBox"><center></center></div></div>
| |
| − | ----
| |
| − | <div id="4SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Remarks </div></div>
| |
| − | ----
| |
| − | <div id="3SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Examples </div></div>
| |
| − | ----
| |
| − | <div id="11SpaceContent" class="zcontent" align="left"><div class="ZEditBox" align="justify">Description </div></div>
| |
| − | ----
| |
| − | <div id="2SpaceContent" class="zcontent" align="left">
| |
| − | | |
| − | {| id="TABLE3" class="SpreadSheet blue"
| |
| − | |- class="even"
| |
| − | | class=" " |
| |
| − | | Column1
| |
| − | | class=" " | Column2
| |
| − | | class=" " | Column3
| |
| − | | Column4
| |
| − | |- class="odd"
| |
| − | | class=" " | Row1
| |
| − | | class=" " | 0.5
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="even"
| |
| − | | class=" " | Row2
| |
| − | | class=" sshl_f " | 0.126
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="odd"
| |
| − | | Row3
| |
| − | | class=" " | 0.1487
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="even"
| |
| − | | Row4
| |
| − | | class="sshl_f" | 0.135294
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="odd"
| |
| − | | class=" " | Row5
| |
| − | | class=" SelectTD ChangeBGColor SelectTD" |
| |
| − | <div id="2Space_Handle" class="zhandles" title="Click and Drag to resize CALCI Column/Row/Cell. It is EZ!"></div><div id="2Space_Copy" class="zhandles" title="Click and Drag over to AutoFill other cells."></div><div id="2Space_Drag" class="zhandles" title="Click and Drag to Move/Copy Area.">[[Image:copy-cube.gif]] </div>
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |- class="even"
| |
| − | | Row6
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | | class=" " |
| |
| − | |}
| |
| − | | |
| − | <div align="left">[[Image:calci1.gif]]</div></div>
| |
| − | ----
| |