You can clearly see the solutions x = -1 and x = 5. If you're interested, you can download the accompanying Excel file.Įxplanation: the points where the curve intersects the horizontal line represent the solutions to the quadratic equation for the given y-value. Create an XY scatter chart and add a horizontal line (y = 24.5) to the chart. Populate column A with multiple x-values and find their corresponding y-values by dragging the formula in cell B2 down.ġ1. Let's visualize the solutions of y = 3x 2 - 12x + 9.5 = 24.5.ġ0. In this case, set 'To value' to 0.īonus! Improve your understanding of quadratic equations by visualizing the solutions on a chart. To find the roots, set y = 0 and solve the quadratic equation 3x 2 - 12x + 9.5 = 0. For example, enter the value 0 into cell A2 and repeat steps 5 to 9. Click on any link to learn more about a method. Below are the 4 methods to solve quadratic equations. In other words, a quadratic equation must have a squared term as its highest power. ![]() Excel finds the other solution (x = -1) if you start with an x-value closer to -1. A quadratic equation is an equation that can be written as ax ² + bx + c where a 0. Click in the 'By changing cell' box and select cell A2. Click in the 'To value' box and type 24.5Ĩ. On the Data tab, in the Forecast group, click What-If Analysis.ħ. You can use Excel's Goal Seek feature to obtain the exact same result. But what if we want to know x for any given y? For example, y = 24.5.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |