We can input arbitrary values for those parameters on our spreadsheet. Assuming the y-intercept is 0, a quadratic equation has the form: Once you’ve determined the form the equation should have, the next step is to define the parameters for the equation. I’ve just chosen a simple example for this demonstration. Regardless of the complexity of the function, the method I’ll be showing is still valid. I’ve done that with some sample data below, and it’s obvious that we can fit a quadratic function to this data. Usually, the equation you choose will come from prior knowledge of the system you are analyzing.Įither way, it all starts with inspecting the data, and the easiest way to do that is to plot it in a chart. Sometimes this is easy, but other times it will be more difficult. The first step in fitting an equation to data is to determine what form the equation should have. You can use Excel to fit simple or even complex equations to data with just a few steps.
0 kommentar(er)
