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 ...")
 
 
(11 intermediate revisions by 4 users not shown)
Line 1: Line 1:
<div id="6SpaceContent" class="zcontent" align="left">
+
<div style="font-size:30px">'''SERIESSUM (x,n,m,coefficients)'''</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>coefficients</math>  is the set of coefficients by which each successive power of x is multiplied.
 +
**SERIESSUM(), returns the sum of a power series based on the formula.
  
'''SERIESSUM'''(X, n, m, Coefficients)
+
==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_1 x^n + a_2x^{(n+m)} + a_3x^{(n+2m)} +... + a_jx^{(n+(j-1)m)}  </math>.
 +
*Here <math>x</math> is the power-series value, <math>n</math> is the starting power value, <math>m</math> is the increasing value of a power and <math>a</math> 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 non-numeric.
  
where,
+
==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
 +
#=SERIESSUM(1,1,5,[1]) = 1
  
'''X''' - represents the input value to the power series.
+
==Related Videos==
  
n - represents the intial power to raise x.
+
{{#ev:youtube|A6fbDssPeac|280|center|SERIES SUM}}
  
m -represents the step to increase n for each term in the series.
+
==See Also==
 +
*[[Manuals/calci/SUM| SUM]]
 +
*[[Manuals/calci/PRODUCT| PRODUCT]]
  
Coefficient - represents the set of coefficients for each successive power of x is multiplied.
+
==References==
 +
*[http://en.wikipedia.org/wiki/Series_%28mathematics%29 Series sum]
  
</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>
+
*[[Z_API_Functions | List of Main Z Functions]]
  
</div>
+
*[[ Z3 |   Z3 home ]]
----
 
<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>
 
----
 

Latest revision as of 15:16, 3 July 2018

SERIESSUM (x,n,m,coefficients)


  • 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.
    • SERIESSUM(), returns the sum of a power series based on the formula.

Description

  • This function gives the value of the seriessum of the given set of values.
  • Seriessum is defined by the following formula : .
  • Here is the power-series value, is the starting power value, is the increasing value of a power and 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 non-numeric.

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
  6. =SERIESSUM(1,1,5,[1]) = 1

Related Videos

SERIES SUM

See Also

References