![]() 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. Excel finds the other solution (x = -1) if you start with an x-value closer to -1. 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. For a more detailed explanation of these results, see any standard statistics reference text.3. Using these results, the regression model can be written as: Median Value of Owner Occupied Home = 33.6 – 6.597 * CRIM. In this tutorial, we will walk you through the steps to create a regression equation in Excel, so you can harness the power of this popular spreadsheet software for your data analysis needs.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |