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.

Power trend lines in excel 2016