Given parameters 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`. Learn more
In Google Sheets, the SERIESSUM() function is used to calculate the sum of a power series based on the parameters provided. A power series is a mathematical series in the form of a0 + a1x^1 + a2x^2 + … + an*x^n, where "a" represents the coefficients and "x" is the variable.
The syntax for the SERIESSUM() function in Google Sheets is: SERIESSUM(x, n, m, a)
Here's what each parameter represents:
x: The value at which the power series is evaluated. n: The number of terms in the power series to include in the calculation. m: The initial power of "x" in the power series. a: The array or range of coefficients for the power series. Here's an example of how you can use the SERIESSUM() function in Google Sheets:
=SERIESSUM(A2, 5, 2, {1, 2, 3, 4, 5})
In this example, the formula calculates the sum of a power series evaluated at the value in cell A2. The power series includes 5 terms, starting with the power of x^2, and the coefficients are provided in the array {1, 2, 3, 4, 5}.