Difference between revisions of "Manuals/calci/SERIESSUM"

From ZCubes Wiki
Jump to navigation Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''SERIESSUM'''(X, n, m, Coefficients) where, '''X''' - represents the input value to the power series. n ...")
 
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>
 
----
 

Revision as of 03:16, 16 January 2014

SERIESSUM(x,n,m,k)


  • is the power series value.
  • is the initial power value.
  • is the step value to increase the n value for each term.
  • 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 formulaFailed to parse (syntax error): {\displaystyle :SERIESSUM(x,n,m,a)= a_1x^n + a_2x^{(n+m)} + a_3x^{(n+2m)} + … + a_jx^{(n+(j-1)m)} } .
  • 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

  1. SERIESSUM(3,2,2,{1,2,3,4,5,6}) = 3512493
  2. SERIESSUM(1,0,4,{1,2,3}) = 6
  3. SERIESSUM(2,1,5,{2,4,6,8}) = 536836
  4. SERIESSUM(0,2,4,{1,2,3,4,5}) = 0
  5. SERIESSUM(1,0,3,{1,2,3,4,5}) = 15


See Also

References