Table of Contents
The SERIESSUM function in Google Sheets is a mathematical tool that allows users to calculate the sum of a power series. This function takes in three arguments: the initial value, the step value, and the number of terms in the series. It then uses this information to compute the sum of the series using the formula for a geometric series. This can be useful for various applications such as calculating compound interest or determining the total value of an investment over time. By using the SERIESSUM function, users can easily and accurately calculate the sum of a power series in their Google Sheets spreadsheet.
SERIESSUM
x, n, m, and a, returns the power series sum a1xn + a2x(n+m) + … + aix(n+(i-1)m), where i is the number of entries in range `a`.
Sample Usage
SERIESSUM(1,0,1,{FACT(0),FACT(1),FACT(2),FACT(3),FACT(4)})
SERIESSUM(A2,0,2,B2:B10)
Syntax
SERIESSUM(x, n, m, a)
x– The input to the power series. Varies depending on the type of approximation, may be angle, exponent, or some other value.n– The initial power to which to raisexin the power series.m– The additive increment by which to increasex.a– The array or range containing the coefficients of the power series.
Notes
- Power series may be used to approximate various constants and functions, including e (Euler’s number), logarithms, integrals, trigonometric functions, etc. However, this function is usually used for custom user-defined models.
See Also
SUMSQ: Returns the sum of the squares of a series of numbers and/or cells.
SUMIF: Returns a conditional sum across a range.
SUM: Returns the sum of a series of numbers and/or cells.
QUOTIENT: Returns one number divided by another, without the remainder.
PRODUCT: Returns the result of multiplying a series of numbers together.
MULTIPLY: Returns the product of two numbers. Equivalent to the `*` operator.
MINUS: Returns the difference of two numbers. Equivalent to the `-` operator.
DIVIDE: Returns one number divided by another. Equivalent to the `/` operator.
ADD: Returns the sum of two numbers. Equivalent to the `+` operator.
Examples
[wpcc-iframe height=”300″ src=”https://docs.google.com/spreadsheet/pub?key=0As3tAuweYU9QdHJVcmVqYmgwd2hFQWxYVTVfUUt5QXc&output=html” width=”500″]
Cite this article
stats writer (2024). How can I use the SERIESSUM function in Google Sheets to calculate the sum of a power series?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-the-seriessum-function-in-google-sheets-to-calculate-the-sum-of-a-power-series/
stats writer. "How can I use the SERIESSUM function in Google Sheets to calculate the sum of a power series?." PSYCHOLOGICAL SCALES, 30 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-the-seriessum-function-in-google-sheets-to-calculate-the-sum-of-a-power-series/.
stats writer. "How can I use the SERIESSUM function in Google Sheets to calculate the sum of a power series?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-the-seriessum-function-in-google-sheets-to-calculate-the-sum-of-a-power-series/.
stats writer (2024) 'How can I use the SERIESSUM function in Google Sheets to calculate the sum of a power series?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-the-seriessum-function-in-google-sheets-to-calculate-the-sum-of-a-power-series/.
[1] stats writer, "How can I use the SERIESSUM function in Google Sheets to calculate the sum of a power series?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use the SERIESSUM function in Google Sheets to calculate the sum of a power series?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.