Difference between revisions of "Manuals/calci/GEOMETRICSERIES"

From ZCubes Wiki
Jump to navigation Jump to search
Line 22: Line 22:
 
#GEOMETRICSERIES(3,4,8,5) = 49152
 
#GEOMETRICSERIES(3,4,8,5) = 49152
 
#GEOMETRICSERIES(60.5,9,7) = 60.5 544.5 4900.5 44104.5 396940.5 3572464.5 32152180.5
 
#GEOMETRICSERIES(60.5,9,7) = 60.5 544.5 4900.5 44104.5 396940.5 3572464.5 32152180.5
 +
 +
==Related Videos==
 +
 +
{{#ev:youtube|v=CecgFWTg9pQ|280|center|Geometric Series}}
  
 
==See Also==
 
==See Also==

Revision as of 16:46, 11 January 2019

GEOMETRICSERIES (Start,CommonRatio,Numbers,OnlyNth)


  • is the minimum number of the series.
  • is the difference of the two numbers in the series.


Description

  • This function returns the value of the Geometric Series.
  • In , is the Initial number of the geometric series.
  • is the difference between the numbers.
  • is the number of the terms to display.
  • means it will show the final term of the series.
  • Geometric series means a series of numbers or quantities in geometric progression.
  • So it is the ratio of successive terms in the series is constant.
  • Geometric series using only two terms r and a.
  • The term r is the common ratio,and a is the first term of the series.
  • The sum of the first n terms of a geometric series is:

with and

  • This function will return the result as Error when the parameters are non-numeric.

Examples

  1. GEOMETRICSERIES(3,4,8) = 3 12 48 192 768 3072 12288 49152
  2. GEOMETRICSERIES(3,4,8,5) = 49152
  3. GEOMETRICSERIES(60.5,9,7) = 60.5 544.5 4900.5 44104.5 396940.5 3572464.5 32152180.5

Related Videos

Geometric Series

See Also

References