SERIESSUM
Formulas / SERIESSUMCalculate the sum of a power series.
SERIESSUM(x, n, m, coefficients)
- x - The input value to the power series
- n - The power x to which the first number is to be raised.
- m - The step size that n is increased by, for each successive power of x.
- coefficients - An array of coefficients that multiply each successive power of x.
Examples
=SERIESSUM(A3,0,2,A4:A7)In this example, the SERIESSUM function is used to approximate the cosine of Pi/4 radians. This can be done by using the formula above. The result of this formula is the sum of a power series based on the formula: x + N + M + C where C = PI()/4.
=SERIESSUM(A3,0,2,A4:A7)Another use of the SERIESSUM function is to calculate the sum of a series of numbers. For example, the formula can be used to calculate the sum of the series in cells A4 to A7.
=SERIESSUM(A3,0,2,A4:A7)The SERIESSUM function can also be used to calculate the sum of a series of numbers with a specific exponential factor. For example, the formula can be used to calculate the sum of the series in cells A4 to A7 with an exponential factor of 2.
=SERIESSUM(A3,0,2,A4:A7)The SERIESSUM function can also be used to calculate the sum of a series of numbers with a specific exponential factor and a constant. For example, the formula can be used to calculate the sum of the series in cells A4 to A7 with an exponential factor of 2 and the constant PI()/4.
Summary
The SERIESSUM function is a Sourcetable tool used to calculate the sum of a power series, making it easy to quickly and accurately determine the total of a set of values.
- The SERIESSUM function is used to calculate the sum of a power series of the form: a + a1x + a2x2 + a3x3 + ... + anxn
- The function has three arguments: x, n and m. x is the power series argument, n is the power of the series and m is the number of terms to be added.
- The SERIESSUM function can be used to calculate the sum of an infinite series, as long as the terms of the series tend to zero as n tends to infinity.
- The SERIESSUM function can be used to calculate the sum of a finite series, as long as the number of terms is known.
- The SERIESSUM function can be used in combination with other Sourcetable functions, such as the SUM and SUMIF functions, to calculate the sum of a series of values.
- The SERIESSUM function can be used to calculate the sum of a series of values that are stored in a range of cells.
Frequently Asked Questions
What is the SERIESSUM function?
How is the SERIESSUM function used?
- The first argument is the coefficient of the series.
- The second argument is the power of the series.
- The third argument is the initial value of the series.
What are the benefits of using the SERIESSUM function?
