document.write( "Question 550851: I have a polynomial regression and I am trying to build a calculation to solve for x. The equation I am looking at is x^2+x+b=y. I can calculate the y easy enough, but writing an excel formula to determine X has got me beat.\r
\n" );
document.write( "\n" );
document.write( "thanks \n" );
document.write( "
Algebra.Com's Answer #359206 by scott8148(6628)![]() ![]() You can put this solution on YOUR website! this is an application of the quadratic formula\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "x^2 + x + (b - y) = 0\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "x = {-1 ± [sqrt(1 - 4(b - y))]} / 2\r \n" ); document.write( " \n" ); document.write( "\n" ); document.write( "the ± may generate two values for x; you probably want two equations, one + and one - \n" ); document.write( " |