Difference between revisions of "Manuals/calci/GEOMETRICSERIES"
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
- GEOMETRICSERIES(3,4,8) = 3 12 48 192 768 3072 12288 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