writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + − '''SERIESSUM'''(X, n, m, Coefficients) − where,+ + + + + + − '''X''' - represents the input value to the power series. − n - represents the intial power to raise x.+ + + + + + − 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.+ − </div> − ---- − <div id="1SpaceContent" class="zcontent" align="left"> − It returns the sum of a power series -+ − − 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> − ----
Manuals/calci/SERIESSUM (view source)
Revision as of 09:16, 16 January 2014
, 09:16, 16 January 2014no edit summary
<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.
==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.
==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
==See Also==
==References==