Quadratic Equations.xls
Description
Quadratic Equation Solver with Graph
Finds the two real roots of a quadratic equation ax² + bx + c = 0, checks each root by substituting it back into the equation, and plots the curve with both roots marked so the answer can be seen as well as calculated.
Method
The quadratic formula, x = (−b ± √(b² − 4ac)) / 2a, with a discriminant check that the roots are real. The chart is drawn through points spaced either side of the roots, so it rescales automatically for any equation.
Inputs
- Coefficients a, b and c
- An optional sample value of x at which to evaluate f(x)
Outputs
- f(x) at the sample value
- A validity check (“Valid” when the roots are real and distinct)
- Roots x1 and x2, each with f(x) evaluated at the root as a check (zero)
- A chart of f(x) against x showing where the curve crosses the axis
The example, x² + 5x − 5 = 0, gives roots 0.8541 and −5.8541. Dimensionless; no units are needed.
Please note
- Real roots only. If b² < 4ac the roots are complex, the check reads “Not Valid!” and the root cells show #NUM!. A repeated root (b² = 4ac) is also flagged “Not Valid!”, although the root shown is correct (the chart then collapses to a single point, as its x range is set from the gap between the roots).
- a must not be zero (the equation is then linear).
- No macros. The workbook has two sheets: a plain Excel version with the equations shown as pictures, and an XLC version whose equations update live and need the free XLC add-in.
Calculation Preview
Full download access to any calculation is available to users with a paid or awarded subscription (XLC Pro).
Subscriptions are free to contributors to the site, alternatively they can be purchased.
Click here for information on subscriptions.
Comments: 3
×