Use this spreadsheet to determine the quadratic equation with real solutions, complex solutions, and solutions with radicals.
Example: Real solutions 6 and -2 will compute a sum of 4 and a product of -12. Using the pattern x^2 - sum * x + product = 0 results in the equation x^2 - 4x - 12 = 0
Example: Complex solutions -4 plus/minus 3i. Enter -4 and 3 in the appropriate cells will compute a sum of -8 and a product of 25. Thus x^2 + 8x + 25 = 0
Example: Solutions with radical such as 6 plus/minus radical 2. Enter 6 and 2 in the appropriate cells will compute a sum of 12 and a product of 34. Thus x^2 - 12x + 34 = 0
There are other formulas given that will compute equations from third to sixth degree.
I use this spreadsheet to create higher degree functions for my student to graph on their graphing calculator. We discuss the end behavior of functions, domain and range, zeros, root ( real and imaginary ), x and y intercepts. Division techniques are also discussed. This spreadsheet will help you create higher degree functions and equations that will work out