When, Principal = $4000, rate = 5/100 that is 0.05, n =12 (compounded monthly), time =5 years.If an amount of $4,000 is deposited into an account (saving) at an interest rate of 5% annually, compounded monthly, the value of the investment after 5 years can be calculated using the above compound interest formula.Where r is the interest rate, n is the number of times interest is compounded per year, and t is the time.It plays a crucial role in generating higher rewards from an investment. Suppose we have to find out the compound interest Compound Interest Compound interest is the interest charged on the sum of the principal amount and the total interest amassed on it so far. So, we can use the POWER function in Excel for different mathematical calculations. Using the same formula for other POWER function equations, we have: The formulas are concatenated with the string “Roots of equation are.” To implement this in Excel formula, we will use the POWER function in Excel and the formula will be: If we mathematically solve them using the above formula, we have the roots -15.5 and 1.5. In the first POWER function equation, a=4, b=56, and c = -96. We have five quadratic POWER function equations, and we will solve them using the formula with the help of the POWER function in Excel to find the roots. ^ is the exponential operator used to represent the power (exponent). But, first, we need to find the roots of the equations. Now, we have a list of quadratic POWER function equations given in column A. The roots of the quadratic POWER function equation are computed by following mathematical formula:ī2-4ac is called discriminant and describes a quadratic POWER function equation’s number of roots. The solution of this POWER function equation gives the roots of the equation, which are the values of x. In algebra, we have the quadratic POWER function equation, represented as ax2+bx+c=0, where x is unknown, and a, b and c are the coefficients. So, we get a linear, exponential graph for the given POWER function equation. Now, selecting the values of x and y from range B4:K5, choose the graph (in this example, we have chosen the scatter graph with smooth lines) from the “Insert” tab. 2 nd value of y will be 4^2 (=POWER(4,2).1 st value of y will be 2^2 (=POWER(2,2).So, in this case, since the value of y depends upon the nth power of x, we will calculate the value of Y using the POWER function in Excel.